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

183 votes370 views6 answers
Last element of an array
Java
0 vote235 views1 answer
Java enum from int
Java
2 votes230 views1 answer
Check array is sorted java
Java
0 vote273 views1 answer
Java program to swap two numbers using bitwise xor operator
Java
0 vote232 views1 answer
Single dex file error android
Java
0 vote216 views1 answer
Transversal operation in java array
Java
1 vote231 views1 answer
Java sort arraylist of arraylist
Java
0 vote255 views1 answer
"https://unpkg.com/[email protected]/dist/ThaanaKeyboard.min.js
Java
1 vote256 views1 answer
Get block player is looking at bukkit
Java
0 vote270 views1 answer
How to make a messages config minecraft plugin
Java