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 vote261 views2 answers
Jdk 11 mac
Java
0 vote315 views1 answer
Configuration reader java
Java
0 vote402 views1 answer
@bean annotation in spring boot
Java Spring
0 vote329 views1 answer
Armstrong Numbers Between Two Integers
Java
0 vote390 views1 answer
How to change the tomcat port in spring boot
Java Spring
4 votes317 views1 answer
Java fps
Java
0 vote305 views1 answer
Java program for wind-chill temperature
Java
2 votes328 views1 answer
Naming conventions methods java
Java
2 votes376 views4 answers
Find char in string java
Java
0 vote314 views1 answer
Spring boot swagger ui 401
Java