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