How do I pass a List/Set/Array to Apache QueryRunner as parameter value?

Question

Is there any way to perform the following query:

select * from table where field in (?)

and pass a list/set/array as a value for ? placeholder.

I'm using QueryRunner from the Apache db-commons library.

Answer 1

Sure there is, use createArrayOf:

final List<Integer> id = new ArrayList<>();
id.add(12);
id.add(15);

final Array toDelete = connection.createArrayOf("int", id.toArray());

queryRunner.query(
    connection,
    "SELECT * FROM table WHERE id = ANY(?)",
    resultSetHandler,
    toDelete
);

(example is using PostgreSQL but should also work for others)