/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 vote123 views1 answer
PlatformException (PlatformException(error, Neither user 10024 nor current process has android.permission.WAKE_LOCK., null, java.lang.SecurityException: Neither user 10024 nor current process has android.permission.WAKE_LOCK.
Java
4 votes166 views5 answers
How to use while loop in java
Java
-1 vote119 views2 answers
Java casting method
Java
0 vote217 views1 answer
Viewresolver in spring boot
Java
0 vote134 views1 answer
Arrondi java
Java
0 vote156 views1 answer
Entity cannot be resolved to a type in spring boot eclipse
Java Spring
3 votes123 views2 answers
How to get the max value of an array java
Java
0 vote162 views1 answer
How to find prime numbers in java
Java
0 vote154 views1 answer
Java.lang.noclassdeffounderror: javax/xml/bind/jaxbexception
Java
3 votes135 views1 answer
Howow to use font object Java
Java