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 votes141 views1 answer
Java instantiate collection with values
Java
0 vote119 views1 answer
How to give intent one project to othrer project activity in anroid
Java
0 vote116 views1 answer
Get ocurrences in array java
Java
0 vote137 views1 answer
Spring security antmatchers id
Java Spring
-1 vote131 views1 answer
Accessing 2d array in java
Java
2 votes119 views1 answer
Java resize image
Java
4 votes150 views1 answer
Collection vs collections
Java
0 vote133 views1 answer
Spring db properties
Java
2 votes127 views1 answer
Setting up javafx in eclipse
Java
1 vote117 views1 answer
Why java is secure
Java