jsp使用javabean实现分页问题？帮我测试，谢谢

Question

package firm;
import java.sql.*;
public class firm
{
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:firm";
private Connection conn = null;
private Statement stmt = null;
ResultSet rs = null;
public firm(){
try
{
Class.forName(sDBDriver);
}
catch (java.lang.ClassNotFoundException e)
{
System.err.println("firm(): "+e.getMessage());
}
}
public ResultSet executeQuery(String sql) {
rs=null;
try
{
conn=DriverManager.getConnection(sconnStr);
stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
}
catch (SQLException ex)
{
System.err.println("aq.executeQuery:"+ex.getMessage());
}
return rs;
}
public void executeUpdate(String sql){
stmt=null;
rs=null;
try
{
conn=DriverManager.getConnection(sConnStr);
stmt=conn.createStatement();
stmt.executeQuery(sql);
stmt.close();
conn.close();
}
catch (SQLException ex)
{
System.err.println("aq.executeQuery:"+ex.getMessage());
}
}
public void closeStmt(){
try
{
stmt.close():;
}
catch (SQLException e)
{
e.printStackTrace();
}
}
public void closeConn(){
try
{
conn.close();
}
catch (SQLException e)
{
e.printStackTrace();
}
}
};
用这个试一下.然后把它作一点改到(我是指连接数据库)还剩下黑眼圈