/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 vote353 views1 answer
Directly access ids in android
Java
1 vote338 views1 answer
What is ioexception in java
Java
1 vote325 views1 answer
How to get elements of a list in java
Java
0 vote307 views2 answers
Drawimage java
Java
1 vote353 views1 answer
Who is James Gosling
Java
13 votes354 views2 answers
Java stringbuilder set value
Java
0 vote362 views2 answers
Flutter calculate sum in a list
Java
0 vote328 views1 answer
How do you nuke japan
Java
2 votes343 views2 answers
Even Digits Leetcode
Java
0 vote341 views1 answer
Spring yml property boolean
Java