/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 vote261 views1 answer
How to see list of java of versions in mac
Java
0 vote234 views1 answer
What is marshalling and unmarshalling in java
Java
0 vote294 views1 answer
Fibonacci numbers using Recursion in Java
Java
0 vote252 views1 answer
RNGestureHandlerButtonViewManager.java uses or overrides a deprecated API
Java
2 votes233 views1 answer
Java repeat loop cycle for
Java
3 votes248 views1 answer
How to create textview programmatically in android
Java
0 vote243 views1 answer
Java toggle button get state
Java
0 vote271 views1 answer
Add close button on right top corner of alert dialog box for android
Java
2 votes265 views1 answer
For with two values java
Java
6 votes249 views1 answer
Android studio webview mailto
Java