/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 vote438 views1 answer
Spring-boot java header appliacation/json constant
Java Spring
0 vote345 views1 answer
Java argument main
Java
1 vote373 views1 answer
Reverse in jaav
Java
1 vote376 views4 answers
How to change color of drawable in android
Java
0 vote354 views1 answer
Add seconds to today date and time java
Java
0 vote417 views1 answer
Java clear bufffer to take next string inpuit
Java
0 vote361 views1 answer
Youtube converter to mp3
Java
0 vote401 views5 answers
Static block in java
Java
11 votes347 views9 answers
Android Studio
Java
6 votes349 views5 answers
Java format 2 decimal places
Java