/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 vote126 views1 answer
Mutable string in java
Java
1 vote130 views1 answer
Java stream sorted reverse
Java
0 vote123 views1 answer
Split with scquere braket in java
Java
0 vote121 views1 answer
Minecraft bukkit coding player sharing variable
Java
0 vote144 views1 answer
ViewResolver
Java
0 vote121 views1 answer
Android frame to bitmap is null
Java
4 votes145 views1 answer
Concurrentmodificationexception android
Java
44 votes165 views10 answers
Youtube
Java
0 vote133 views1 answer
Initialize arraylist in 1 line in java
Java
0 vote171 views1 answer
Select max value from list java
Java