japger 和数据库相连
<%@page language="java" contentType="text/html; charset=gb2312"%>
<%request.setCharacterEncoding("GBK");%>
<%@ page import="java.sql.*"%>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String dbUrl = "jdbc:odbc:web";
Connection conn;
Statement stm;
conn = DriverManager.getConnection(dbUrl,"","");
stm=conn.createStatement();
String sqlPass="select * from user";
ResultSet rsPass=stm.executeQuery(sqlPass); //数据库连接没问题
%>
<%@ taglib uri="http://jpager.com/taglibs/page" prefix="page"%>
<c:set var="result" value="rsPass"/> //此处是否有问题?
<table border=1 cellSpacing=0 borderColorLight="#666666" BorderColorDark="#ffffff">
<tr>
<td>序号</td>
<td>姓名</td>
<td>密码</td>
</tr>
<page:pager dz="30">
<c:forEach var="row" items="${result.rows}" varStatus="status">
<page:item nr="${status.count}">
<tr>
<td nowrap>${status.count} </td>
<td nowrap>${row.username} </td>
<td nowrap>${row.userpass} </td>
</tr>
</page:item>
</c:forEach>
</page:pager>
<tr>
<td colspan="3" align="center">
<page:bt/>
</td>
</tr>
</table>
请问高手,如何解决jpager与数据库相连(页面已能正常运行,但是没有数据显示)