<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;
}
{ 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;
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货