/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

10 votes269 views3 answers
Float java
Java
0 vote283 views1 answer
Java add xmlns attribute
Java
30 votes295 views6 answers
Reverse string in java
Java
0 vote277 views1 answer
LayerRenderer
Java
2 votes282 views1 answer
Java cast duration to long
Java
0 vote494 views2 answers
How to use java 8 comparator
Java
1 vote418 views1 answer
Java.lang.nullpointerexception: cannot invoke "java.lang.charsequence.length()" because "this.text" is null
Java
0 vote287 views1 answer
Java platform runlater keeps running
Java
0 vote283 views1 answer
How to get system date in android
Java
10 votes345 views1 answer
Java try catch
Java