Hibernate条件查询(DetachedCriteria)

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限定查

MatchMode类包含的各个静态常量实例

匹配模式

举例

MatchMode.START

Expression.like(“name”,”y”, MatchMode.START)

姓名以y开头

MatchMode.END

Expression.like(“name”,”y”, MatchMode. END)

姓名以y结尾

MatchMode.ANYWHERE

Expression.like(“name”,”y”, MatchMode. ANYWHERE)

姓名中包含y

MatchMode.EXACT

Expression.like(“name”,”y”, MatchMode. EXACT)

精确匹配，姓名必须为y

示例：

view source print?01 DetachedCriteria detachedCrit = DetachedCriteria.forClass(User.class);

02 detachedCrit.addOrder(Order.asc("uname")); //按照姓名排序

03

04 if (user!=null && user.getUname()!=null&& user.getUname().trim().length()>0) //姓名查询条件

05 detachedCrit.add(Restrictions.like("uname", user.getUname().trim(), MatchMode.ANYWHERE));

06 if (user!=null && user.getUloginId()!=null && user.getUloginId().trim().length()>0) //身份证号查询条件

07 detachedCrit.add(Restrictions.like("uloginId", user.getUloginId().trim(), MatchMode.ANYWHERE));

08 if(user!=null && user.getType()!=null && user.getType()!=0) {

09 detachedCrit.add(Restrictions.eq("type", user.getType()));

10 }