/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 vote142 views1 answer
Edittext editable false android java
Java
0 vote134 views2 answers
Java awt bild einfügen
Java
-2 votes160 views3 answers
Hashset java
Java
1 vote171 views2 answers
Spigot heal player
Java
0 vote159 views1 answer
Como crear un array list en java
Java
0 vote141 views1 answer
Intent pick action video android
Java
3 votes150 views1 answer
Android clear specific sharedpreference value
Java
1 vote153 views1 answer
How to find the largest number in a 2d array java
Java
0 vote194 views1 answer
Anulom vilom in english
Java
0 vote145 views1 answer
Java string vers int
Java