/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 vote198 views1 answer
Configuration spring boot dependency for freemarker configuration
Java Spring
65 votes187 views6 answers
Java last element of array
Java
0 vote184 views1 answer
Assign multiple variables to empty string java
Java
0 vote174 views1 answer
How to clear cli screen
Java
0 vote158 views1 answer
String to stream java
Java
0 vote166 views1 answer
Convert javascritp getTime() to datetime
Java
0 vote170 views1 answer
Java.util.HashMap has generic type parameters, please use GenericTypeIndicator instead
Java
12 votes176 views3 answers
Specify decimal places java
Java
30 votes185 views6 answers
Reverse string in java
Java
0 vote190 views2 answers
Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: "EXCEPTION": invalid identifier
Java