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 vote133 views1 answer
GetMapping("/rest/v1/books") in spring rest api
Java Spring
2 votes115 views2 answers
Java swing alert window
Java
1 vote102 views1 answer
Tuple in java
Java
0 vote113 views1 answer
Ava program to add two numbers taking input from user
Java
0 vote111 views2 answers
Java class name to string
Java
1 vote133 views3 answers
Spring cors
Java Spring
0 vote115 views2 answers
How to create a console in java gui
Java
8 votes111 views2 answers
Check if char is number java
Java
3 votes133 views1 answer
Zip file java
Java
0 vote284 views2 answers
Open camera in android
Java