/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

7 votes131 views1 answer
How to reverse order of arraylist
Java
0 vote136 views1 answer
What is java.io example
Java
0 vote145 views1 answer
ERROR: Failed to resolve: com.github.HaarigerHarald:android-youtubeExtractor:v1.7.0
Java
0 vote160 views1 answer
Build.plugins.plugin.version
Java
0 vote97 views1 answer
Super vs super()
Java
24 votes141 views4 answers
Last char in string java
Java
10 votes153 views2 answers
Maven test class
Java
0 vote148 views1 answer
Spring core xml configuration for collection using constructor
Java
0 vote144 views1 answer
Given an int variable n that has already been declared and initialized to a positive value, use a do...while loop to print a single line consisting of n asterisks. Use no variables other than n.
Java
1 vote141 views1 answer
Java how to center window
Java