/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 vote151 views1 answer
Java session timeout
Java
0 vote129 views1 answer
Exception in thread "main" java.lang.numberformatexception: for input string: ""
Java
0 vote133 views1 answer
Android snackbar message is behind back button
Java
0 vote167 views1 answer
Hystrix configuration spring boot
Java Spring
50 votes156 views6 answers
Char array to string in java
Java
0 vote135 views1 answer
Share location in android programmatically
Java
1 vote149 views1 answer
L,og in android studio
Java
5 votes96 views1 answer
Is a relationship concept java
Java
0 vote136 views1 answer
Java string split from input string
Java
0 vote126 views1 answer
Java 14 switch
Java