Java Servlet 添加员工功能实现 - 添加新员工并重定向到列表页面

@WebServlet('/add') public class AddEmpServlet extends HttpServlet { protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doGet(request, response); }

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    String empno = request.getParameter('empno');
    String ename = request.getParameter('ename');
    String job = request.getParameter('job');
    String mgr = request.getParameter('mgr');
    String hiredate_ = request.getParameter('hiredate');
    String sal = request.getParameter('sal');
    String comm = request.getParameter('comm');
    String deptno = request.getParameter('deptno');

    SimpleDateFormat sdf = new SimpleDateFormat('yyyy/MM/dd');
    Date hiredate=null;
    try {
        hiredate = sdf.parse(hiredate_);
    } catch (ParseException e) {
        throw new RuntimeException(e);
    }

    Emp emp = new Emp(Integer.parseInt(empno),ename,job,
            Integer.parseInt(mgr),hiredate,Double.parseDouble(sal),
            Double.parseDouble(comm),Integer.parseInt(deptno));
    
    EmpDao empDao = new EmpDao();
    empDao.addEmp(emp);
    
    response.sendRedirect('list');
}

}

在 doGet 和 doPost 方法中，我们首先获取从 add.jsp 页面传来的表单数据，然后将日期字符串转换为 Date 类型，最后创建一个 Emp 实例并将其插入到数据库中。我们使用了 EmpDao 类的 addEmp 方法来执行数据库插入操作。最后，我们重定向到员工列表页面，以在新增员工后刷新并显示最新的员工列表。