/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 vote184 views1 answer
Border bottom android xml
Java
0 vote206 views1 answer
How to get data from firebase notification in java
Java
1 vote188 views1 answer
Lambda function java
Java
-2 votes194 views1 answer
Print an integer in java
Java
0 vote197 views1 answer
Android bottom navigation hiding views
Java
0 vote194 views1 answer
Matrix program
Java
0 vote206 views1 answer
Action media scanner scan file android 30 deprecated
Java
1 vote201 views1 answer
How to get logarithm in java
Java
0 vote235 views1 answer
Log errors with stack traces spring
Java Spring
5 votes223 views2 answers
This project uses AndroidX dependencies, but the 'android.useAndroidX' property is not enabled.
Java