/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 vote248 views4 answers
How to compare strings without capital letters in java easy
Java
-2 votes145 views3 answers
Enhanced 4 loop
Java
0 vote152 views1 answer
Spring boot MVC config
Java
2 votes154 views2 answers
Spring boot param object
Java
0 vote139 views1 answer
Java code to get all leaf nodes of a xml file
Java
0 vote145 views1 answer
Codepointat java
Java
11 votes147 views6 answers
Print in java
Java
10 votes265 views3 answers
H2 database spring boot
Java Spring
0 vote182 views6 answers
Create a new repository on the command line
Java
0 vote142 views1 answer
Android diagonal gradle
Java