Hibernate HQL 分组求和查询

来源:互联网 发布:塔吊考试模拟考试软件 编辑:程序博客网 时间:2024/04/27 18:23

list=this.queryDao.getSessionFactory().getCurrentSession().createCriteria(SalesSlipline.class)
                        .add(Restrictions.eq("salesslipid.id",returnList.get(i).getId()))
                        .setProjection(Projections.projectionList().
                            add(Projections.sum("amount")).
                            add(Projections.sum("sum")).                           
                            add(Projections.groupProperty("salesslipid.id"))).list();