/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 vote118 views1 answer
Java code to get all leaf nodes of a xml
Java
3 votes138 views3 answers
Java initialize map with values in one line
Java
7 votes193 views1 answer
Solid principles in programming
Java
-1 vote125 views1 answer
Quit button java swing
Java
0 vote116 views1 answer
Java pattern matching
Java
0 vote123 views1 answer
Is the main method compulsory in Java?
Java
4 votes120 views3 answers
Volley android
Java
0 vote113 views1 answer
Android how to get current activity
Java
1 vote115 views1 answer
Android hide system bar programmatically
Java
2 votes114 views1 answer
Listview get selected java
Java