/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

1 vote291 views1 answer
Find Numbers with Even Number of Digits leetcode
Java
0 vote298 views1 answer
Don't use a line-beased input after a token-based input.
Java
-1 vote263 views1 answer
$950 at 6% per annum for three years.
Java
1 vote279 views1 answer
Number to char
Java
0 vote313 views1 answer
How to divide coloumns in a text file into seperate arrays in java
Java
0 vote324 views1 answer
Hide element selenium
Java
2 votes309 views2 answers
Java popup message
Java
1 vote285 views1 answer
Java static variable
Java
1 vote269 views2 answers
Does finally block executed after crash
Java
4 votes300 views2 answers
Android parse date
Java