/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

0 vote126 views1 answer
ConvertBirthDay java
Java
0 vote112 views1 answer
Str.substring last 2 java
Java
0 vote128 views1 answer
List to lowercase java
Java
0 vote112 views1 answer
Why we use return method
Java
0 vote174 views1 answer
Android studio Toast usage
Java
0 vote103 views1 answer
How to compare string ignore case in java
Java
103 votes200 views6 answers
Java hello world program
Java
0 vote113 views1 answer
Netbeans android sdk location
Java
0 vote113 views1 answer
For loop in firebase snapshot in java
Java
0 vote175 views1 answer
How to check number format exception in java
Java