/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 vote149 views2 answers
Bootstrap 4 modal get event related target
Java
2 votes163 views3 answers
Convert java to kotlin online editor
Java
1 vote123 views1 answer
Combination
Java
41 votes168 views3 answers
Java loop hashmap
Java
0 vote193 views1 answer
How to make bidirectional fromated binding
Java
1 vote151 views6 answers
Convert java to python
Java
1 vote145 views1 answer
Java cached enum
Java
0 vote204 views1 answer
Java pattern matching 16
Java
0 vote192 views1 answer
Create all possible substrings of a string java
Java
0 vote166 views1 answer
How to code the overdraft limit in Java
Java