/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

6 votes198 views2 answers
Java string not equal
Java
16 votes207 views5 answers
Java reverse array
Java
51 votes211 views6 answers
Java remove last character
Java
0 vote196 views1 answer
How to change the first activity on android
Java
1 vote219 views1 answer
Mockito throw exception void method
Java
1 vote165 views1 answer
How to output quotation marks in java
Java
0 vote229 views1 answer
Java extract zip
Java
0 vote220 views1 answer
Java bter data atual no padrão brasileiro
Java
2 votes199 views3 answers
Upcasting and downcasting in java
Java
5 votes221 views1 answer
Java int to roman
Java