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()));
		}