/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

0 vote294 views1 answer
Algorithms - decision
Java
-1 vote284 views1 answer
Accessing 2d array in java
Java
0 vote287 views1 answer
Empty string databinding android
Java
3 votes296 views2 answers
How to get SHA fingerprint from jks file?
Java
0 vote291 views1 answer
Timestamp with zone java
Java
0 vote268 views1 answer
Java print stack
Java
0 vote312 views1 answer
Android pick up photo from local device
Java
0 vote292 views1 answer
Java url
Java
0 vote273 views1 answer
Android set socket timeout
Java
2 votes431 views1 answer
Java unsigned int
Java