接口实现类:

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() ;
%>





<% if(objs[0]==null){%>
暂无
<%}else{ %>
<%=objs[0].toString() %>
<%} %>

<%=objs[1].toString() %>
<%=objs[2].toString() %>
<%=objs[3].toString() %>
<%=objs[4].toString() %>
<%=objs[5].toString() %>
<%=objs[6].toString() %>
<%=objs[7].toString() %>
<%=objs[8].toString() %>
<%=objs[9].toString() %>
<%=objs[10].toString() %>
<%=objs[11].toString() %>

<%}%>