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 对象, 上网搜了一下,记录一下这段代码,以便以后用.