/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

1 vote147 views2 answers
How to do annotation configuration in spring
Java
0 vote116 views1 answer
Views in android
Java
1 vote151 views1 answer
Get value google sheet with app script
Java
0 vote172 views1 answer
Close searchview android java
Java
2 votes137 views1 answer
Error: package android.support.v4.content does not exist import android.support.v4.content.FileProvider; ^
Java
0 vote154 views1 answer
Android studio change image on button click
Java
10 votes185 views2 answers
How to substring in java
Java
0 vote174 views1 answer
Spring boot get bean
Java Spring
0 vote150 views1 answer
Android studio get id name from view
Java
0 vote205 views1 answer
How to check when edittext clicked android
Java