/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 vote210 views1 answer
Find the length of jtextfeild in java
Java
7 votes213 views1 answer
Byte java
Java
0 vote197 views2 answers
Like in cypher query
Java
1 vote213 views1 answer
Java swing pic
Java
-2 votes200 views1 answer
Java anagrams
Java
0 vote211 views1 answer
Jbutton set on action
Java
1 vote221 views1 answer
Return boolean value from stream
Java
0 vote200 views1 answer
Mock ioexception mockito on BufferedReader
Java
1 vote207 views1 answer
Selection Structure and Conditions
Java
0 vote212 views1 answer
How to add value in jcombobox in java
Java