hibernate Restrictions 用法查询

男娘i 2021-09-25 21:50 285阅读 0赞

**import hibernate classes**

Java代码   ![收藏代码][icon_star.png]

1.  **import** org.hibernate.criterion.DetachedCriteria;  
2.  **import** org.hibernate.criterion.MatchMode;  
3.  **import** org.hibernate.criterion.Order;  
4.  **import** org.hibernate.criterion.Restrictions;

Java代码   ![收藏代码][icon_star.png]

1.  DetachedCriteria criteria = DetachedCriteria.forClass(UserPO.**class**);  
2.  // 按照用户名排序 -- 升序  
3.  criteria.addOrder(Order.asc("userName"));  
4.  **if** (user != **null**) \{  
5.      // 按条件查询  
6.      **if** (user.getUserName() != **null** && !user.getUserName().trim().equals("")) \{  
7.          criteria.add(Restrictions.like("userName", user.getUserName().trim(), MatchMode.ANYWHERE));  
8.      \}  
9.  \}  
10.   
11. getHibernateTemplate().findByCriteria(criteria ); // 返回LIST

Restrictions 的用法:

**1、Restrictions**

<table style="color:rgb(0,0,0); font-family:Helvetica,Tahoma,Arial,sans-serif; font-size:14px; line-height:25.2px; border:0px solid rgb(114,141,140); background-color:rgb(237,245,246)"> 
 <tbody> 
  <tr> 
   <td style="font-size:1em; text-align:center"><strong><span style="font-size:12px">方法</span></strong></td> 
   <td style="font-size:1em; text-align:center"><strong><span style="font-size:12px">说明</span></strong></td> 
  </tr> 
  <tr> 
   <td style="font-size:1em"><span style="color:rgb(255,0,0)">Restrictions.eq</span></td> 
   <td style="font-size:1em; text-align:center">equal 等于 ==</td> 
  </tr> 
  <tr> 
   <td style="font-size:1em"><span style="color:rgb(255,0,0)">Restrictions.allEq</span></td> 
   <td style="font-size:1em">参数为Map对象,使用key/value进行多个等于的对比,相当于多个Restrictions.eq的效果</td> 
  </tr> 
  <tr> 
   <td style="font-size:1em"><span style="color:rgb(255,0,0)">Restrictions.gt</span></td> 
   <td style="font-size:1em; text-align:center">great than 大于 &gt;</td> 
  </tr> 
  <tr> 
   <td style="font-size:1em"><span style="color:rgb(255,0,0)">Restrictions.ge</span></td> 
   <td style="font-size:1em; text-align:center">great equal 大于等于 &gt;=</td> 
  </tr> 
  <tr> 
   <td style="font-size:1em"><span style="color:rgb(255,0,0)">Restrictions.lt</span></td> 
   <td style="font-size:1em; text-align:center">less than 小于 &lt;</td> 
  </tr> 
  <tr> 
   <td style="font-size:1em"><span style="color:rgb(255,0,0)">Restrictions.le</span></td> 
   <td style="font-size:1em; text-align:center">less equal 小于等于 &lt;=</td> 
  </tr> 
  <tr> 
   <td style="font-size:1em"><span style="color:rgb(255,0,0)">Restrictions.between</span></td> 
   <td style="font-size:1em; text-align:center">对应SQL的between子句</td> 
  </tr> 
  <tr> 
   <td style="font-size:1em"><span style="color:rgb(255,0,0)">Restrictions.like</span></td> 
   <td style="font-size:1em; text-align:center">对应SQL的like子句</td> 
  </tr> 
  <tr> 
   <td style="font-size:1em"><span style="color:rgb(255,0,0)">Restrictions.in</span></td> 
   <td style="font-size:1em; text-align:center">对应SQL的in子句</td> 
  </tr> 
  <tr> 
   <td style="font-size:1em"><span style="color:rgb(255,0,0)">Restrictions.and</span></td> 
   <td style="font-size:1em; text-align:center">and 关系</td> 
  </tr> 
  <tr> 
   <td style="font-size:1em"><span style="color:rgb(255,0,0)">Restrictions.or</span></td> 
   <td style="font-size:1em; text-align:center">or 关系</td> 
  </tr> 
  <tr> 
   <td style="font-size:1em"><span style="color:rgb(255,0,0)">Restrictions.isNull</span></td> 
   <td style="font-size:1em; text-align:center">判断属性是否为null,为空则返回true</td> 
  </tr> 
  <tr> 
   <td style="font-size:1em">Restrictions.sqlRestriction</td> 
   <td style="font-size:1em; text-align:center">SQL限定的查询</td> 
  </tr> 
 </tbody> 
</table>

**2、Order**

<table style="color:rgb(0,0,0); font-family:Helvetica,Tahoma,Arial,sans-serif; font-size:14px; line-height:25.2px; border:0px solid rgb(119,134,136)"> 
 <tbody> 
  <tr> 
   <td style="font-size:1em">Order.asc</td> 
   <td style="font-size:1em">根据传入的字段进行升序排序</td> 
  </tr> 
  <tr> 
   <td style="font-size:1em">Order.desc &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</td> 
   <td style="font-size:1em">降序</td> 
  </tr> 
 </tbody> 
</table>

**3、MatchMode**

<table style="color:rgb(0,0,0); font-family:Helvetica,Tahoma,Arial,sans-serif; font-size:14px; line-height:25.2px; border:0px solid rgb(120,135,132)"> 
 <tbody> 
  <tr> 
   <td style="font-size:1em">MatchMode.EXACT</td> 
   <td style="font-size:1em">字符串精确匹配,相当于: like 'value'</td> 
  </tr> 
  <tr> 
   <td style="font-size:1em"><span style="color:rgb(255,0,0)">MatchMode.ANYWHERE &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</span></td> 
   <td style="font-size:1em">字符串在中间匹配 like '%value%'</td> 
  </tr> 
  <tr> 
   <td style="font-size:1em">MatchMode.START</td> 
   <td style="font-size:1em">匹配前面 like 'value%'</td> 
  </tr> 
  <tr> 
   <td style="font-size:1em">MatchMode.END</td> 
   <td style="font-size:1em">like '%value'</td> 
  </tr> 
 </tbody> 
</table>

例子：

Java代码   ![收藏代码][icon_star.png]

1.  // 查询年龄在20-30岁之间的所有学生对象  
2.  List list = session.createCriteria(Student.**class**)  
3.         .add(Restrictions.between("age",**new** Integer(20),**new** Integer(30)).list();  
4.  // 查询学生姓名在AAA,BBB,CCC之间的学生对象  
5.  String\[\] names = \{ "AAA","BBB","CCC"\};  
6.  List list = session.createCriteria(Student.**class**)  
7.         .add(Restrictions.in("name",names)).list();  
8.  // 查询年龄为空的学生对象  
9.  List list = session.createCriteria(Student.**class**)  
10.        .add(Restrictions.isNull("age")).list();  
11. // 查询年龄等于20或者年龄为空的学生对象  
12. List list = session.createCriteria(Student.**class**)  
13.        .add(Restrictions.or(Restrictions.eq("age",**new** Integer(20)),  
14.                  Restrictions.isNull("age")).list();

or可以无限加

[icon_star.png]: /images/20210923/8c664ad1bf464bb0b22b489e1bd74cd3.png