employeeservlet.java

一个jsp的oa系统,里面有很多亮点学习!

package com.oa.lp.servlet;

import java.io.IOException;
import java.sql.Connection;
import java.sql.Date;
import java.sql.SQLException;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.oa.lp.dao.EmployeeDAO;
import com.oa.lp.database.DataBase;
import com.oa.lp.model.Employee;
import com.oa.lp.util.PageList;
import com.oa.lp.util.Pages;

 public class EmployeeServlet extends TopServlet {
   static final long serialVersionUID = 1L;
   
	protected void doPost(HttpServletRequest request, HttpServletResponse response) {
		 //接参
		   String method = request.getParameter("method")==null?"":request.getParameter("method");
		   String empId = request.getParameter("empId")==null?"0":request.getParameter("empId");
		   String userName = request.getParameter("userName");
		   String userPwd = request.getParameter("userPwd");
		   String empName = request.getParameter("empName");
		   String sex = request.getParameter("sex")==null?"0":request.getParameter("sex");
		   String age = request.getParameter("age")==null?"0":request.getParameter("age");
		   String birthDay = request.getParameter("birthDay");
		   String schoolAge = request.getParameter("schoolAge");
		   String sepciality = request.getParameter("sepciality");
		   String school = request.getParameter("school");
		   String email = request.getParameter("email");
		   String qq = request.getParameter("qq");
		   String tel = request.getParameter("tel");
		   String mobileTel = request.getParameter("mobileTel");
		   String address = request.getParameter("address");
		   String idCard = request.getParameter("idCard");
		   String workDate = request.getParameter("workDate")==null?"":request.getParameter("workDate");
		   String dimissionDate = request.getParameter("dimissionDate")==null?"":request.getParameter("dimissionDate");
		   String flag = request.getParameter("flag")==null?"0":request.getParameter("flag");
		   //封装对象
		   Employee employee = new Employee();
		   if(empId.length()>0){
			   employee.setEmpId(Integer.parseInt(empId));
		   }
			   employee.setUserName(userName);
			   employee.setUserPwd(userPwd);
			   employee.setEmpName(empName);
			   if(sex.length()>0){
				   employee.setSex(Integer.parseInt(sex));
			   }
			   if(age.length()>0){
				   employee.setAge(Integer.parseInt(age));
			   }
			   employee.setBirthDay(birthDay);
			   employee.setSchoolAge(schoolAge);
			   employee.setSepciality(sepciality);
			   employee.setSchool(school);
			   employee.setQq(qq);
			   employee.setTel(tel);
			   employee.setMobileTel(mobileTel);
			   employee.setAddress(address);
			   employee.setIdCard(idCard);
			   if(workDate.length()>0){
				   employee.setWorkDate(Date.valueOf(workDate));
			   }
			   if(dimissionDate.length()>0){
				   employee.setDimissionDate(Date.valueOf(dimissionDate));
			   }
			   if(flag.length()>0){
				   employee.setFlag(Integer.parseInt(flag));
			   } 
			  
			   Connection conn=null;
			   try {
				conn = DataBase.getConnection();
				EmployeeDAO employeeDAO = new EmployeeDAO();
				employeeDAO.setConn(conn);
				if(method.equals("list")){
					//员工列表
					//构造分页对象
					
					Pages page = new Pages("/EmployeeServlet?method=list",request);
					page.setPageSize(10);//设置分页大小
					PageList pageList = employeeDAO.listAllEmployee(page);
					request.setAttribute("pageList", pageList);
					this.forward(request, response,"/system/employee/list.jsp");
				}else if(method.equals("add")){
					//新增员工
					employeeDAO.addEmployee(employee);
					this.sendRedirect(request, response,"/EmployeeServlet?method=list");
				}else if(method.equals("update")){
					//更新员工
					employeeDAO.updateEmployee(employee);
					this.sendRedirect(request, response,"/EmployeeServlet?method=list");
				}else if(method.equals("edit")){
					//通过角色ID查找员工
					request.setAttribute("employee",employeeDAO.getById(Integer.parseInt(empId)));
					this.forward(request, response,"/system/employee/emp.jsp");
				}else if(method.equals("del")){
					employeeDAO.delEmployee(Integer.parseInt(empId));
					this.sendRedirect(request, response,"/EmployeeServlet?method=list");
				}else if(method.equals("addLoad")){
					
					this.forward(request, response,"/system/employee/emp.jsp");
				}else if(method.equals("look")){
					//通过角色ID查找员工
					request.setAttribute("employee",employeeDAO.getById(Integer.parseInt(empId)));
					this.forward(request, response,"/system/employee/empLook.jsp");
				}
				//事务提交
				DataBase.commit();
				
			} catch (SQLException e) {
				
				e.printStackTrace();
			} catch (Exception e) {
				e.printStackTrace();
			}finally{
				if(conn!=null){
					//关闭连接
					DataBase.releaseConnection(conn);
				}
	}   	  	    
	}
 }