应用场景:
JDBC查询数据时,使用in查询:
在传递参数的Map对象中如下设置:
params.put("status", Arrays.asList(new Integer[] {0,1, 2, 4}));
List<CompAssessRuleVO> results = compAssessmentMgrDao.getCompAssessRuleVOes(params);
JDBC查询语句
return namedParameterJdbcTemplate.query(sql, params, new CompAssessRuleMgrMapper());