List param = new ArrayList();
String sql = "select * from table t ";
sql = sql + "where t.name like ? ";
param.add("%" + "张三"+ "%");
sql = sql + " t.id in (?)";
param.add("'01','02'");
List li =this.getJdbcTemplate().queryForList(sql,
param.toArray());
我这里like 写的对
in 那地方怎么写
sql = sql + " t.id in (?)";
StringBuffer id = new StringBuffer("");
for(Long i :ids){
id.append(i+",");
}
id.deleteCharAt(id.length()-1);
param.add(id.toString());