81,091
社区成员
发帖
与我相关
我的任务
分享
<%@ page
contentType="text/html;charset=GBK"
import="java.sql.*"
%>
<jsp:useBean id="jb" scope="page" class="bean.JavaBeanJSP"/>
<%!
ResultSet rs;
%>
<html>
<head>
<title>HelloBean</title>
<meta http-equiv="Content-Type" content="text/html;charset=gb2312">
</head>
<body>
<center>
<br><br><br>
<table border="1" borderColorDark="#ffffec" borderColorLight="#5e5e00" cellPadding="1" cellSpacing="0" width=50%>
<tr><th>empno</th><th>ename</th><th>job</th></tr>
<%
try {
rs=jb.getResultSet();
while(rs.next()) {
%>
<tr>
<td><%= rs.getString(1)%></td>
<td><%= rs.getString(2)%></td>
<td><%= rs.getString(3)%></td>
</tr>
<%
}
} catch (SQLException se) {
se.printStackTrace();
} finally {
try {
if(rs!=null)
rs.close();
} catch(SQLException se) {
se.printStackTrace();
}
}
%>
</table>
</center>
</body>
</html>
package bean;
import java.sql.*;
public class JavaBeanJSP{
private Connection con;
private Statement stmt;
private ResultSet rs;
public ResultSet getResultSet() {
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection ct = DriverManager.getConnection
("jdbc:oracle:thin:@127.0.0.1:1521:ORCL","scott","tiger");
Statement sm = ct.createStatement();
ResultSet rs = sm.executeQuery("select * from emp");
} catch(SQLException se) {
se.printStackTrace();
} catch(Exception e) {
e.printStackTrace();
}
return rs;
}
}