/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

-2 votes292 views1 answer
Java return exception
Java
53 votes163 views3 answers
Calculate number of years months and days between two dates in java
Java
0 vote162 views2 answers
Remove autofocus edittext android
Java
0 vote209 views1 answer
Java long literal
Java
0 vote173 views1 answer
Binary to decimal in java program
Java
0 vote165 views1 answer
Colors java intell print
Java
0 vote187 views2 answers
Beurre
Java
18 votes171 views1 answer
Taking string input in java
Java
0 vote165 views1 answer
Currency Formatter java
Java
0 vote165 views2 answers
Java find index of first alpha character in string
Java