使用hibernate,实现group by and sum and count

最新推荐文章于 2025-07-07 12:46:27 发布

原创最新推荐文章于 2025-07-07 12:46:27 发布 · 268 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#Hibernate #DAO #.net #Blog

本文介绍如何使用Hibernate框架实现数据库的分组(Group By)、求和(Sum)及计数(Count)操作。通过示例代码展示了创建查询条件、设置投影属性及获取结果列表的过程。

http://blog.youkuaiyun.com/babydavic/archive/2007/11/01/1860518.aspx


   //使用hibernate,实现group by and sum and count
  Session sess = this.getSession(false);
  List list = null;
  if (sess != null) {
   Criteria cri = sess.createCriteria(getModelClass());
   cri.add(Expression.allEq(props));
   // always count id
   ProjectionList projList = Projections.projectionList();
   projList.add(Projections.sum(sum));
   projList.add(Projections.groupProperty(group1));
   projList.add(Projections.groupProperty(group2));
   projList.add(Projections.count(count));
   cri.setProjection(projList);
   list = cri.list();
  }
  list = list == null ? new ArrayList() : list;
  return list;

  //使用hibernate,实现group by and sum and count
  List listByGroupSum = dao.getListByGroupSumCP(props);
  Iterator iter = listByGroupSum.iterator();
  if (!iter.hasNext()) {
   System.out.println("No objects to display.");

  }
  while (iter.hasNext()) {
   System.out.println("New object");
   Object[] obj = (Object[]) iter.next();
   for (int i = 0; i < obj.length; i++) {
    System.out.println(obj[i]);
   }

  }