<sql-query name="P_HR_CUS_STAT" callable="true">        
      { call P_HR_CUS_STAT(?,?,?,?,?) }
    </sql-query> private List getEmployeesCustomersList(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response) {
List comUsers = new ArrayList();

String dept = request.getParameter("dept"); 
String companyid = request.getParameter("companyid"); 
String beginDate = request.getParameter("beginDate"); 
String endDate = request.getParameter("endDate"); 
String employee = request.getParameter("employee"); 

SimpleDateFormat sft = new SimpleDateFormat("yyyy-MM-dd");
/*
存储过程:P_HR_CUS_STAT
参数:
@comId varchar(5),--公司ID
@depId varchar(5),--部门ID
@name nvarchar(50),--员工
@startTime datetime,--开始时间(必填)
@endTime datetime --结束时间(必填)
 */
try {
comUsers = daoA.getNamedQuery("P_HR_CUS_STAT")   //按名查询存储过程
               .setString(0, companyid)
               .setString(1, dept)
                   .setString(2, employee)
               .setDate(3, sft.parse(beginDate))
               .setDate(4, sft.parse(endDate))
               .list();
} catch (Exception e) {
e.printStackTrace();
}
request.setAttribute("employee", employee);
request.setAttribute("dept", dept);
request.setAttribute("companyid", companyid);
request.setAttribute("beginDate", beginDate);
request.setAttribute("endDate", endDate);
return comUsers;
}