/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

3 votes334 views1 answer
How to truncate decimals in java
Java
0 vote330 views1 answer
How to reinstall nginuity
Java
38 votes321 views5 answers
Android internet permission
Java
0 vote344 views2 answers
How to send gmail using spring boot in java code
Java Spring
0 vote350 views1 answer
Document inserted succesfully but not present in the collection java
Java
1 vote338 views1 answer
Error: cannot find [email protected](
Java
-1 vote320 views2 answers
Java servlet 4.0 download
Java
6 votes308 views3 answers
Minecraft mod
Java
0 vote313 views1 answer
Generic variable java
Java
0 vote323 views2 answers
How to convert int array to Integer List in java
Java