/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 votes310 views10 answers
Print
Java
1 vote297 views1 answer
Imagesbutton how to set background
Java
0 vote319 views1 answer
How to launch app in your android mobile phone
Java
0 vote313 views1 answer
How to validate information against the database in java
Java
1 vote309 views1 answer
Ontouch android
Java
5 votes304 views4 answers
File append in java
Java
0 vote300 views1 answer
Session-less control using java
Java
1 vote354 views1 answer
Java remove empty lines from string
Java
0 vote290 views1 answer
How to send a message to player in eclipse
Java
0 vote245 views1 answer
Convert hashset to arraylist
Java