aaa.jsp/存在D:\jakarta-tomcat-3.3.1\webapps\ROOT\test
<%@ page contentType="text/html; charset=gb2312"%>
<%@ page import="java.sql.*"%>
<jsp:useBean id="personbean" scope="session" class="person.personbean"/>
<%! String sql;%>
<%


sql="select * from Table1";

ResultSet RS=personbean.executeQuery(sql);

while (RS.next())
{

out.print(RS.getString("name"));
}
RS.close();%>
///////////////////////////////////////////////////////////
personbean.java/存在D:\jakarta-tomcat-3.3.1\webapps\ROOT\test\WEB-INF\classes下
package person;
import java.sql.*;public class personbean
{
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:ym";
Connection conn = null;
ResultSet rs = null; public personbean()
{
try
{
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("personbean():" + e.getMessage());
}
} public ResultSet executeQuery(String sql)
{
rs = null;
try
{
conn=DriverManager.getConnection(sConnStr);
Statement stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex)
{
System.err.println("personbean.executeQuery:" + ex.getMessage());
}
return rs;
}
}