/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

-1 vote331 views1 answer
Java remove punctuation from string
Java
0 vote334 views1 answer
Rock paper scissor in java
Java
1 vote338 views1 answer
What is ioexception in java
Java
14 votes343 views2 answers
Java read next line
Java
0 vote352 views1 answer
Android studio convert java to kotlin
Java
0 vote390 views1 answer
How to minimize jframe in java
Java
0 vote371 views1 answer
Syntax for new module creation in java
Java
3 votes366 views3 answers
How to change my file into binary data using java
Java
2 votes352 views2 answers
Changer version java terminal
Java
30 votes370 views6 answers
Reverse string in java
Java