(轻量级Java EE程序设计及实践）第6章Hibernate核心技能.ppt

-*- 投影 String hql = select c.id, c.userName from Customer c ; Query query = session.createQuery(hql); ListObject[ ] list = query.list(); for(Object[ ] objs :list) { System.out.println(objs[0]+ +objs[1]); } String hql = select new Customer(c.id, c.userName) from Customer c ; Query query = session.createQuery(hql); ListCustomer list = query.list(); for(Customer c :list) { System.out.println(c.getId() + + c.getUserName()); } 必须有对应的构造方法 String hql = select new CustomerRow(c.id, c.userName) from Customer c ; String hql = select new map(c.id, c.userName) from Customer c ; 不能得到完整的对象，只能得到Object[ ] -*- 分组与统计 - HQL HQL select count(c.id) from Customer c select avg(c.age) from Customer c select max(c.age) ,min(c.age) from Customer c select c.userName,count(o) from Customer c left join c.orders o group by c.id select c.userName,count(o) from Customer c left join c.orders o group by c.id having count(o)=1 -*- 分组与统计 - Criteria 使用Projection接口实现以Criteria方式进行分组与统计查询 方法名 描述 avg(String propertyName) 对某个属性求平均值 max(String propertyName) 对某个属性求最大值 min(String propertyName) 对某个属性就最小值 sum(String propertyName) 对某个属性求和 count(String propertyName) 根据某个属性来统计记录数，和count(propertyName)类似 rowCount() 统计行数，与count(*)类似 countDistinct(String propertyName) 不重复的统计记录数，与count(distinct propertyName)类似 groupProperty(String propame) 根据特定属性分组，与group by proname类似 projectionList() 返回一个ProjectionList对象数组，代表投影列表 property(String propertyName) 把某个属性加入到投影查询中 -*- HQL动态查询 StringBuffer buffer = new StringBuffer(); //生成基础SQL buffer.append(from Customer c where 1=1); //如果name满足条件，则加入语句中 if (name != null) buffer.append( and c.userName like :name); //如果age满足条件，则加入语句中 if (age != null age != 0) buffer.append( and c.age = :age); Query query = session.createQuery(buffer.toString()); if (name != null) query.setString(name, % + name.toLowerCase() + %); if (age != null age != 0) query.setInteger(age, age); return query.list(); -*- Criteria动态查询 Criteria criteria = session.createCriteria(C