jsp页面对数据库的增删改（三）

1、//修改方法public void udateEmp(Emp emp) {//连接数据库Connection con=null;PreparedStatement pstm=null;String sql=null;try {con=DBUtil.getConnection();sql="update t_emp set name=?,age=?,sal=? where id=?";

3、多个servlet合并一个servletpublic class ActionServlet extends HttpServlet {@Overrideprotected void service(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {// 解决中文乱码问题request.setCharacterEncoding("utf-8");response.setContentType("text/html;charset=utf-8");// 获取请求资源路径String uri = request.getRequestURI();System.out.println(uri);

5、// 重定向response.sendRedirect("empList.jsp");}if (action.equals("listEmp")) {}if (action.equals("deleteEmp")) {int id = Integer.parseInt(request.getParameter("id"));EmpDao dao=new EmpDaoImpl(); dao.delete(id);response.sendRedirect("empList.jsp");}if (action.equals("updateEmp")) {int id=Integer.parseInt(request.getParameter("id"));String name=request.getParameter("name");