lundi 18 avril 2016

set text to TextView From Database

I am a novice Android Programming

i use android sqlite asset helper lib to working with Database

problem with set Text to text View from Database My Database have A table and 3 columns

1- id

2- Content //this is long text Content

3- list

list is ok But Content No

help me Please

db.java

Public class DB extends SQLiteAssetHelper {
    private static final String DATABASE_NAME = "quotes.db";
    private static final int DATABASE_VERSION = 1;

    public DB(Context context) {
        super(context, DATABASE_NAME, null, DATABASE_VERSION);
    }

DbAccsess.java

public class DbAccess {
    private SQLiteOpenHelper openHelper;
    private SQLiteDatabase database;
    private static DbAccess instance;


    private DbAccess(Context context) {
        this.openHelper = new DB(context);
    }


    public static DbAccess getInstance(Context context) {
        if (instance == null) {
            instance = new DbAccess(context);
        }
        return instance;
    }

    public void open() {
        this.database = openHelper.getWritableDatabase();
    }


    public void close() {
        if (database != null) {
            this.database.close();
        }
    }

    public List<String> getQuotes() {
        List<String> list = new ArrayList<>();
        Cursor cursor = database.rawQuery("SELECT * FROM quotes", null);
        cursor.moveToFirst();
        while (!cursor.isAfterLast()) {
            list.add(cursor.getString(0));
            cursor.moveToNext();
        }
        cursor.close();
        return list;
    }
}

Main.java

private ListView listView;
private TextView txtView;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);

        this.listView = (ListView) findViewById(R.id.listView);
        this.txtView = (TextView) findViewById(R.id.TxtView); 
        DbAccess dbAccess = DbAccess.getInstance(this);
        dbAccess.open();
        List<String> quotes = dbAccess.getQuotes();
        dbAccess.close();

        ArrayAdapter<String> adapter = new ArrayAdapter<String>(this, android.R.layout.simple_list_item_1, quotes);
        this.listView.setAdapter(adapter);
    }
}

help me To set Content to TextView

Aucun commentaire:

Enregistrer un commentaire