/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

2 votes117 views1 answer
Java Iterable to list
Java
0 vote119 views1 answer
What is the difference between Error and Exception? java
Java
2 votes137 views2 answers
Zufallszahl java
Java
0 vote121 views2 answers
Dialog getWindow().setBackgroundDrawable transparent
Java
0 vote132 views1 answer
Java date add hours
Java
0 vote131 views1 answer
How to validate information against the database in java
Java
1 vote127 views2 answers
Use findviewbyid in fragment
Java
1 vote123 views1 answer
Leetcode 416
Java
0 vote116 views1 answer
Jdialog middle of screen
Java
0 vote114 views4 answers
Java loop through array
Java