前台有个打卡的页面,员工输入编号之后,会根据这个Servlet判断和赋值,然后存入数据库,但是项目有个要求是显示一个员工一个月的所有的迟到,旷工次数,就统计这块不会做,想请大家帮帮忙。数据库的信息有截图,但是不知道怎么传上来。。。
package com.gxa.servlet.action;
import java.util.Date;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.gxa.service.RecruitService;
import com.gxa.util.AplException;
public class AttendanceCheck extends HttpServlet {
private static final long serialVersionUID = 1L;
public void doGet(HttpServletRequest req, HttpServletResponse resp) {
doPost(req, resp);
}
@SuppressWarnings("deprecation")
public void doPost(HttpServletRequest req, HttpServletResponse resp){
try {
int em_code = Integer.parseInt(req.getParameter("em_code"));
RecruitService service = new RecruitService();
Date time = new Date(System.currentTimeMillis());
if ( time.getHours() > 9 && time.getHours()<12 ) {
int wo_late = 1;
String timemonth = time.getMonth() + 1 + "月份";
int wo_truancy = 0;
service.check(em_code, timemonth, wo_late, wo_truancy);
req.getRequestDispatcher("/login1.jsp").forward(req,
resp);
} else if (time.getHours() > 12) {
int wo_late = 0;
String timemonth = time.getMonth()+ 1 + "月份";
int wo_truancy = 1;
service.check(em_code, timemonth, wo_late, wo_truancy);
req.getRequestDispatcher("/login1.jsp").forward(req,
resp);
} else {
int wo_late = 0;
String timemonth = time.getMonth()+ 1 + "月份";
int wo_truancy = 0;
service.check(em_code, timemonth, wo_late, wo_truancy);
req.getRequestDispatcher("/login1.jsp").forward(req,
resp);
}
} catch (Exception e) {
new AplException("",e).printStackTrace(req,resp,"/err.jsp");
}
}
}