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 vote167 views1 answer
@crossorigin spring allow all
Java Spring
4 votes145 views1 answer
Java calculate fps
Java
1 vote144 views1 answer
Get the first day of the current month in Java
Java
8 votes142 views1 answer
Alertdialog show in android
Java
0 vote146 views2 answers
Milliseconds to seconds java
Java
-4 votes181 views2 answers
Spring security logging
Java Spring
1 vote146 views1 answer
String joiner in streams java
Java
0 vote142 views1 answer
WriteToFileAsync java
Java
0 vote144 views1 answer
Java JPanel set background color
Java
10 votes174 views2 answers
Change the default port in spring boot
Java