/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 vote278 views1 answer
How to move a marker on google maps in android studio
Java
0 vote255 views1 answer
Print 1 to 10 using thread in java
Java
0 vote264 views1 answer
Uri/Beecrowd problem no - 1150 solution in Java
Java
2 votes273 views3 answers
Java get first day of the week
Java
1 vote283 views3 answers
Java double to string with comma
Java
4 votes283 views2 answers
Remove first character from string java
Java
0 vote263 views1 answer
Get string of radio button in android
Java
0 vote257 views1 answer
Get bimap by uri in android
Java
0 vote271 views1 answer
Java iterate map and remove
Java
0 vote257 views1 answer
Calling activity method from fragment:
Java