Criteria和Detachedcriteria的区别及应用2

6. 查询示例 org.hibernate.criterion.Example类允许你通过一个给定实例 构建一个条件查询。

1. Cat cat = new Cat();   
2. cat.setSex('F');   
3. cat.setColor(Color.BLACK);   
4. List results = session.createCriteria(Cat.class)   
5.      .add( Example.create(cat) )   
6.      .list();
   

1. Cat cat = new Cat();  
2. cat.setSex('F');  
3. cat.setColor(Color.BLACK);  
4. List results = session.createCriteria(Cat.class)  
5.      .add( Example.create(cat) )  
6.      .list();  

Cat cat = new Cat(); cat.setSex('F'); cat.setColor(Color.BLACK); List results = session.createCriteria(Cat.class)     .add( Example.create(cat) )     .list();

版本属性、标识符和关联被忽略。默认情况下值为null的属性将被排除。 可以自行调整Example使之更实用。

1. Example example = Example.create(cat)   
2.      .excludeZeroes()           //exclude zero valued properties   
3.      .excludeProperty("color")  //exclude the property named "color"   
4.      .ignoreCase()              //perform case insensitive string comparisons   
5.      .enableLike();             //use like for string comparisons   
6. List results = session.createCriteria(Cat.class)   
7.      .add(example)   
8.      .list();
   

1. Example example = Example.create(cat)  
2.      .excludeZeroes()           //exclude zero valued properties  
3.      .excludeProperty("color")  //exclude the property named "color"  
4.      .ignoreCase()              //perform case insensitive string comparisons  
5.      .enableLike();             //use like for string comparisons  
6. List results = session.createCriteria(Cat.class)  
7.      .add(example)  
8.      .list();  

Example example = Example.create(cat)     .excludeZeroes()           //exclude zero valued properties     .excludeProperty("color")  //exclude the property named "color"     .ignoreCase()              //perform case insensitive string comparisons     .enableLike();             //use like for string comparisons List results = session.createCriteria(Cat.class)     .add(example)     .list();

甚至可以使用examples在关联对象上放置条件。

1. List results = session.createCriteria(Cat.class)   
2.      .add( Example.create(cat) )   
3.      .createCriteria("mate")   
4.          .add( Example.create( cat.getMate() ) )   
5.      .list();
   

1. List results = session.createCriteria(Cat.class)  
2.      .add( Example.create(cat) )  
3.      .createCriteria("mate")  
4.          .add( Example.create( cat.getMate() ) )  
5.      .list();  

List results = session.createCriteria(Cat.class)     .add( Example.create(cat) )     .createCriteria("mate")         .add( Example.create( cat.getMate() ) )     .list();

7. 投影(Projections)、聚合（aggregation）和分组（grouping） org.hibernate.criterion.Projections是 Projection 的实例工厂。我们通过调用 setProjection()应用投影到一个查询。

1. List results = session.createCriteria(Cat.class)   
2.      .setProjection( Projections.rowCount() )   
3.      .add( Restrictions.eq("color", Color.BLACK) )   
4.      .list();
   

1. List results = session.createCriteria(Cat.class)  
2.      .setProjection( Projections.rowCount() )  
3.      .add( Restrictions.eq("color", Color.BLACK) )  
4.      .list();
   

1. List results = session.createCriteria(Cat.class)   
2.      .setProjection( Projections.projectionList()   
3.          .add( Projections.rowCount() )   
4.          .add( Projections.avg("weight") )   
5.          .add( Projections.max("weight") )   
6.          .add( Projections.groupProperty("color") )   
7.      )   
8.      .list();
   

1. List results = session.createCriteria(Cat.class)  
2.      .setProjection( Projections.projectionList()  
3.          .add( Projections.rowCount() )  
4.          .add( Projections.avg("weight") )  
5.          .add( Projections.max("weight") )  
6.          .add( Projections.groupProperty("color") )  
7.      )  
8.      .list();  

List results = session.createCriteria(Cat.class)     .setProjection( Projections.projectionList()         .add( Projections.rowCount() )         .add( Projections.avg("weight") )         .add( Projections.max("weight") )         .add( Projections.groupProperty("color") )     )     .list();

 在一个条件查询中没有必要显式的使用 "group by" 。某些投影类型就是被定义为 分组投影，他 们也出现在SQL的group by子句中。 可以选择把一个别名指派给一个投影，这样可以使投影值被约束或排序所引用。下面是两种不同的 实现方式：

1. List results = session.createCriteria(Cat.class)   
2.      .setProjection( Projections.alias( Projections.groupProperty("color"), "colr" ) )   
3.      .addOrder( Order.asc("colr") )   
4.      .list();
   

1. List results = session.createCriteria(Cat.class)  
2.      .setProjection( Projections.alias( Projections.groupProperty("color"), "colr" ) )  
3.      .addOrder( Order.asc("colr") )  
4.      .list();  

List results = session.createCriteria(Cat.class)     .setProjection( Projections.alias( Projections.groupProperty("color"), "colr" ) )     .addOrder( Order.asc("colr") )     .list();

1. List results = session.createCriteria(Cat.class)   
2.      .setProjection( Projections.groupProperty("color").as("colr") )   
3.      .addOrder( Order.asc("colr") )   
4.      .list();
   

1. List results = session.createCriteria(Cat.class)  
2.      .setProjection( Projections.groupProperty("color").as("colr") )  
3.      .addOrder( Order.asc("colr") )  
4.      .list();  

List results = session.createCriteria(Cat.class)     .setProjection( Projections.groupProperty("color").as("colr") )     .addOrder( Order.asc("colr") )     .list();

alias()和as()方法简便的将一个投影实例包装到另外一个 别名的Projection实例中。简而言之， 当你添加一个投影到一个投影列表中时 你可以为它指定一个别名：

1. List results = session.createCriteria(Cat.class)   
2.      .setProjection( Projections.projectionList()   
3.          .add( Projections.rowCount(), "catCountByColor" )   
4.          .add( Projections.avg("weight"), "avgWeight" )   
5.          .add( Projections.max("weight"), "maxWeight" )   
6.          .add( Projections.groupProperty("color"), "color" )   
7.      )   
8.      .addOrder( Order.desc("catCountByColor") )   
9.      .addOrder( Order.desc("avgWeight") )   
10.      .list();
    

1. List results = session.createCriteria(Cat.class)  
2.      .setProjection( Projections.projectionList()  
3.          .add( Projections.rowCount(), "catCountByColor" )  
4.          .add( Projections.avg("weight"), "avgWeight" )  
5.          .add( Projections.max("weight"), "maxWeight" )  
6.          .add( Projections.groupProperty("color"), "color" )  
7.      )  
8.      .addOrder( Order.desc("catCountByColor") )  
9.      .addOrder( Order.desc("avgWeight") )  
10.      .list();
    

1. List results = session.createCriteria(Domestic.class, "cat")   
2.      .createAlias("kittens", "kit")   
3.      .setProjection( Projections.projectionList()   
4.          .add( Projections.property("cat.name"), "catName" )   
5.          .add( Projections.property("kit.name"), "kitName" )   
6.      )   
7.      .addOrder( Order.asc("catName") )   
8.      .addOrder( Order.asc("kitName") )   
9.      .list();
   

1. List results = session.createCriteria(Domestic.class, "cat")  
2.      .createAlias("kittens", "kit")  
3.      .setProjection( Projections.projectionList()  
4.          .add( Projections.property("cat.name"), "catName" )  
5.          .add( Projections.property("kit.name"), "kitName" )  
6.      )  
7.      .addOrder( Order.asc("catName") )  
8.      .addOrder( Order.asc("kitName") )  
9.      .list();  

List results = session.createCriteria(Domestic.class, "cat")     .createAlias("kittens", "kit")     .setProjection( Projections.projectionList()         .add( Projections.property("cat.name"), "catName" )         .add( Projections.property("kit.name"), "kitName" )     )     .addOrder( Order.asc("catName") )     .addOrder( Order.asc("kitName") )     .list();

也可以使用Property.forName()来表示投影：

1. List results = session.createCriteria(Cat.class)   
2.      .setProjection( Property.forName("name") )   
3.      .add( Property.forName("color").eq(Color.BLACK) )   
4.      .list();
   

1. List results = session.createCriteria(Cat.class)  
2.      .setProjection( Property.forName("name") )  
3.      .add( Property.forName("color").eq(Color.BLACK) )  
4.      .list();
   

1. List results = session.createCriteria(Cat.class)   
2.      .setProjection( Projections.projectionList()   
3.          .add( Projections.rowCount().as("catCountByColor") )   
4.          .add( Property.forName("weight").avg().as("avgWeight") )   
5.          .add( Property.forName("weight").max().as("maxWeight") )   
6.          .add( Property.forName("color").group().as("color" )   
7.      )   
8.      .addOrder( Order.desc("catCountByColor") )   
9.      .addOrder( Order.desc("avgWeight") )   
10.      .list();
    

1. List results = session.createCriteria(Cat.class)  
2.      .setProjection( Projections.projectionList()  
3.          .add( Projections.rowCount().as("catCountByColor") )  
4.          .add( Property.forName("weight").avg().as("avgWeight") )  
5.          .add( Property.forName("weight").max().as("maxWeight") )  
6.          .add( Property.forName("color").group().as("color" )  
7.      )  
8.      .addOrder( Order.desc("catCountByColor") )  
9.      .addOrder( Order.desc("avgWeight") )  
10.      .list();  

List results = session.createCriteria(Cat.class)     .setProjection( Projections.projectionList()         .add( Projections.rowCount().as("catCountByColor") )         .add( Property.forName("weight").avg().as("avgWeight") )         .add( Property.forName("weight").max().as("maxWeight") )         .add( Property.forName("color").group().as("color" )     )     .addOrder( Order.desc("catCountByColor") )     .addOrder( Order.desc("avgWeight") )     .list();

8. 离线(detached)查询和子查询 DetachedCriteria类使你在一个session范围之外创建一个查询，并且可以使用任意的 Session来 执行它。

1. DetachedCriteria query = DetachedCriteria.forClass(Cat.class)   
2.      .add( Property.forName("sex").eq('F') );   
3. //创建一个Session   
4. Session session = .;   
5. Transaction txn = session.beginTransaction();   
6. List results = query.getExecutableCriteria(session).setMaxResults(100).list();   
7. txn.commit();   
8. session.close();
   

1. DetachedCriteria query = DetachedCriteria.forClass(Cat.class)  
2.      .add( Property.forName("sex").eq('F') );  
3. //创建一个Session  
4. Session session = .;  
5. Transaction txn = session.beginTransaction();  
6. List results = query.getExecutableCriteria(session).setMaxResults(100).list();  
7. txn.commit();  
8. session.close();  

DetachedCriteria query = DetachedCriteria.forClass(Cat.class)     .add( Property.forName("sex").eq('F') ); //创建一个Session Session session = .; Transaction txn = session.beginTransaction(); List results = query.getExecutableCriteria(session).setMaxResults(100).list(); txn.commit(); session.close();

DetachedCriteria也可以用以表示子查询。条件实例包含子查询可以通过 Subqueries或者 Property获得。

1. DetachedCriteria avgWeight = DetachedCriteria.forClass(Cat.class)   
2.      .setProjection( Property.forName("weight").avg() );   
3. session.createCriteria(Cat.class)   
4.      .add( Property.forName("weight).gt(avgWeight) )   
5.      .list();   
6. DetachedCriteria weights = DetachedCriteria.forClass(Cat.class)   
7.      .setProjection( Property.forName("weight") );   
8. session.createCriteria(Cat.class)   
9.      .add( Subqueries.geAll("weight", weights) )   
10.      .list();
    

1. DetachedCriteria avgWeight = DetachedCriteria.forClass(Cat.class)  
2.      .setProjection( Property.forName("weight").avg() );  
3. session.createCriteria(Cat.class)  
4.      .add( Property.forName("weight).gt(avgWeight) )  
5.      .list();  
6. DetachedCriteria weights = DetachedCriteria.forClass(Cat.class)  
7.      .setProjection( Property.forName("weight") );  
8. session.createCriteria(Cat.class)  
9.      .add( Subqueries.geAll("weight", weights) )  
10.      .list();  

DetachedCriteria avgWeight = DetachedCriteria.forClass(Cat.class)     .setProjection( Property.forName("weight").avg() ); session.createCriteria(Cat.class)     .add( Property.forName("weight).gt(avgWeight) )     .list(); DetachedCriteria weights = DetachedCriteria.forClass(Cat.class)     .setProjection( Property.forName("weight") ); session.createCriteria(Cat.class)     .add( Subqueries.geAll("weight", weights) )     .list();

相互关联的子查询也是有可能的：

1. DetachedCriteria avgWeightForSex = DetachedCriteria.forClass(Cat.class, "cat2")   
2.      .setProjection( Property.forName("weight").avg() )   
3.      .add( Property.forName("cat2.sex").eqProperty("cat.sex") );   
4. session.createCriteria(Cat.class, "cat")   
5.      .add( Property.forName("weight).gt(avgWeightForSex) )   
6.      .list();
   

1. DetachedCriteria avgWeightForSex = DetachedCriteria.forClass(Cat.class, "cat2")  
2.      .setProjection( Property.forName("weight").avg() )  
3.      .add( Property.forName("cat2.sex").eqProperty("cat.sex") );  
4. session.createCriteria(Cat.class, "cat")  
5.      .add( Property.forName("weight).gt(avgWeightForSex) )  
6.      .list();