jdbcTemplate.query 参数是list sql条件为or

sql:

select u.* from epai_sys_dm.epai_sys_role u where 1=1 and u.id=‘548d0tq5nsnz5xqibda45dgo’ or u.id=‘izy6xvkt4tak3z7aarfj2a94’

用java 功能实现：

@RequestMapping(value = "/datagroup1", method = RequestMethod.PUT)
@ResponseBody
//如果参数是list
public List<SysRole> gg() {
    //{548d0tq5nsnz5xqibda45dgo,izy6xvkt4tak3z7aarfj2a94}
    List<String> list = new ArrayList<String>(2);
    list.add("548d0tq5nsnz5xqibda45dgo");
    list.add("izy6xvkt4tak3z7aarfj2a94");
    StringBuilder sb = new StringBuilder(list.size());
    sb.append("select u.* from epai_sys_dm.epai_sys_role u where 1=1");
    for (int i=0;i<list.size();i++){
        if (i==0){
          sb.append(" and");
        }
        if (i>0){
            sb.append(" or");
        }
        sb.append(" u.id='");
        sb.append(list.get(i));
        sb.append("'");
    }
    List<SysRole> sysRoles = jdbcTemplate.query(sb.toString(),new BeanPropertyRowMapper<SysRole>(SysRole.class));
    return sysRoles;
}