hql.append(" select new Map( ");
hql.append(" student.nj.njmc as njmc ");//年級名稱
hql.append(" , student.sszy.zymc as zymc ");//專業(yè)名稱
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 南充軟件開發(fā)