/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 vote118 views1 answer
1.13. programacion orientada a objetos en java
Java
0 vote116 views1 answer
How to change numbers to English in printf
Java
3 votes125 views2 answers
Java create file in folder
Java
0 vote131 views1 answer
Java scanner tokens with withespace
Java
0 vote116 views1 answer
How to overwrite a text file in java
Java
1 vote137 views1 answer
Bukkit debug message
Java
1 vote115 views1 answer
Java callbacks
Java
0 vote132 views1 answer
Java code for scientific calculator GUI
Java
0 vote164 views1 answer
Echo java
Java
1 vote114 views2 answers
Java pass method as parameter
Java