Hibernate中的查询(Criteria Query)

A:Expression查询语法
 1:Expression.eq: 对应sql(fidld=value):Expression.eq("name","zhengjigang")
 2:Expression.allEq:参数为一个Map对象。相当于多个Expression.eq关系的叠加
 3:Expression.gt:对应sql(field>value)
 4:Expression.ge:对应sql(field>=value)
 5:Expression.lt:对应sql(field<value)
 6:Expression.le:对应sql(field<=value)
 7:Expression.between:对应sql中的between表达式:Expression.between("age",new Integer(13),new Integer(15))
 8:Expression.like:对应sql(field like value)
 9:Expression.in:对应sql(field in value)
 10:Expression.eqProperty:对应pojo属性的sql(field=field):Expression.eqProperty("Tuser.groupId","Tgroup.id")
 11:Expression.gtProperty:对应的sql(field>field)
 12:Expression.geProperty:对应的sql(field>=field)
 13:Expression.ltProperty:对应的sql(field<field)
 14:Expression.leProperty:对应的sql(field<=field)
 15:Expression.and:and关系组合:Expression.and(Expression.eq("name","zhengjigang"),Expression.eq("job","软件工程师"))
 16:Expression.or:and关系组合:Expression.or(Expression.eq("name","zhengjigang"),Expression.eq("job","软件工程师"))
 17:Expression.sql:提供原生sql语法的支持:Expression.sql("lower({demo}.name) like lower(?)","zhengjigang%",Hibernate.String)

B:Criteria的高级查询
 1: 限定返回的记录条数:Criteria criteria=session.createCriteria(Tuser.class);
         criteria.setFirstResult(100);//开始的记录的索引
         criteria.setMaxResults(20)//取得最大民录数
 2:对记录进行排序:Criteria criteria=session.createCriteria(Tuser.class);
    criteria.add(Expression.eq("name","zhengjigang"));
    criteria.addOrder(Order.asc("name")); //对name字段进行升序排序