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 vote212 views1 answer
How to check whether a character is alphabet or not in java
Java
1 vote210 views1 answer
Jdbc driver servertimezone configuration property
Java
67 votes159 views10 answers
Java array to list
Java
2 votes182 views2 answers
How to navigate to last back stack in android studio
Java
0 vote191 views1 answer
Public static void main(String[] args) in java
Java
1 vote193 views3 answers
Android studio json parser
Java
32 votes210 views6 answers
Bootstrap alert
Java
3 votes233 views2 answers
Random suffling java
Java
1 vote241 views1 answer
Java class from string
Java
6 votes201 views3 answers
Android java format date time
Java