/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

1 vote189 views1 answer
Spring serve robots.txt
Java
1 vote181 views1 answer
Java jcheckbox get value
Java
2 votes197 views1 answer
Android studio change launcher icon
Java
0 vote182 views10 answers
Arrays with for loops
Java
3 votes223 views2 answers
Java vs python
Java
0 vote168 views2 answers
Convert int color to hex android
Java
9 votes157 views1 answer
Ova definition
Java
3 votes159 views2 answers
Processing load font from file
Java
0 vote179 views1 answer
Background for anchor in javafx
Java
0 vote178 views1 answer
27*5
Java