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

0 vote269 views6 answers
GCD
Java
0 vote258 views1 answer
Java enum in switch statement
Java
0 vote268 views1 answer
Using new to create arrays
Java
0 vote261 views1 answer
Spinner get item text
Java
0 vote276 views1 answer
Vue composition watch
Java
8 votes268 views4 answers
Java decimalformat
Java
0 vote256 views1 answer
Procedural programming Java code example
Java
11 votes246 views6 answers
Print statement in java
Java
0 vote273 views2 answers
Find power of number in method java
Java
3 votes250 views1 answer
Set color of text for jlabel
Java