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=?";

2、pstm=con.prepareStatement(sql);pstm.setString(1, emp.getName());pstm.setInt(2, emp.getAge());pstm.setDouble(3, emp.getSal());pstm.setInt(4, emp.getId());pstm.executeUpdate();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}finally{DBUtil.closeConnection(con);}}

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);

4、// 通过string类的subString()截取urlString action = uri.substring(uri.lastIndexOf("/") + 1, uri.lastIndexOf("."));// 匹配相对应的功能处理逻辑PrintWriter out = response.getWriter();if (action.equals("addEmp")) {String name = request.getParameter("name");int age = Integer.parseInt(request.getParameter("age"));double sal = Double.parseDouble(request.getParameter("sal"));EmpDao dao=new EmpDaoImpl();Emp emp=new Emp();emp.setName(name);emp.setAge(age);emp.setSal(sal);dao.add(emp);

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");

6、int age=Integer.parseInt(request.getParameter("age"));double sal=Double.parseDouble(request.getParameter("sal"));Emp emp=new Emp();emp.setName(name);emp.setAge(age);emp.setSal(sal);emp.setId(id);EmpDao dao=new EmpDaoImpl();dao.udateEmp(emp);//重定向response.sendRedirect("empList.jsp");}if (action.equals("findById")) {}}}