/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 vote217 views1 answer
Attempt to invoke virtual method 'int java.util.Random.nextInt(int)' on a null object reference
Java
89 votes261 views4 answers
Java split on {
Java
0 vote255 views2 answers
Amstrong
Java
1 vote238 views1 answer
Java take screenshot
Java
18 votes238 views2 answers
How to get int from string java
Java
2 votes251 views2 answers
Find Numbers with Even Number of Digits
Java
0 vote281 views1 answer
Path in spring form
Java Spring
0 vote227 views1 answer
Java suppress warnings rawtypes
Java
0 vote264 views1 answer
Model mapper with Page
Java
1 vote237 views1 answer
Find Numbers with Even Number of Digits leetcode
Java