/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 vote183 views1 answer
Import r android
Java
107 votes265 views6 answers
Java switch
Java
5 votes191 views1 answer
Get file path java
Java
0 vote192 views1 answer
Import txt.xz file to android studio app
Java
1 vote200 views1 answer
On offline event spigot example
Java
0 vote228 views1 answer
Spring commandlinerunner example
Java Spring
0 vote181 views1 answer
Comparable on a generic class java
Java
0 vote185 views1 answer
Añadir objetos de diferentes clases en una misma lista
Java
0 vote218 views1 answer
Database springboot
Java Spring
30 votes177 views3 answers
String to Char array
Java