/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 vote186 views1 answer
Separateur JMenu swing java
Java
1 vote178 views1 answer
Java how to check string is number
Java
14 votes259 views4 answers
Java create txt file
Java
28 votes149 views6 answers
Height of binary tree java
Java
0 vote205 views1 answer
How to disable the auto-configuration?
Java
11 votes177 views2 answers
Css div click through
Java
1 vote187 views1 answer
Java interfce
Java
0 vote211 views1 answer
Javax big int validation in spring boot
Java Spring
2 votes218 views3 answers
List in java
Java
0 vote187 views1 answer
Recursion of numbers in decending order in java
Java