<%
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
} catch (ClassNotFoundException e) {
e.toString();
}
String url = "jdbc:odbc:test1";
String user = "sa";
String password = "";
Connection conn = DriverManager.getConnection(url, user, password);
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
String sql = "select * from bookpr";
ResultSet rs = stmt.executeQuery(sql);
int pagesize = 4;
int rowcount = 0;
int pagecount = 0;
if (!rs.next()) {
out.println("no records");
} else {
rs.last();
rowcount = rs.getRow();
int showpage = 1;
pagecount = ((rowcount % pagesize) == 0 ? (rowcount / pagesize) : (rowcount / pagesize) + 1);
String topage = request.getParameter("topage");
if (topage != null) {
showpage = Integer.parseInt(topage);
if (showpage > pagecount) {
showpage = pagecount;
} else if (showpage <= 0) {
showpage = 1;
}
}
rs.absolute((showpage - 1) * pagesize + 1);
for (int i = 1; i <= pagesize; i++) {
%>
<table width="500" border="1" align="center">
<tr>
<td align="center" width="250"><%=rs.getString(1)%></td>
<td align="center"><%=rs.getString(2)%></td>
</tr>
</table>
<%
if (!rs.next()) {
break;
}
}
%>
<table width="500" border="1" align="center">
<tr>
<td width="535" height="26" align="right">
<a href="pagination.jsp?topage=<%=1%>">第一页</a>
<a href="pagination.jsp?topage=<%=showpage - 1%>">上一页</a>
<a href="pagination.jsp?topage=<%=showpage + 1%>">下一页</a>
<a href="pagination.jsp?topage=<%=pagecount%>">最后一页</a>
<input name="topage" type="text" size="5" value=" <%=showpage%>">
页</td>
<%
}
%>
</tr>
jsp做的分页显示
最新推荐文章于 2022-06-30 14:29:28 发布