/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

2 votes192 views2 answers
Timestamp firebase
Java
1 vote175 views1 answer
Java inline conditional
Java
1 vote146 views1 answer
How to set the text of a jlabel to bold
Java
0 vote212 views1 answer
Do not concatenate text displayed with setText. Use resource string with placeholders.
Java
0 vote183 views1 answer
Java check if year is leap
Java
-1 vote175 views1 answer
Separate string by comma java
Java
1 vote176 views1 answer
Unable to find bundled Java version.
Java
0 vote193 views1 answer
Timestamp java jpa
Java
0 vote184 views1 answer
Javafx line chaart duplicate series added
Java
0 vote166 views1 answer
Unparseable date android
Java