Question

Spring jdbctemplate 中查询语句有IN 怎么传参数

Answer 1

@Test
public void testIn(){
NamedParameterJdbcTemplate namedParameterJdbcTemplate =
new NamedParameterJdbcTemplate(jdbcTemplate);
String s = "1,2,3,4";
MapSqlParameterSource parameters = new MapSqlParameterSource();
parameters.addValue("menuId",Arrays.asList(s));
List<Map<String,Object>> list = namedParameterJdbcTemplate.queryForList("SELECT * FROM CSM_MENU WHERE MENU_ID IN (:menuId)",parameters);
System.out.println(list.size());
}