/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 vote216 views1 answer
ClassNotFoundException: org.springframework.ui.freemarker.FreeMarkerConfigurationFactory
Java Spring
5 votes187 views2 answers
Why main method is public static void in java
Java
0 vote205 views1 answer
Swagger apiimplicitparam all endpoints
Java
0 vote194 views1 answer
Java get JComboBox value
Java
0 vote183 views1 answer
Install java in wsl2
Java
0 vote186 views1 answer
How to set opacity of background android
Java
3 votes186 views3 answers
Java max array
Java
1 vote234 views1 answer
Convert ASCII to String Java
Java
7 votes199 views2 answers
How to add the last area of an array in java
Java
19 votes237 views4 answers
Exception e in java
Java