/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 vote156 views1 answer
If statements not working java
Java
2 votes176 views2 answers
Adjust font scale in android studio
Java
2 votes166 views1 answer
Maven pom java 11
Java
26 votes295 views2 answers
Java random numbers in specific range
Java
0 vote175 views3 answers
Java regex 10 digit number
Java
1 vote172 views1 answer
How to increment character in java
Java
0 vote190 views5 answers
Pasar ejercicios de pseint a java
Java
0 vote161 views1 answer
Split the argument String and add the tokens into a list
Java
20 votes171 views6 answers
Convert char to string java
Java
0 vote159 views1 answer
Android studio allow http
Java