统计HQL(hibernate)

HQL查询统计

最新推荐文章于 2021-02-27 00:34:20 发布

最新推荐文章于 2021-02-27 00:34:20 发布 · 184 阅读

文章标签：

#Hibernate

Framework 专栏收录该内容

5 篇文章

订阅专栏

本文介绍了一个使用HQL进行复杂查询的例子，该查询用于从学生表中统计不同年级、专业、教学点及班级的男女学生人数，并按特定顺序进行了排序。

hql.append(" select new Map( ");
hql.append(" student.nj.njmc as njmc ");//年级名称
hql.append(" , student.sszy.zymc as zymc ");//专业名称
hql.append(" , student.bj.jxd.name as jxdmc ");//教学点名称
hql.append(" , student.bj.bjmc as bjmc ");//班级名称
hql.append(" , sum( case when student.xb = 1 then 1 else 0 end ) as male");//男
hql.append(" , sum( case when student.xb = 2 then 1 else 0 end ) as famale");//女
hql.append(" ) ");

hql.append(" from Student student where 1=1 ");
hql.append(" and student.nj.id > ? ");
hql.append(" and student.nj.id <= ? ");
hql.append(" and student.pycc.id = ? ");

hql.append(" group by student.nj.njmc , student.sszy.zymc , student.bj.jxd.name , student.bj.bjmc ");
hql.append(" order by student.nj.njmc desc , student.sszy.zymc , student.bj.jxd.name , student.bj.bjmc ");