📄 pooltest.jsp
字号:
<!--PoolTest.jsp-->
<html>
<head>
<title>TestPool</title>
</body>
<body>
<%@ page import="chapter9.PoolBean"%>
<%@ page import="java.util.*, java.sql.*"%>
<%@ page contentType="text/html;charset=gb2312" %>
<jsp:useBean id="pool" scope="application" class="chapter9.PoolBean"/>
<%
Connection con = null;
try{
if (pool.getDriver()==null){
pool.setDriver("sun.jdbc.odbc.JdbcOdbcDriver");
pool.setURL("jdbc:odbc:student");
pool.setSize(5);
pool.initializePool();
}
con = pool.getConnection();
Statement statement = con.createStatement();
ResultSet rs = statement.executeQuery("select * from student");
%>
<table width="500" >
<tr>
<td ><table border="1" width="500">
<td width="100" valign="middle" align="center">学号</td>
<td width="100" valign="middle" align="center">姓名</td>
<td width="100" valign="middle" align="center">数学成绩</td>
<td width="100" valign="middle" align="center">语文成绩</td>
<td width="100" valign="middle" align="center">外语成绩</td>
</table></td>
</tr>
<%
while (rs.next()){
int id=rs.getInt(1);
String name=rs.getString(2);
int math=rs.getInt(3);
int chinese=rs.getInt(4);
int english=rs.getInt(5);
%>
<tr>
<td><table border="1" width="500">
<td width="100" valign="middle" align="center"><%=id%></td>
<td width="100" valign="middle" align="center"><%=name%></td>
<td width="100" valign="middle" align="center"><%=math%></td>
<td width="100" valign="middle" align="center"><%=chinese%></td>
<td width="100" valign="middle" align="center"><%=english%></td>
</table></td>
</tr>
<%
}
rs.close();
%>
</table>
<%
pool.releaseConnection(con);
}
catch (Exception e){
out.print(e);
}
%>
</body>
</body>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -