I am new to android and especially to sqlite so please bear with me.
I want to ask, how can I retrieve all the data from android DB and display them to android layout without pressing any button?
Here is my code from the database class:
// Getting All Contacts
public List<Contact> getAllContacts() {
List<Contact> contactList = new ArrayList<Contact>();
String selectQuery = "SELECT * FROM " + TABLE_CS;
SQLiteDatabase db = this.getWritableDatabase();
Cursor cursor = db.rawQuery(selectQuery, null);
if (cursor.moveToFirst()) {
do {
Contact contact = new Contact();
contact.setId(Integer.parseInt(cursor.getString(0)));
contact.setName(cursor.getString(1));
contact.setTime(Integer.parseInt(cursor.getString(2)));
contactList.add(contact);
} while (cursor.moveToNext());
}
return contactList;
}
but I am not sure how to get this list view to my MainActivity, what I have done is something like this:
listView = (ListView) findViewById(R.id.list_data);
new Handler().post(new Runnable() {
@Override
public void run() {
customAdapter = new CustomCursor(MainActivity.this, DB.getAllContacts());
listView.setAdapter(customAdapter);
}
});
Which of course gives error because I am calling a non-static method from a static context. How should I call GetAllContacts from my MainActivity?
Aucun commentaire:
Enregistrer un commentaire