接着之前一篇,实现接口中的方法
工具/原料
eclipse
方法/步骤
1、//修改方法publicvoidudateEmp(Empemp){//连接数据库Connectioncon=null;PreparedStatementpstm=null;Stringsql=null;try{con=DBUtil.getConnection();sql="updatet_empsetname=?,age=?,sal=?whereid=?";
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(SQLExceptione){//TODOAuto-generatedcatchblocke.printStackTrace();}finally{DBUtil.closeConnection(con);}}
3、多个servlet合并一个servletpublicclassActionServletextendsHttpServlet{@Overrideprotectedvoidservice(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{//解决中文乱码问题request.setCharacterEncoding("utf-8");response.setContentType("text/html;charset=utf-8");//获取请求资源路径Stringuri=request.getRequestURI();System.out.println(uri);
4、//通过string类的subString()截取urlStringaction=uri饱终柯肢.substring(uri.lastIndexOf("/")+1,锇栀劐箨uri.lastIndexOf("."));//匹配相对应的功能处理逻辑PrintWriterout=response.getWriter();if(action.equals("addEmp")){Stringname=request.getParameter("name");intage=Integer.parseInt(request.getParameter("age"));doublesal=Double.parseDouble(request.getParameter("sal"));EmpDaodao=newEmpDaoImpl();Empemp=newEmp();emp.setName(name);emp.setAge(age);emp.setSal(sal);dao.add(emp);
5、//重定向response.sendRedirect("empList.jsp&qu艺皱麾酪ot;);}if(action缕计瓤账.equals("listEmp")){}if(action.equals("deleteEmp")){intid=Integer.parseInt(request.getParameter("id"));EmpDaodao=newEmpDaoImpl();dao.delete(id);response.sendRedirect("empList.jsp");}if(action.equals("updateEmp")){intid=Integer.parseInt(request.getParameter("id"));Stringname=request.getParameter("name");
6、intage=Integer.parseInt(request.getParameter("age"));doublesal=Double.parseDouble(request.getParameter("sal"));Empemp=newEmp();emp.setName(name);emp.setAge(age);emp.setSal(sal);emp.setId(id);EmpDaodao=newEmpDaoImpl();dao.udateEmp(emp);//重定向response.sendRedirect("empList.jsp");}if(action.equals("findById")){}}}