/Java/Android studio SELECT * FROM table

Android studio SELECT * FROM table

SQLiteDatabase db = this.getReadableDatabase();
Cursor c = db.rawQuery("SELECT column1,column2,column3 FROM table ", null);
if (c.moveToFirst()){
    do {
        // Passing values 
        String column1 = c.getString(0);
        String column2 = c.getString(1);
        String column3 = c.getString(2); 
        // Do something Here with values
    } while(c.moveToNext());
}
c.close();
db.close();

Source: stackoverflow.com

Similar codes

0 vote101 views1 answer
Open bottomsheet from adapter java
Java
1 vote107 views1 answer
Keyset sort java
Java
4 votes90 views1 answer
How do I make a splash screen?
Java
0 vote98 views2 answers
Java print 2d array row and column
Java
3 votes104 views2 answers
Java oop
Java
0 vote114 views1 answer
Get text from a jtextfield
Java
30 votes117 views6 answers
How to reverse a string in java
Java
2 votes106 views10 answers
Javascript
Java
0 vote168 views1 answer
Tests offline cypress
Java
0 vote112 views1 answer
Java show my form
Java