IN clause and placeholders

by

A string of the form "?, ?, ..., ?" can be a dynamically created string and safely put into the original SQL query (because it is a restricted form that does not contain external data) and then the placeholders can be used as normal.

Consider a function String makePlaceholders(int len) which returns len question-marks separated with commas, then:

String[] names = { "name1", "name2" }; // do whatever is needed first
String query = "SELECT * FROM table"
    + " WHERE name IN (" + makePlaceholders(names.length) + ")";
Cursor cursor = mDb.rawQuery(query, names);

Just make sure to pass exactly as many values as places. The default maximum limit of host parameters in SQLite is 999 – at least in a normal build, not sure about Android 🙂

Here is one implementation:

String makePlaceholders(int len) {
    if (len < 1) {
        // It will lead to an invalid query anyway ..
        throw new RuntimeException("No placeholders");
    } else {
        StringBuilder sb = new StringBuilder(len * 2 - 1);
        sb.append("?");
        for (int i = 1; i < len; i++) {
            sb.append(",?");
        }
        return sb.toString();
    }
}

More Related Contents:

  1. I am getting this error on my code [closed]
  2. Sqlite for Android
  3. How can I avoid concurrency problems when using SQLite on Android?
  4. Where does Android emulator store SQLite database?
  5. How to store(bitmap image) and retrieve image from sqlite database in android? [closed]
  6. Android SQLite Example [closed]
  7. Android database encryption
  8. How do I join two SQLite tables in my Android application?
  9. Android SQLite issue – table … has no column named
  10. Android error – close() was never explicitly called on database
  11. How do I create a database in android? [closed]
  12. What is a maximum size of SQLite database on Android?
  13. How to save images into Database
  14. Full text search example in Android
  15. Android SimpleCursorAdapter doesn’t update when database changes
  16. rawQuery(query, selectionArgs)
  17. How to implement Export sqlite To excel/csv file in android?
  18. How to store and retrieve a byte array (image data) to and from a SQLite database?
  19. SQLite Query in Android to count rows
  20. How does one check if a table exists in an Android SQLite database?
  21. Attempt to reopen an already-closed object sqlitedatabase
  22. How insert image in room persistence library?
  23. How to view data saved in android database(SQLite)?
  24. difference between rawquery and execSQL in android sqlite database
  25. Browse SQLite database from Android Studio [closed]
  26. how to bulk insert in sqlite in android
  27. how to drop database in sqlite?
  28. Get SQLite database from Android app
  29. SQLite database on SD card
  30. Does Android SQLite cursor load all records into memory at once?

Leave a Comment