/Java/Android studio SELECT * FROM table

Android studio SELECT * FROM table

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();

Source: stackoverflow.com

Similar codes

0 vote333 views2 answers
LinkedList java
Java
2 votes323 views1 answer
Collision java
Java
0 vote331 views1 answer
Eclipse jvm version 11 or greater is required
Java
0 vote326 views1 answer
Java argument main
Java
0 vote374 views1 answer
Could not determine java version from
Java
-1 vote308 views1 answer
Maven set repository location command line
Java
2 votes329 views2 answers
Install java runtime mac brew
Java
0 vote331 views1 answer
Make pattern for V in jaca
Java
0 vote344 views1 answer
Action bar message spigot 1.8
Java
0 vote348 views1 answer
Difference between Public, Private and Protected modifier in Java?
Java