web_yugong.zip_yugong项目

package web; import java.io.IOException; import java.io.PrintWriter; import java.util.List; import javax.servlet.RequestDispatcher; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import dao.EmployeeDAO; import entity.Employee; public class ActionServlet extends HttpServlet { public void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("utf-8"); String uri = request.getRequestURI(); String action = uri.substring(uri.lastIndexOf("/"), uri .lastIndexOf(".")); if (action.equals("/list")) { try { EmployeeDAO dao = new EmployeeDAO(); List<Employee> employees = dao.findAll(); request.setAttribute("employees", employees); RequestDispatcher rd = request .getRequestDispatcher("listEmp.jsp"); rd.forward(request, response); } catch (Exception e) { e.printStackTrace(); // 将异常抛给容器 throw new ServletException(e); } }else if(action.equals("/add")){ String name = request.getParameter("name"); String salary = request.getParameter("salary"); String age = request.getParameter("age"); //服务器端要检查客户端传递过来的参数 //值的合法性。 //将员工信息插入到数据库 try { EmployeeDAO dao = new EmployeeDAO(); Employee e = new Employee(); e.setName(name); e.setSalary(Double.parseDouble(salary)); e.setAge(Integer.parseInt(age)); dao.save(e); response.sendRedirect("list.do"); } catch (Exception e) { e.printStackTrace(); throw new ServletException(e); } }else if(action.equals("/del")){ int id = Integer.parseInt(request.getParameter("id")); try { EmployeeDAO dao = new EmployeeDAO(); dao.delete(id); response.sendRedirect("list.do"); } catch (Exception e) { e.printStackTrace(); throw new ServletException(e); } }else if(action.equals("/load")){ int id = Integer.parseInt( request.getParameter("id")); //访问数据库，获得指定id值的员工的信息 try { EmployeeDAO dao = new EmployeeDAO(); Employee e = dao.findById(id); //转发给updateEmp.jsp来显示 request.setAttribute("e", e); request.getRequestDispatcher("updateEmp.jsp") .forward(request, response); }catch(Exception e){ e.printStackTrace(); throw new ServletException(e); } }else if(action.equals("/modify")){ int id = Integer.parseInt(request.getParameter("id")); String name = request.getParameter("name"); String salary = request.getParameter("salary"); String age = request.getParameter("age"); //服务器端要检查客户端传递过来的参数 //值的合法性。 //修改数据库中员工的信息 EmployeeDAO dao = new EmployeeDAO(); Employee e = new Employee(); e.setName(name); e.setSalary(Double.parseDouble(salary)); e.setAge(Integer.parseInt(age)); e.setId(id); try { dao.modify(e); response.sendRedirect("list.do"); } catch (Exception e1) { e1.printStackTrace(); throw new ServletException(e1); } } } }