模式2 章 J2EE概述 JavaEE教学课件PPT.pptVIP

模式2 江西农业大学软件学院北京实习基地 模式1 模式2 增加小组 增加小组—业务类的addTeam方法 public static void addTeam(Team team) throws Exception { Connection cn = null; Statement stmt = null; try { cn = DataSource.getConnection(); stmt = cn.createStatement(); stmt.executeUpdate(insert into team (name,slogan,leader) values ( + team.getName() + , + team.getSlogan() + , + team.getLeader() + )); } catch (Exception e) { throw e; } finally { …… } } 增加小组—Servlet 增加小组—Servlet（源代码） protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding(GBK);//设置接收的字符集 //接收数据 String name = request.getParameter(name); String slogan = request.getParameter(slogan); String leader = request.getParameter(leader); //创建team对象并设置属性 Team team = new Team(); team.setName(name); team.setSlogan(slogan); team.setLeader(leader); request.setAttribute(team, team);//把team对象保存到request对象里 增加小组—Servlet（源代码）（续） //保存到数据库 try { TeamBusiness.addTeam(team); // 转向成功页面 RequestDispatcher rd = request.getRequestDispatcher(../addTeamSuccess.jsp); rd.forward(request, response); } catch (Exception e) { e.printStackTrace(); // 转向失败页面 RequestDispatcher rd = request.getRequestDispatcher(../addTeamFail.jsp); rd.forward(request, response); } } 增加小组—JSP h1 align=center增加小组成功/h1 %Team team = (Team)request.getAttribute(team); % p组名：%=team.getName()% p口号：%=team.getSlogan()% p组长：%=team.getLeader()% 显示小组 显示小组—业务类的allTeams方法 public static CollectionTeam allTeams() throws Exception { ArrayListTeam teams = new ArrayListTeam();// 创建集合对象 …… rs = stmt.executeQuery(select * from team); while (rs.next()) { Team team = new Team();// 创建team对象 // 用数据库取得的数据设置team对象的属性 team.setId(rs.getInt(id)); team.setName(rs.getString(name)); team.setSlogan(rs.getString(slogan)); team.setLeader(rs.getString(leader));