/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 vote135 views1 answer
How to take binary input in java
Java
11 votes131 views2 answers
Java list to set
Java
0 vote145 views1 answer
Hcf
Java
0 vote142 views1 answer
Getindexrequest elasticsearch
Java
0 vote128 views2 answers
Java get class by string
Java
0 vote137 views1 answer
Spring boot swagger ui 401
Java
0 vote135 views1 answer
Param Vishisht Seva Medal
Java
0 vote135 views2 answers
Convert python code to java using jython
Java
0 vote120 views1 answer
If not java
Java
8 votes209 views3 answers
Printing arraylist
Java