/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 vote187 views1 answer
Java socket connect to gmail
Java
1 vote289 views2 answers
Get preference value android
Java
-2 votes176 views1 answer
How to implements interface in java
Java
10 votes316 views2 answers
Change the default port in spring boot codegrepper
Java
0 vote199 views1 answer
How to delete character certain index in java
Java
0 vote206 views1 answer
Laravel Please update to at least Node v12.14
Java
9 votes196 views5 answers
Flutter image
Java
0 vote189 views1 answer
How to explicitly declare an array java
Java
0 vote257 views1 answer
How to make bidirectional fromated binding
Java
6 votes220 views1 answer
Java int to binary string
Java