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 block e.printStackTrace(); }finally{ DBUtil.closeConnection(con); } }
3、多个servlet合并一个servlet
public class ActionServlet extends HttpServlet { @Override protected 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()截取url String 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")) { } }}
