/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

2 votes207 views1 answer
Has been compiled by a more recent version of the Java Runtime (class file version ), this version of the Java Runtime only recognizes class file versions up to
Java
0 vote212 views1 answer
Previous method in jdbc
Java
5 votes225 views1 answer
What is primitive data type in java
Java
0 vote220 views1 answer
How to use Log android studio Java
Java
-1 vote210 views2 answers
Access activity method from adapter
Java
0 vote275 views1 answer
Spigot hide player
Java
1 vote209 views1 answer
What is the use of println
Java
15 votes226 views4 answers
Reverse int array java
Java
0 vote222 views1 answer
Fizzbuzz java
Java
1 vote220 views1 answer
Final method meaning
Java