Hibernate中Criteria详解使用方法.docxVIP

Criteria的完整用法QBE (Query By Example)Criteria cri = session.createCriteria(Student.class);cri.add(Example.create(s)); //s是一个Student对象list cri.list();实质：创建一个模版，比如我有一个表serial有一个 giftortoy字段，我设置serial.setgifttoy(2),则这个表中的所有的giftortoy为2的数据都会出来2: QBC (Query By Criteria) 主要有Criteria,Criterion,Oder,Restrictions类组成session = this.getSession();Criteria cri = session.createCriteria(JdItemSerialnumber.class);Criterion cron = Restrictions.like(customer,name);cri.add(cron);list = cri.list();==============================比较运算符HQL运算符 QBC运算符含义= Restrictions.eq() 等于 Restrictions.not(Exprission.eq()) 不等于 Restrictions.gt() 大于= Restrictions.ge() 大于等于 Restrictions.lt() 小于= Restrictions.le() 小于等于is null Restrictions.isnull() 等于空值is not null Restrictions.isNotNull() 非空值like Restrictions.like() 字符串模式匹配and Restrictions.and() 逻辑与and Restrictions.conjunction() 逻辑与or Restrictions.or() 逻辑或or Restrictions.disjunction() 逻辑或not Restrictions.not() 逻辑非in(列表) Restrictions.in() 等于列表中的某一个值ont in(列表) Restrictions.not(Restrictions.in())不等于列表中任意一个值between x and y Restrictions.between() 闭区间xy中的任意值not between x and y Restrictions.not(Restrictions..between()) 小于值X或者大于值y3: HQLString hql = select ,avg(s.age) from Student s group by ;Query query = session.createQuery(hql);list = query.list();....4: 本地SQL查询session = sessionFactory.openSession();tran = session.beginTransaction();SQLQuery sq = session.createSQLQuery(sql);sq.addEntity(Student.class);list = sq.list();mit();16.1. 创建一个Criteria 实例org.hibernate.Criteria接口表示特定持久类的一个查询。Session是 Criteria实例的工厂。Criteria crit = sess.createCriteria(Cat.class);crit.setMaxResults(50);List cats = crit.list();16.2. 限制结果集内容一个单独的查询条件是org.hibernate.criterion.Criterion 接口的一个实例。org.hibernate.criterion.Restrictions类定义了获得某些内置Criterion类型的工厂方法。List cats = sess.createCriteria(Cat.class).add( Restrictions.like(name, Fritz%) ).add( Restrictions.between(weight, minWeight, maxWeight) ).list();约束可以按逻辑分组。List cats = sess.createCriteria(Cat.class).add( Restrictions.like(name, Fritz%) ).add( Restrict