/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

8 votes113 views5 answers
Print arraylist java
Java
0 vote114 views1 answer
How to initlize a new collection
Java
1 vote111 views1 answer
Change date JDatePicker java
Java
0 vote104 views1 answer
Spring data elasticsearch aggregation max
Java
0 vote134 views1 answer
Are strings modifiable
Java
9 votes116 views3 answers
Convert int to array in java
Java
0 vote123 views1 answer
Informaticapc
Java
0 vote107 views1 answer
Java join list as string
Java
3 votes118 views1 answer
Java Polymorphism
Java
0 vote123 views1 answer
Fibonacci series in java using recursion
Java