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

9 votes245 views2 answers
Change the default port in spring boot codegrepper
Java Spring
0 vote144 views1 answer
How to send a message to player in eclipse
Java
0 vote150 views1 answer
Java android development find element by id
Java
0 vote153 views1 answer
Java iterate map and remove
Java
2 votes139 views1 answer
Copy to clipboard java
Java
1 vote131 views1 answer
Highlight selected item in recyclerview android
Java
0 vote127 views1 answer
Regex java email validation
Java
0 vote158 views1 answer
Java print method
Java
-2 votes202 views1 answer
Java random number between 2 numbers
Java
0 vote210 views1 answer
Spring boot maven run with profile
Java