/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

5 votes243 views1 answer
Dependency for spring security
Java
0 vote310 views1 answer
Java string regexp replace
Java
0 vote275 views1 answer
Read File and Resource in JUnit Test into Stream
Java
1 vote304 views1 answer
How to get logarithm in java
Java
8 votes307 views3 answers
Java delay
Java
7 votes305 views1 answer
Java for character c in string iterate cout i
Java
1 vote307 views1 answer
How to implement linked list in java without using collection framework
Java
0 vote376 views3 answers
Spring boot sql logging
Java Spring
-1 vote297 views1 answer
Difference between print and println in java
Java
2 votes274 views1 answer
Character.getNumericValue['z']
Java