JDBC新对象CachedRowSetImpl访问数据方法

1. JDBC CachedRowSetImp获取数据
import com.sun.rowset.CachedRowSetImpl;
public CachedRowSetImpl getList()
{ 
     CachedRowSetImpl rowset = null;
 try   
 {     
 Connection conn = DriverManager.getConnection(......);
  Statement stmt = con.createStatement();
 String strSQL = "select * from 表名";
 ResultSet rs = stmt.executeQuery(strSQL);    
  rowset = new CachedRowSetImpl();
  rowset.populate(rs);
  rs.close();
   stmt.close();
   conn.close();
 return rowset;
 }   
 catch(Exception   e)   
 {
  }
 return rowset;
}
2. 显示CachedRowSetImpl对象数据
<jsp:useBean id="userService" class="book.UserService" />
<jsp:useBean id="rowset" class="com.sun.rowset.CachedRowSetImpl" />
<%   
  rowset=userService.getList();
 while(rowset.next())
 {
 out.println(rowset.getString("name"));
 }
rowset.close();
 %>  

这学期开了 JSP 课, 看到了 没有用过的 CachedRowSetImpl 对象, 上网搜了一下,记录一下这段代码,以便以后用.