/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

15 votes166 views5 answers
How to get 2 decimal places in java
Java
0 vote165 views1 answer
How to use base64.getdecoder() android
Java
5 votes176 views2 answers
Explain JDK, JRE and JVM?
Java
0 vote198 views1 answer
Java program to search item from name in class
Java
2 votes175 views1 answer
Should i learn kotlin or java
Java
3 votes184 views2 answers
Java create file in folder
Java
0 vote172 views2 answers
Boolean checkbox swing
Java
0 vote198 views1 answer
Get intersection of two lists java
Java
-1 vote184 views1 answer
Directory size java
Java
0 vote149 views1 answer
Eureka Exception encountered during context initialization
Java