/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 vote153 views2 answers
Convert void * to int
Java
0 vote190 views1 answer
Spring swagger ui login oauth2
Java Spring
13 votes160 views2 answers
How to remove letters from string
Java
0 vote152 views1 answer
JsonArray get first Object
Java
2 votes146 views2 answers
Spring boot param object
Java
49 votes151 views4 answers
Java find last element in array
Java
0 vote151 views1 answer
How to get a context in a recycler view adapter
Java
2 votes140 views2 answers
Java file dialog
Java
4 votes153 views1 answer
Java log base 2
Java
0 vote171 views1 answer
How to change background tint color programmatically android
Java