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 ");
------------------------------
奥尚生活: http://www.wanghengliang.cn
南充奥尚软件: http://www.Aosunsoft.com 南充软件开发