How to do IN() and WHERE=? SQL queries with Spring's JDBCTemplate

Question

This is an extension of How to execute IN() SQL queries with Spring's JDBCTemplate effectivly?

I wish to modify the query to be:

"SELECT * FROM foo WHERE name=? and value IN (:ids)"

how can I modify the given code to support the name=? parameter

Set<Integer> ids = ...;

MapSqlParameterSource parameters = new MapSqlParameterSource();
parameters.addValue("ids", ids);

List<Foo> foo = getJdbcTemplate().query("SELECT * FROM foo WHERE a IN (:ids)",
     getRowMapper(), parameters);

Use a `NamedParameterJdbcTemplate` instead of a `JdbcTemplate` . — M. Deinum, Jan 21 '15 at 19:08

score 1 · Answer 1 · answered Jan 22 '15 at 20:01

I was successful using both comments.

I will post the code below for those who may find this question later:

String sql = "SELECT * FROM foo WHERE name=:name and value IN (:ids)";

Set<Integer> ids = ...;
String name = "John";

MapSqlParameterSource parameters = new MapSqlParameterSource();
parameters.addValue("ids", ids);
parameters.addValue("name",name);

List<Foo> foo = getNamedParameterJdbcTemplate().query(sql, parameters, getRowMapper());

How to do IN() and WHERE=? SQL queries with Spring's JDBCTemplate

1 Answers1