/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 vote203 views1 answer
Creategoogle maps marker with custom image/bitmap
Java
0 vote187 views1 answer
Stack push java
Java
0 vote197 views2 answers
Eval javascipt
Java
22 votes227 views2 answers
Java quit application
Java
0 vote209 views2 answers
Android studio fragment findviewbyid
Java
0 vote204 views1 answer
Java creare costante
Java
0 vote206 views1 answer
Jtable font size
Java
0 vote353 views1 answer
Spring websocket allow origin
Java Spring
2 votes214 views1 answer
Instantiate optinal java 8
Java
6 votes197 views1 answer
Javafx tableview clear all data
Java