javaweb增删改查（二）

员工列表增删改查


UpdateEmpViewServlet和UpdateServlet区别
点击修改按钮—进入的就是updateempview页面—要根据页面显示的数据进行修改
1.获取到id
2.因为根据id查询数据
3.把查询的数据绑定到req对象上
4.遍历循环再绑定所属部门的数据
5…转发到修改页—updateemp，jsp
UpdateEmpViewServlet

@WebServlet(urlPatterns = ("/updateempview"))
public class UpdateEmpViewServlet extends HttpServlet {

    private EmpService empService = new EmpServiceImpl();

    private DeptService deptService = new DeptServiceImpl();
    @Override
    protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

        //获取到id
        Integer empId = Integer.parseInt(req.getParameter("id"));

        //根据id查询数据

        Emp emp = empService.getEmpById(empId);
        //绑定到req对象
        req.setAttribute("emp",emp);

        //再绑定所属部门数据
        List<Dept> deptList = deptService.listDept();
        req.setAttribute("deptList",deptList);


        //转发到修改页
        req.getRequestDispatcher("/WEB-INF/pages/updateemp.jsp").forward(req,resp);


    }
}

UpdateServlet
1.显示数据
2.创建一个新对象，存储数据
3.重定向到emplist页面

WebServlet(urlPatterns = ("/updateemp"))
public class UpdateServlet extends HttpServlet {

    private EmpService empService = new EmpServiceImpl();

    @Override
    protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        req.setCharacterEncoding("utf-8");
        Integer empId = Integer.parseInt(req.getParameter("empId"));
        String name = req.getParameter("name");
        Integer age = Integer.parseInt(req.getParameter("age"));
        String sex = req.getParameter("sex");
        BigDecimal salary =new BigDecimal(req.getParameter("salary"));
        //System.out.println("============================"+req.getParameter("deptId"));
        Integer deptId = Integer.parseInt(req.getParameter("deptId"));


        Emp param = new Emp();
        param.setEmpId(empId);
        param.setName(name);
        param.setAge(age);
        param.setSex(sex);
        param.setSalary(salary);
        param.setDeptId(deptId);
        
        empService.updateEmp(param);
        //重定向到emplist页面
        resp.sendRedirect("emplist");
    }
}