/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 vote370 views1 answer
Fibonacci series in java using recursion
Java
13 votes357 views1 answer
Java string builder
Java
0 vote312 views1 answer
Barcode design in postgresql
Java
0 vote312 views1 answer
Check authorities spring
Java
0 vote375 views1 answer
Change string into binary uding java
Java
15 votes344 views2 answers
Throw io exception java
Java
0 vote343 views1 answer
Teimpo en segundos java
Java
0 vote359 views1 answer
Javafx line chaart duplicate series added
Java
0 vote336 views1 answer
Android number format
Java
0 vote347 views1 answer
String compareto vs equals java
Java