hibernate一值多字段模糊查询

1. public Page getCoordByPage(Page queryHandler, TCoordinate conditions) {  
2.         DetachedCriteria dc = DetachedCriteria.forClass(TCoordinate.class);  
3.         if (conditions.getTAxis() != null) {  
4.             dc.add(Restrictions.eq("TAxis", conditions.getTAxis()));  
5.         }  
6.           
7.         if(conditions.getCoordinateName()!=null){  
8.             dc.add(Restrictions.like("coordinateName", conditions.getCoordinateName(),MatchMode.ANYWHERE).ignoreCase());  
9.         }  
10.   
11.         if(conditions.getParentCoordinate().getId()!=null){  
12.             dc.add(Restrictions.eq("parentCoordinate.id", conditions.getParentCoordinate().getId()));  
13.         }  
14.   
15.         dc.addOrder(Order.desc("addDate"));  
16.         Page page = this.coordinateDao.getPageByCriteria(queryHandler, dc);  
17.         return page;  
18.     }  

 

两个条件之间or的用法【Restrictions.or(lhs, rhs)】：

 

[java]  view plain  copy

 

 

1. dc.add(Restrictions.or(Restrictions.like("country", comm.getCountry(),MatchMode.ANYWHERE).ignoreCase(),   
2.                     Restrictions.like("pinyin", comm.getCountry(),MatchMode.ANYWHERE).ignoreCase()));  

 

 

超过两个，比如三个条件之间的or【Disjunction disjunction = Restrictions.disjunction();】：

 

[java]  view plain  copy

 

 

1. 1. if(!ValidateUtils.isEmpty(comm.getCountry())){  
   2.             Disjunction disjunction = Restrictions.disjunction();  
   3.               
   4.             disjunction.add(Restrictions.like("country", comm.getCountry(),MatchMode.ANYWHERE).ignoreCase());  
   5.             disjunction.add(Restrictions.like("pinyin", comm.getCountry(),MatchMode.ANYWHERE).ignoreCase());  
   6.             disjunction.add(Restrictions.like("jianpin", comm.getCountry(),MatchMode.ANYWHERE).ignoreCase());  
   7.               
   8.             dc.add(disjunction);  
   9.         }  

   10.  

       hibernate 查询match mode的四种模式

        
       Hibernate 查询MatchMode的四种模式
       
       MatchMode.START：字符串在最前面的位置.相当于"like 'key%'"
       MatchMode.END：字符串在最后面的位置.相当于"like '%key'"
       MatchMode.ANYWHERE：字符串在中间匹配.相当于"like '%key%'"
       MatchMode.EXACT：字符串精确匹配.相当于"like 'key'"

转载于:https://www.cnblogs.com/Sincerity/p/5568766.html