/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 vote448 views1 answer
Spring commandlinerunner example
Java Spring
22 votes338 views2 answers
Java close application
Java
9 votes363 views3 answers
Function in java
Java
1 vote343 views1 answer
Powershell.exe location
Java
0 vote339 views1 answer
Generic variable java
Java
0 vote387 views1 answer
Generate an array with random numbers in a range java
Java
0 vote378 views1 answer
Creategoogle maps marker with custom image/bitmap
Java
0 vote335 views1 answer
Javafx get listview fxml id
Java
7 votes403 views1 answer
Convert string to localdatetime
Java
4 votes378 views2 answers
How to use decimal format java
Java