/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

5 votes174 views1 answer
Kotlin string contains integer
Java
1 vote209 views1 answer
Java class from string
Java
283 votes531 views9 answers
Chess
Java
0 vote162 views1 answer
Reading txt file javafx
Java
0 vote199 views1 answer
Get logged-in user in Spring Security
Java
0 vote174 views2 answers
Java string to double comma
Java
1 vote173 views1 answer
Final method meaning
Java
0 vote175 views1 answer
Delet file from path android
Java
0 vote130 views1 answer
Creating new objects from loop java
Java
0 vote171 views5 answers
ArrayList
Java