/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

11 votes153 views6 answers
Print in java
Java
0 vote179 views1 answer
Initialize linked list in java
Java
0 vote158 views1 answer
Java swing place objects vertically
Java
10 votes153 views3 answers
Android studio start activity
Java
0 vote187 views1 answer
Spring data jpa inheritance repository
Java Spring
0 vote152 views1 answer
Java remove character from string after
Java
0 vote164 views1 answer
Hashmap get value by key java
Java
4 votes190 views1 answer
How to call a function in java
Java
2 votes156 views1 answer
Loop hash map
Java
0 vote172 views1 answer
Java code to create square using 2D array
Java