How to get multiple rows in SQLite at a time in Android?

Question

I want to get multiple column from SQLite database for example I have the data with ids 1, 2, 3, 4, 5. Now in a SQLite database I want to get 2, 5 id values in Android:

    String selectQuery = "SELECT  * FROM " + Table_STOCK + " 
          WHERE " + KEY_ID + " = '" + id + "'" ;
    SQLiteDatabase db = this.getWritableDatabase();
    Cursor cursor = db.rawQuery(selectQuery, null);

From the query above I can only get one at a time with one id. I want to get multiple columns with multiple ids.

Please add more details in your question. And please search for answer before you are posting one. I think the problem you are facing is common. — Reaz Masud
– Reaz Masud, Commented Apr 18, 2018 at 6:34
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. — SpiritCrusher
– SpiritCrusher, Commented Apr 18, 2018 at 6:35
this is very basics of SQL, you should learn before starting using it. You can use WHERE id in (2,5) instead of WHERE id = 2 — Vladyslav Matviienko
– Vladyslav Matviienko, Commented Apr 18, 2018 at 6:42

Björn Kechel · Accepted Answer · 2018-04-18 07:29:11Z

You can use the keyword IN for this:

String commaSeparatedIds = "1, 2, 3, 4, 5";

String selectQuery = "SELECT  * FROM " + Table_STOCK + " 
                  WHERE " + KEY_ID + " IN (" + commaSeparatedIds + ")" ;

And here is a small helper method to create a commaSeparatedString from a List of Ids without additional Libraries:

private String toCommaSeparatedString(List<Integer> list) {
    if (list.size() > 0) {
        StringBuilder nameBuilder = new StringBuilder();
        for (Integer item : list) {
            nameBuilder.append(item).append(", ");
        }
        nameBuilder.deleteCharAt(nameBuilder.length() - 1);
        nameBuilder.deleteCharAt(nameBuilder.length() - 1);
        return nameBuilder.toString();
    } else {
        return "";
    }
}

Even Simpler with the apache commons libraries as explained here: Java: join array of primitives with separator (But beware that these sometimes cause problems with Android <4.4)

Jibin Mathews · Accepted Answer · 2018-04-18 06:51:38Z

1

Here is the code, you have to use to get multiple records

  selectQuery = "SELECT  * FROM " + Table_STOCK + " WHERE " + KEY_ID + "='" + id2+ "' AND " + KEY_ID + " = '" + id5";

There are multiple ways to fetch the data using condition.

edited Apr 18, 2018 at 6:51

Jibin Mathews

1,1351 gold badge10 silver badges23 bronze badges

answered Apr 18, 2018 at 6:45

Praveen Rawat

3241 gold badge3 silver badges14 bronze badges

5 Comments

Rishabh Saxena Over a year ago

But for that you have to be confirm that how many rows you have to fetch

Praveen Rawat Over a year ago

Yes , it should be predefined about how many rows he should fetch.

Rishabh Saxena Over a year ago

Check out my solution and if you find it dynamic then please upvote :)

Praveen Rawat Over a year ago

I already mentioned , there are many ways to fetch . But in question he not mention dynamic , he knows how many rows he had to fetch.

Rishabh Saxena Over a year ago

Ok but the answer should always be dynamic so that if in future anyone needs solution it should be beneficial for everyone.

Rishabh Saxena · Accepted Answer · 2018-04-18 06:59:46Z

You can just add ids in array list and call this method, rest this method will take care of everything, its a dynamic approach because here you can pass as much id you can. Just Edit the Object with your own data model.

public ArrayList<Object> getContent(ArrayList<String> list) {

        ArrayList<Object> objList = new ArrayList<>();
        if(list!=null && !list.isEmpty()){
            SQLiteDatabase db = getReadableDatabase();

            //Check for list items
            for(int i =0;i<list.size();i++) {

                Cursor cursor = db.query(Table_STOCK, null,
                        KEY_ID + " = ?",
                        new String[]{list.get(i)}, null, null, null, null);


                Object obj=null;

                if (cursor != null) {
                    cursor.moveToFirst();

                    // Set your object properties extracting from cursor
                    obj = new Object();
                    obj.setColumn1Property(cursor.getString(cursor.getColumnIndex(Table_STOCK.COLUMN_1)));
                    obj.setColumn2Property(cursor.getString(cursor.getColumnIndex(Table_STOCK.COLUMN_2)));
                }
                if (cursor != null) {
                    cursor.close();
                }
                //Add extracted object in your list.
            objList.add(obj);

            }
        }
        return objList;
        //Return rows list from your database. 
    }

Collectives™ on Stack Overflow

How to get multiple rows in SQLite at a time in Android?

3 Answers 3

Comments

5 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related