/Java/Get data from database sqlite android

Get data from database sqlite android

//Put this in your DAO or actyvity

public ArrayList<yourclass> getfromdatabase() {
String strSql = "select * from yourtable";
getdatabase = new ArrayList<yourclass>();
SQLiteDatabase db = dbHelper.getReadableDatabase();
Cursor c = db.rawQuery(strSql, null);
if (c.moveToFirst()) {
do {
      yourclass = new yourclass();
      yourclass.setId(c.getInt(c.getColumnIndex("yourcolumnname")));
      yourclass.setTitulo(c.getString(c.getColumnIndex("yourcolumnname")));
      yourclass.setTexto(c.getString(c.getColumnIndex("yourcolumnname")));
      yourclass.setTipo(c.getString(c.getColumnIndex("yourcolumnname")));
      getdatabase.add(yourclass);
   } while (c.moveToNext());
}
     return getdatabase;
}

Similar codes

5 votes320 views1 answer
How to convert object to list in java
Java
0 vote311 views1 answer
Merge sort algorithm in java short answer
Java
0 vote282 views1 answer
Run app by package android
Java
0 vote320 views1 answer
Arraylist how to add at 0 java
Java
0 vote316 views1 answer
Java-util of geofence polygon
Java
1 vote283 views3 answers
Java zahlen runden auf 1 nachkommastelle
Java
0 vote316 views1 answer
Android set socket timeout
Java
49 votes320 views6 answers
Java iterate hashmap
Java
0 vote355 views1 answer
Check character is alphanumeric java
Java
0 vote307 views1 answer
Reading
Java