Save result from SQL query to ArrayList Android

Question

I'm trying to understand how to save result from SQL queries in android to an arraylist. Actually I find a few questions but none of them can answer why my code is wrong. So here is what I'm trying to do :

        String query = null;
        query = "SELECT * FROM users WHERE objectId = "+objectId+" AND serverName "+serverName;

        SQLiteDatabase db;

        // Insert results from query in database.
        ArrayList <String[]> result = new ArrayList<String[]>();
        ResultSet rs = db.execSQL(query);
        int columnCount = rs.getMetaData().getColumnCount();
        while(rs.next())
        {
            String[] row = new String[columnCount];
            for (int i=0; i <columnCount ; i++)
            {
               row[i] = rs.getString(i + 1);
            }
            result.add(row);
        }

And the error is saying that I cannot convert void to ResultSet. Any suggestions how to fix that or which is the right way to do this.

Thanks in advance

SQLiteDatabase db=null; and then you call db.execSQL(query); That isn't going to work...post the full code. — Squonk
– Squonk, Commented Aug 31, 2011 at 11:50
Maybe duplicate was the wrong word. But the question has already been answered. Query your database for a cursor, then take the cursor and step through it, adding each element to an ArrayList. Their might be a better way but not to my knowledge. — NSjonas
– NSjonas, Commented Aug 31, 2011 at 11:58
If you want people to help you then don't waste their time with "pretend" code. — Squonk
– Squonk, Commented Aug 31, 2011 at 12:17

Avinash · Accepted Answer · 2011-09-04 13:52:58Z

1

Once your database is open for reading use db.query or db.rawQuery to get a cursor that can be used to create your ArrayList

cursor = db.rawQuery(<query>, null);
            if(cursor.getCount() > 0)
            {
                cursor.moveToFirst();
                //add to list here 
            }

answered Sep 4, 2011 at 13:52

Avinash

8791 gold badge11 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Save result from SQL query to ArrayList Android

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related