java criterion_Hibernate中使用多个OR的QBC用法

Criterion criterion = null;

Criteria cr =  session.createCriteria(Users.class);

for (int i=0;i

if("usersLoginid".equals(name[i])) {

criterion = or(criterion, Restrictions.like ("usersLoginid","%cus%"));

} else if("usersPwd".equals(name[i])) {

criterion = or(criterion, Restrictions.like ("usersPwd","%1234%"));

} else if("usersName".equals(name[i])) {

criterion = or(criterion, Restrictions.like ("usersName","%ewq%"));

}

}

cr.add(criterion);

List list = cr.addOrder(Order.desc("usersId"))

.setFirstResult(8)

.setMaxResults(4)

.list();

另外一个重要方法or如下：

public Criterion or(Criterion crit1, Criterion crit2) {

if (crit1 == null) {

return crit2;

}

if (crit2 == null) {

return crit1;

}

return Restrictions.or(crit1, crit2);

}

posted on 2010-07-29 13:42 Rabbit 阅读(502) 评论(0)  编辑  收藏