/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 vote338 views1 answer
Java random word from list
Java
5 votes350 views1 answer
Change color of text in textview android
Java
1 vote390 views2 answers
How to do annotation configuration in spring
Java Spring
5 votes315 views2 answers
Arraylist with values
Java
0 vote305 views1 answer
Jpa page sort
Java
0 vote327 views2 answers
Local date to date java
Java
0 vote316 views1 answer
Jadoh meaning
Java
1 vote288 views1 answer
Last method in jdbc
Java
1 vote315 views1 answer
Create java windows application
Java
0 vote343 views1 answer
Binary number input in int java
Java