/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 vote134 views1 answer
Find the length of jtextfeild in java
Java
2 votes166 views1 answer
Java for range loop
Java
0 vote174 views1 answer
Filter and map multiple fields from java stream
Java
0 vote134 views1 answer
Antialiasing kjava
Java
4 votes164 views1 answer
Read integer input java
Java
0 vote133 views2 answers
How to find the largest number in java
Java
2 votes148 views1 answer
Copy array in java 2d
Java
0 vote150 views1 answer
Arrotondare un numero a 2 cifre dopo la virgola java
Java
0 vote132 views1 answer
Import txt.xz file to android studio app
Java
1 vote137 views1 answer
Events that people think are unlikely but actually have high probability
Java