/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 vote91 views1 answer
Java linkedhashset initialize
Java
4 votes239 views1 answer
Context path spring boot
Java Spring
1 vote135 views1 answer
Textview set drawable right programmatically
Java
0 vote139 views1 answer
Implement elasticsearch filter in java
Java
1 vote137 views1 answer
Leetcode 416
Java
0 vote148 views1 answer
Jax-RS POST annotation
Java
0 vote139 views1 answer
Does constructor return any value java
Java
0 vote133 views1 answer
Get generic type of class at runtime
Java
1 vote167 views1 answer
Install openjdk di linux
Java
0 vote137 views1 answer
Remove fragment from backstack
Java