/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 vote222 views1 answer
Spring scheduled
Java Spring
1 vote185 views1 answer
How to get elements of a list in java
Java
1 vote189 views1 answer
Java add element to map
Java
1 vote186 views1 answer
Json array get json object
Java
0 vote218 views1 answer
How to change color page in latex
Java
1 vote203 views1 answer
Add text to jlable
Java
0 vote199 views1 answer
Multi dimensional array declaration in java
Java
0 vote196 views1 answer
Print java object inherited classes
Java
3 votes199 views1 answer
Keytool command sha256
Java
140 votes210 views18 answers
Java hello
Java