/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 vote283 views1 answer
Java url
Java
0 vote264 views1 answer
Set path in windows
Java
3 votes280 views6 answers
How to change the value of an arraylist in java
Java
0 vote305 views2 answers
Assert log in unit testing
Java
1 vote278 views1 answer
Java temp folder property
Java
2 votes270 views1 answer
Priority queue java comparator
Java
0 vote277 views1 answer
I java
Java
0 vote258 views1 answer
Jax-RS PUT annotation
Java
0 vote257 views1 answer
Java remove character from string after
Java
0 vote272 views1 answer
ClassCastException Casting toArray() method
Java