Hibernate查询_Criteria.pptVIP

Hibernate查询 Hibernate 3.2 Criteria(QBC)查询 Criteria public void testQuery1(){ Session session = HibernateSessionFactory.getSession(); Criteria c = session.createCriteria(Fwxx.class); Criterion criterion1 = Restrictions.like(title, 北,MatchMode.ANYWHERE); Criterion criterion2 = Restrictions.ge(zj, 1000d); c.add(criterion1); c.add(criterion2); List list = c.list(); printFwxx(list); } 链编程风格 public void testQuery1_2(){ Session session = HibernateSessionFactory.getSession(); Criteria c = session.createCriteria(Fwxx.class); c.add(Restrictions.like(title,北,MatchMode.ANYWHERE)) .add(Restrictions.ge(zj, 1000d)); List list = c.list(); printFwxx(list); } QBE public void testQuery1_3(){ Session session = HibernateSessionFactory.getSession(); Criteria c = session.createCriteria(Fwxx.class); Fwxx fwxx = new Fwxx(); fwxx.setTing(1); c.add(Example.create(fwxx)); List list = c.list(); printFwxx(list); } 使用别名 QBC检索方式不需要由应用程序显式指定类的别名,Hibernate会自动把查询语句的根节点实体赋予别名”this” 例如: Criteria c = session.createCriteria(Fwxx.class); c.add(Restrictions.like(“title”,“北”,MatchMode.ANYWHERE)) 等同于 c.add(Restrictions.like(“this.title,北,MatchMode.ANYWHERE)) 排序 public void testQuery2(){ Session session = HibernateSessionFactory.getSession(); Criteria c = session.createCriteria(Fwxx.class); c.add(Restrictions.like(title,北,MatchMode.ANYWHERE)) .add(Restrictions.ge(zj, 1000d)) .addOrder(Order.desc(zj)); List list = c.list(); printFwxx(list); } 分页 public void testQuery3(){ Session session = HibernateSessionFactory.getSession(); Criteria c = session.createCriteria(Fwxx.class); c.add(Restrictions.like(title,北,MatchMode.ANYWHERE)) .add(Restrictions.ge(zj, 1000d)) .addOrder(Order.desc(zj)); c.setFirstResult(0); c.setMaxResults(3); List list = c.list(); printFwxx(list); } 检索单个对象 uniqueResult:返回单个对象,如果结果不是单个对象执出 org.hibernate.NonUniqueResultException: query did not return a unique result: public void testQuery4(){ Session session = HibernateSessionFactory.getSession(); Criteria c = session.createCriteria(