67,513
社区成员
发帖
与我相关
我的任务
分享
"select * from user where id not in ?"
public List getUser(){
List paramList = new ArrayList();
paramList.add(arg1);
paramList.add(arg2);
……
Session session = this.getSession();
Criteria criteria = session.createCriteria(User.class, "user");
criteria.add(Restrictions.not(Restrictions.in("user.id", paramList)));
return criteria.list();
}
public List getUser(){
String sql = "select * from user where id not in ?";
Session session = this.getSession();
Criteria criteria = session.createCriteria(User.class);
List paramList = new ArrayList();
Object[] paramArray = new Object[]{};
List typeList = new ArrayList();
Type[] typeArray = new Type[]{};
paramList.add(arg1);//把你的参数加到paramList
typeList.add(Hibernate.STRING);//把你的参数类型加到typeList,我这里加的是字符串
paramList.add(arg2);//把你的参数加到paramList
typeList.add(Hibernate.STRING);//把你的参数类型加到typeList,我这里加的是字符串
……
criteria.add(Restrictions.sqlRestriction(sql, paramList.toArray(paramArray),typeList.toArray(typeArray)));
return criteria.list();
}