Hibernate-Criteria Queries

1.实例

接口org.hibernate.Criteria针对特殊持久层类进行查询，Sesion是Criteria的工厂：

1 Criteria crit = sess.createCriteria(Cat.class);
2 crit.setMaxResults(50);
3 List cats = crit.list();

2.精简结果集

1 List cats = sess.createCriteria(Cat.class)
2     .add( Restrictions.like("name", "Fritz%") )
3     .add( Restrictions.between("weight", minWeight, maxWeight) )
4     .list();
1 List cats = sess.createCriteria(Cat.class)
2     .add( Restrictions.like("name", "Fritz%") )
3     .add( Restrictions.or(
4         Restrictions.eq( "age", new Integer(0) ),
5         Restrictions.isNull("age")
6     ) )
7     .list();
1 List cats = sess.createCriteria(Cat.class)
2     .add( Restrictions.in( "name", new String[] { "Fritz", "Izi", "Pk" } ) )
3     .add( Restrictions.disjunction()
4         .add( Restrictions.isNull("age") )
5         .add( Restrictions.eq("age", new Integer(0) ) )
6         .add( Restrictions.eq("age", new Integer(1) ) )
7         .add( Restrictions.eq("age", new Integer(2) ) )
8     ) )
9     .list();
1 List cats = sess.createCriteria(Cat.class)
2     .add( Restrictions.sqlRestriction("lower({alias}.name) like lower(?)", "Fritz%", Hibernate.STRING) )
3     .list();
 1 Property age = Property.forName("age");
 2 List cats = sess.createCriteria(Cat.class)
 3     .add( Restrictions.disjunction()
 4         .add( age.isNull() )
 5         .add( age.eq( new Integer(0) ) )
 6         .add( age.eq( new Integer(1) ) )
 7         .add( age.eq( new Integer(2) ) )
 8     ) )
 9     .add( Property.forName("name").in( new String[] { "Fritz", "Izi", "Pk" } ) )
10     .list();

3.结果集排序

1 List cats = sess.createCriteria(Cat.class)
2     .add( Restrictions.like("name", "F%")
3     .addOrder( Order.asc("name") )
4     .addOrder( Order.desc("age") )
5     .setMaxResults(50)
6     .list();
1 List cats = sess.createCriteria(Cat.class)
2     .add( Property.forName("name").like("F%") )
3     .addOrder( Property.forName("name").asc() )
4     .addOrder( Property.forName("age").desc() )
5     .setMaxResults(50)
6     .list();

4.关联

1 List cats = sess.createCriteria(Cat.class)
2     .add( Restrictions.like("name", "F%") )
3     .createCriteria("kittens")
4         .add( Restrictions.like("name", "F%") )
5     .list();
1 List cats = sess.createCriteria(Cat.class)
2     .createAlias("kittens", "kt")
3     .createAlias("mate", "mt")
4     .add( Restrictions.eqProperty("kt.name", "mt.name") )
5     .list();
 1 List cats = sess.createCriteria(Cat.class)
 2     .createCriteria("kittens", "kt")
 3         .add( Restrictions.eq("name", "F%") )
 4     .setResultTransformer(Criteria.ALIAS_TO_ENTITY_MAP)
 5     .list();
 6 Iterator iter = cats.iterator();
 7 while ( iter.hasNext() ) {
 8     Map map = (Map) iter.next();
 9     Cat cat = (Cat) map.get(Criteria.ROOT_ALIAS);
10     Cat kitten = (Cat) map.get("kt");
11 }
1 List cats = session.createCriteria( Cat.class )
2                        .createAlias("mate", "mt", Criteria.LEFT_JOIN, Restrictions.like("mt.name", "good%") )
3                        .addOrder(Order.asc("mt.age"))
4                        .list();
5

5.动态关联检索

List cats = sess.createCriteria(Cat.class)
    .add( Restrictions.like("name", "Fritz%") )
    .setFetchMode("mate", FetchMode.EAGER)
    .setFetchMode("kittens", FetchMode.EAGER)
    .list();

6.组件

Cat有fullName属性，fullName属性又有lastName属性：

List cats = session.createCriteria(Cat.class)
            .add(Restrictions.eq("fullName.lastName", "Cattington"))
            .list();

 

posted @ 2016-04-11 16:35  gaungyao.wu  阅读(138)  评论(0)  编辑  收藏  举报