写代码的时候突然忘记了,在此记录一下;
Hibernate的HQL中in参数设置
public void updateDeviceByIDS(Long[] devicepkarr, DeviceINFO d) {
// TODO Auto-generated method stub
String hql = "UPDATE DeviceINFO SET";
if(d.getIsNotice()!=null&&d.getIsNotice()!=0){
hql+=" isNotice="+d.getIsNotice();
}
hql+=" WHERE devicePk IN (:alist)";
getSession().createQuery(hql).setParameterList</span>("alist", devicepkarr).executeUpdate();
}
JdbcTemplete中的in参数:
String[] labelIds是传递的参数;
if(labelIds!=null && labelIds.length>0){
sql.append(" and l.DOC_LABEL_ID in ( ");
for(int i=0;i<labelIds.length;i++){
if(i==0){
sql.append(labelIds[i]);
}else{
sql.append(","+labelIds[i]);
}
}
sql.append(")");
}
return this.getJdbcService().query(sql.toString(), objs.toArray(), Docss.class);