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 vote181 views1 answer
Jadoh meaning
Java
0 vote201 views1 answer
Choose image java
Java
0 vote185 views1 answer
Return type of executebatch in java
Java
48 votes185 views6 answers
How to generate random numbers in java within range
Java
1 vote184 views1 answer
Java mouseclick
Java
2 votes179 views1 answer
XAxis.setTextSize() text gets clipped
Java
0 vote175 views1 answer
Get number value of an output to another script java
Java
1 vote213 views1 answer
Android java seekbar
Java
0 vote210 views1 answer
List of tuple to map + jpa
Java
0 vote219 views1 answer
Database springboot
Java Spring