/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

10 votes188 views4 answers
Java capitalize first letter of each word
Java
3 votes173 views1 answer
Java extends
Java
0 vote218 views1 answer
Bad notification for startForeground: java.lang.RuntimeException: invalid channel for service notification: Notification
Java
0 vote189 views1 answer
Spring boot eureka , zual hystrix, rest api docs
Java
4 votes173 views2 answers
Java random string
Java
5 votes175 views3 answers
Console log java
Java
63 votes183 views6 answers
Java remove last character from string
Java
0 vote175 views1 answer
Printing different lines in array java
Java
1 vote175 views1 answer
Zpool
Java
69 votes177 views1 answer
Systemtime java
Java