javaweb员工表

  1. 首先把员工表的信息查询显示出来 ```java @WebServlet( “/SelectServlet”) public class SelectServlet extends ViewBaseServlet { @Override protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

    1. this.doPost(request, response);

    }

    @Override protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

    1. Emp emp=new Emp();
    2. EmpDao empDao=new EmpDao();
    3. //查询数据存储到列表中
    4. List<Emp> list = empDao.selectEmp();
    5. request.setAttribute("list",list);
    6. super.processTemplate("select",request,response);

    } }

工号 姓名 入职时间 薪水 功能
//通过thymeleaf传递用户id 编辑 删除 

  3.    2.  实现添加用户功能 
  4. ```java
  5. //首先需要通过渲染add.html,实现动态提交路径
  6. @WebServlet(value = "/ToAdddServlet")
  7. public class ToAdddServlet extends ViewBaseServlet {
  8.     @Override
  9.     protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  10.         this.doPost(request, response);
  11.     }
  13.     @Override
  14.     protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  15.         super.processTemplate("add", request, response);
  16.     }
  17. }
  19. @WebServlet("/AddServlet")
  20. public class AddServlet extends ViewBaseServlet {
  21.     @Override
  22.     protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  23.         this.doPost(request, response);
  24.     }
  26.     @Override
  27.     protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  28.         //设置接收中文编码格式
  29.         request.setCharacterEncoding("utf-8");
  30.         String ename = request.getParameter("ename");
  31.         String joindate = request.getParameter("joindate");
  32.         String salary = request.getParameter("salary");
  33.         Emp emp=new Emp();
  34.         emp.setEname(ename);
  35.         emp.setSalary(salary);
  36.         emp.setJoindate(joindate);
  37.         EmpDao empDao=new EmpDao();
  38.         int i = empDao.insertEmp(emp);
  39.         //当i>0时，添加用户数据成功
  40.         if(i>0){
  41.             response.sendRedirect("SelectServlet");
  42.             System.out.println("insert success");
  43.         }
  44.     }
  45. }
  47. <form th:action="@{/AddServlet}" method="post">
  48. <table>
  49.     <tr><td>员工名字:</td>
  50.         <td><input type="text" name="ename"></td>
  51.     </tr>
  52.     <tr><td>入职时间:</td>
  53.         <td><input type="text" name="joindate"></td>
  54.     </tr>
  55.     <tr><td>员工薪水:</td>
  56.         <td><input type="text" name="salary"></td>
  57.     </tr>
  58.     </table>
  59.         <input type="submit" value="提交">
  60. </form>

  1. 实现用户数据编辑功能（直接在首页用户信息旁边），首先需要检验编辑按钮是否传来了id ``` @WebServlet(value = “/ToEditServlet”) public class ToEditServlet extends ViewBaseServlet { @Override protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { this.doPost(request, response); }

    @Override protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String id = request.getParameter(“id”); //接收页面传来的id，没有则无法进行编辑 if(!StringUtils.isEmpty(id)){

    1.  Integer i = Integer.valueOf(id);
    2.  EmpDao empDao=new EmpDao();
    3.  Emp emp = empDao.selectId(i);
    4.  request.setAttribute("emp",emp);

    } super.processTemplate(“edit”, request, response); } }

修改员工

用户名：
入职时间：
薪水：

@WebServlet(“/update”) public class EditServlet extends ViewBaseServlet { @Override protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { this.doPost(request, response); }

  1. @Override
  2. protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  3.     //设置修改中文不乱码
  4.     request.setCharacterEncoding("utf-8");
  5.     //把网页上修改的数据存到emp中
  6.     int id =Integer.valueOf( request.getParameter("id"));
  7.     String ename = request.getParameter("ename");
  8.     String joindate = request.getParameter("joindate");
  9.     String salary = request.getParameter("salary");
  10.     Emp emp=new Emp();
  11.     emp.setEname(ename);
  12.     emp.setId(id);
  13.     emp.setJoindate(joindate);
  14.     emp.setSalary(salary);
  15.     EmpDao empDao=new EmpDao();
  16.     //实现emp数据的更新
  17.     int i = empDao.updateEmp(emp);
  18.     if(i>0){
  19.         //跳转到查询页面
  20.         response.sendRedirect("SelectServlet");
  21.     }
  22. }

}

  3.    4.  实现删除功能，直接传id 
  4. ```java
  5. @WebServlet(value = "/ToDelServlet")
  6. public class ToDelServlet extends ViewBaseServlet {
  7.     @Override
  8.     protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  9.         this.doPost(request, response);
  10.     }
  12.     @Override
  13.     protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  14.         super.processTemplate("del", request, response);
  15.     }
  16. }
  18. <form th:action="@{/DelServlet}" method="post">
  19. 请输入要删除的员工id：<input type="text" name="id">
  20.         <input type="submit" value="提交">
  21. </form>
  23. @WebServlet(value = "/DelServlet")
  24. public class DelServlet extends ViewBaseServlet {
  25.     @Override
  26.     protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  27.         this.doPost(request, response);
  28.     }
  30.     @Override
  31.     protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  32.         int id =Integer.valueOf( request.getParameter("id"));
  33.         Emp emp=new Emp();
  34.         EmpDao empDao=new EmpDao();
  35.         emp.setId(id);
  36.         int i = empDao.delEmp(emp);
  37.         //删除成功后跳转到首页
  38.         if(i>0){
  39.             response.sendRedirect("SelectServlet");
  40.         }else {
  41.             System.out.println("删除失败");
  42.         }
  43.     }
  44. }

总结：
  1.   1. 在实现功能跳转的时候，可以设置动态路径，这样就需要在两者中间加一个渲染，直接渲染到页面
  2.   1. 在实现编辑和删除的功能时，可以直接在跳转路径后面加上id，这样就可以通过id来直接操作
  3.   1. 注意设置好网页中输入的中文编码格式
  4.   1. 注意html文件放置的路径（一般在web根目录里面），还有数据库配置文件的路径在src根目录下