/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

7 votes225 views2 answers
How to add the last area of an array in java
Java
0 vote251 views1 answer
Java 8 Functional Interfaces
Java
0 vote223 views1 answer
Android java string animations
Java
34 votes227 views6 answers
Java declare array
Java
1 vote233 views1 answer
Maximum arrays size in java
Java
0 vote238 views1 answer
Can the method local inner class object access method local variables
Java
0 vote241 views1 answer
Long in java
Java
0 vote238 views1 answer
Java set textview style
Java
0 vote214 views1 answer
IsEmpty java code
Java
0 vote237 views1 answer
Rotate Vector by an angle
Java