Android sqlite select query

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();

Similar codes

2 votes122 views2 answers
Kotlin variable in string
Java
0 vote92 views1 answer
Spring send parameter to url
Java
22 votes136 views2 answers
Java close application
Java
0 vote144 views1 answer
Add SOSL to apex Example
Java
1 vote127 views1 answer
How to set view width programmatically in android
Java
0 vote144 views1 answer
Kotlin spinner default value
Java
0 vote161 views2 answers
How to send a byte array in socket java
Java
0 vote165 views1 answer
Kkih
Java
0 vote141 views3 answers
Bundletool aab to apk
Java
1 vote101 views1 answer
Combination
Java