hibernate 多表之间的统计语句 (代码)

接口实现类:

public List getAllEmployeeAttend(){
String hql_two = "SELECT p.projectName , sci.stuffName ,count(att.onDuty) AS a ,count(att.usualOvertime) AS b ," +

"count(att.unusualOvertime) AS c , count(att.late) AS d ," +

"count(att.early) AS e , count(att.sickLeave) AS f ," +

"count(att.privateAffairLeave) AS g , count(att.evection) AS h ," +

"count(att.payLeave) AS i , count(att.waitPay) AS j " +

"FROM Attendper att LEFT JOIN att.projectInfo p INNER JOIN att.sci sci " +

"WHERE att.attendperDate >= '2008-02-01' AND att.attendperDate <= '2008-02-29' " +

"GROUP BY sci.stuffName , p.projectName " ;
List list = null;
try
{
Query q = this.getSession().createQuery( hql_two );
list = q.list();
//list = getHibernateTemplate().find(hql);
}catch(Exception e){
e.printStackTrace();
}
return list;
}

Action :

AttendDao ad = (AttendDao)getBean("attendDao");
// 得到全部员工的列表
List list=ad.getAllEmployeeAttend();
request.setAttribute("list",list);
return mapping.findForward("***");

page :

List l = (List)request.getAttribute("list") ;
for(Iterator it = l.iterator() ;it.hasNext();) {
Object[] objs=(Object[])it.next() ;
%>

暂无
















[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/13428095/viewspace-1000842/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/13428095/viewspace-1000842/