/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

4 votes148 views1 answer
Convert string to byte java
Java
0 vote183 views1 answer
Spring mvc aop transaction management
Java Spring
3 votes147 views5 answers
Declare variable java
Java
4 votes173 views2 answers
The superclass "javax.servlet.http.HttpServlet" was not found on the Java Build Path
Java
0 vote141 views1 answer
Iterator java8
Java
2 votes175 views3 answers
Java tomorrow date
Java
9 votes145 views3 answers
Synchronized block java
Java
0 vote138 views2 answers
Simple Dockerfile
Java
0 vote228 views1 answer
How to add classpath in spring boot
Java Spring
6 votes158 views3 answers
Java get year from date
Java