/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

3 votes373 views1 answer
Caused by: java.lang.NoSuchMethodError: org.apache.logging.log4j.spi.LoggerContextFactory.isClassLoaderDependent()Z
Java
1 vote340 views2 answers
How to convert epoch time to date in java
Java
0 vote398 views1 answer
Eliminar el primer caracter de un string java
Java
0 vote383 views1 answer
How to make character in jframe
Java
0 vote360 views1 answer
27*5
Java
0 vote372 views1 answer
Interface in solidity
Java
0 vote360 views1 answer
Java equals on recursive apache commons
Java
150 votes597 views4 answers
How to scan a String in Java
Java
5 votes338 views3 answers
Random string generator java
Java
0 vote369 views1 answer
Javafx rectangle border size
Java