How to use SELECT IN clause in JDBCTemplates?
There is a workaround using NamedParameterJdbcTemplate instead of SimpleJdbcDaoSupport, where you can do something like this:
List integerList = Arrays.asList(new Integer[] {1, 2, 3});
Map<String,Object> params = Collections.singletonMap("fields", integerList);
Long id = namedParameterJdbcTemplate.queryForLong("SELECT * FROM table WHERE field IN (:fields)", params);
This, however, has a potentially catastrophic limitation regarding the number of parameters you can pass in the list which depends on the DB you are using.
I don't think you can do this as a single '?'. It's nothing to do with Spring JDBC templates, it's core SQL.
You'll have to build up a (?, ?, ?) for as many of them as you need.