/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

3 votes118 views3 answers
Fibonacci java
Java
1 vote100 views1 answer
Exponential in java
Java
1 vote135 views1 answer
How to make priority queue of pairs in java
Java
1 vote110 views4 answers
Convert date to localdate java
Java
32 votes102 views6 answers
Loops in java
Java
2 votes105 views1 answer
Get instance of object java
Java
3 votes113 views2 answers
Generating a random number
Java
2 votes87 views1 answer
Android studio textbox change text
Java
5 votes134 views1 answer
Java for map
Java
0 vote102 views1 answer
Spring amqp exchange not found
Java