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

4 votes183 views2 answers
How to count the number of occurrences of an element in a arraylist in java
Java
0 vote190 views1 answer
How to use split on a file name java
Java
-1 vote172 views2 answers
Convert long to localdatetime java
Java
3 votes214 views1 answer
The shrinker may have failed to optimize the Java bytecode. To disable the shrinker, pass the `--no-shrink` flag to this command.
Java
1 vote161 views1 answer
Mitmproxy on mac and android device
Java
1 vote154 views1 answer
Dagger kapt dependency and plugin
Java
3 votes172 views2 answers
Arraylist of arraylist
Java
2 votes226 views2 answers
Spring boot param object
Java Spring
0 vote179 views1 answer
Guess the number java
Java
0 vote196 views1 answer
Compare array with himself java
Java