|
方法
|
说明
|
|
Restrictions.eq
|
＝
|
|
Restrictions.allEq
|
利用Map来进行多个等于的限制
|
|
Restrictions.gt
|
＞
|
|
Restrictions.ge
|
＞＝
|
|
Restrictions.lt
|
＜
|
|
Restrictions.le
|
＜＝
|
|
Restrictions.between
|
BETWEEN
|
|
Restrictions.like
|
LIKE
|
|
Restrictions.in
|
in
|
|
Restrictions.and
|
and
|
|
Restrictions.or
|
or
|
|
Restrictions.sqlRestriction
|
用SQL限定查
|
示例：
DetachedCriteria detachedCrit = DetachedCriteria.forClass(User.class);
detachedCrit.addOrder(Order.asc("uname")); //按照姓名排序
if (user!=null && user.getUname()!=null&& user.getUname().trim().length()>0) //姓名查询条件
detachedCrit.add(Restrictions.like("uname", user.getUname().trim(), MatchMode.ANYWHERE));
if (user!=null && user.getUloginId()!=null && user.getUloginId().trim().length()>0) //身份证号查询条件
detachedCrit.add(Restrictions.like("uloginId", user.getUloginId().trim(), MatchMode.ANYWHERE));
if(user!=null && user.getType()!=null && user.getType()!=0) {
detachedCrit.add(Restrictions.eq("type", user.getType()));
}