/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 vote261 views1 answer
BodyContentImpl memory leak
Java
0 vote259 views2 answers
Programming scares me
Java
0 vote264 views1 answer
Quartz spring maven driver
Java
0 vote260 views1 answer
Python to java converter software
Java
0 vote314 views1 answer
Spring Boot - Hashicorp Vault Integration
Java Spring
11 votes261 views2 answers
Try catch java
Java
0 vote272 views1 answer
How tomake teris in Java
Java
0 vote270 views1 answer
Jsp get query parameter
Java
2 votes302 views5 answers
Uppercase string java
Java
0 vote266 views1 answer
Write a java program to merge three singly linked list elements
Java