/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

4 votes267 views4 answers
Convert list of integer to array in java
Java
0 vote292 views1 answer
Javafx combobox cell
Java
0 vote287 views1 answer
Terminate function calling in java
Java
35 votes278 views2 answers
Remoce last character froma java string
Java
2 votes331 views1 answer
Springboot starter jpa
Java Spring
0 vote264 views1 answer
Disable listview readonly
Java
1 vote292 views2 answers
Handler delay android
Java
0 vote281 views1 answer
Java detect new line in string
Java
4 votes309 views2 answers
Close scanner java
Java
0 vote253 views1 answer
How to return string in java
Java