/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

12 votes363 views3 answers
Smart ways to print a matrix in java
Java
3 votes315 views3 answers
Ternary operator in java
Java
0 vote310 views1 answer
Byte to string arduino
Java
0 vote342 views1 answer
Dowload htpasswd file java
Java
11 votes323 views2 answers
Converting temperature from fahrenheit to celsius
Java
0 vote366 views1 answer
Android java textview weight programmatically
Java
124 votes496 views6 answers
How to create a random number in java
Java
0 vote354 views2 answers
Java 8 iterating and manipulating list
Java
0 vote354 views1 answer
Java program scan folder find files using time
Java
13 votes347 views2 answers
Junit
Java