从数据库中取一组数据放到Bean中:TeamBusiness.java
servlet接收数据并存入request供jsp调用:addTeam1.java
用jsp取request中的数据并显示:viewTeams.jsp
package business;
import java.sql.*;
import java.util.ArrayList;
import java.util.Collection;
import database.DataSource;
import bean.Team;
public class TeamBusiness{
public static void addTeam(Team team)throws Exception{
Connection cn=null;
PreparedStatement pst=null;
try{
cn=DataSource.getConnection();
pst=cn.prepareStatement("insert into team(name,slogan,leader) values(?,?,?)");
pst.setString(1, team.getName());
pst.setString(2, team.getSlogan());
pst.setString(3, team.getLeader());
pst.executeUpdate();
}catch(Exception e){
throw e;
}finally{
try{
pst.close();
cn.close();
}catch(Exception e){
e.printStackTrace();
}
}
}
public static Collection<Team> allTeams() throws Exception {
ArrayList<Team> teams = new ArrayList<Team>();// 创建集合对象
// 从数据库获取数据
Connection cn = null;
PreparedStatement pst = null;
ResultSet rs = null;
try {
cn = DataSource.getConnection();
pst = cn.prepareStatement("select * from team");
rs = pst.executeQuery();
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"));
teams.add(team);// 把team对象放到集合teams中
}
} catch (Exception e) {
throw e;
} finally {
try {
rs.close();
pst.close();
cn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
return teams;
}
}
servlet接收数据并存入request供jsp调用:addTeam1.java
/*
* 通过mysql来查询表单数据并显示
*/
package servlet;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import java.util.Collection;
import bean.Team;
import business.TeamBusiness;
public class viewTeams1 extends HttpServlet{
protected void doGet(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {
try {
Collection<Team> teams=TeamBusiness.allTeams();
request.setAttribute("teams", teams);
RequestDispatcher rd = request.getRequestDispatcher("../viewTeams.jsp");
rd.forward(request, response);
} catch (Exception e) {
e.printStackTrace();
RequestDispatcher rd = request.getRequestDispatcher("../viewTeamsFail.jsp");
rd.forward(request, response);
}
}
protected void doPost(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {
this.doGet(request, response);
}
}
用jsp取request中的数据并显示:viewTeams.jsp
<?xml version="1.0" encoding="GBK" ?>
<%@ page language="java" contentType="text/html; charset=GBK"
import="java.util.*,bean.Team;" pageEncoding="GBK"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GBK" />
<title>Insert title here</title>
</head>
<body>
<table border="1" align="center">
<tr><th>组名</th><th>口号</th><th>组长</th></tr>
<%
Collection<Team> teams = (Collection<Team>)request.getAttribute("teams");
Iterator<Team> it = teams.iterator();
while(it.hasNext()) {
Team team = it.next();
%>
<tr>
<td><%=team.getName()%></td>
<td><%=team.getSlogan()%></td>
<td><%=team.getLeader()%></td>
</tr>
<%
}
%>
</table>
</body>
</html>