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

3 votes127 views1 answer
Float random class java
Java
1 vote129 views1 answer
Void set method using collections
Java
0 vote154 views2 answers
Cors spring method or class
Java Spring
0 vote128 views1 answer
Type mismatch cannot convert from string to string in java cucumber
Java
0 vote125 views1 answer
How to multiply a number by itself using for loop in java
Java
0 vote120 views1 answer
Get runtime java
Java
0 vote119 views1 answer
Java mask int to positive
Java
0 vote112 views1 answer
Java string length validation regex
Java
1 vote170 views2 answers
Spring boot docker
Java Spring
4 votes135 views2 answers
Java reentrantlock
Java