/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

-1 vote314 views1 answer
Java array repeating
Java
0 vote315 views1 answer
Framboise bleue ou mure
Java
0 vote338 views2 answers
How to add background color in jframe
Java
1 vote308 views1 answer
Java list string package import
Java
17 votes297 views5 answers
Constructor
Java
0 vote381 views1 answer
System.out.printf("%"+(n)+"s \n")
Java
0 vote324 views1 answer
Day of week integer to name of day in java
Java
0 vote369 views1 answer
Java pattern matching 16
Java
1 vote303 views1 answer
How to copy an object in java
Java
12 votes488 views2 answers
Run spring boot application command line
Java Spring