Hibernate條件查詢(DetachedCriteria)

 

方法	說明
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()));}