jsp分页显示

悠悠虾 2010-03-30 10:02:53

大家好，本人初学jsp，有个jsp从数据库读取记录分页显示的问题请教一下！具体jsp代码如下，现在问题是
<div>图书信息</div>以下的内容完全不显示，就跟被注释掉一样，javabean应该没问题，有必要的话我也贴上来，求达人帮忙分析一下，困扰我好几天了，谢谢！！！

<%@ page contentType="text/html; charset=gb2312" language="java"import="java.sql.*;" errorPage=""%>
<jsp:useBean id="m_pages" scope="page" class="book.Pagination"/>
<jsp:useBean id="sql" scope="page" class="book.DataCon"/>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>My JSP 'test.jsp' starting page</title>
</head>
<body>
<div>图书信息</div>
<%
try{
int curPages = m_pages.curPages(m_pages.strPage(request, "page"));
m_pages.setRows(2);
ResultSet rs_count = sql.executeQuery("select count(*) as t from BookInfo");
rs_count.next();
int resultconts = rs_count.getInt("t"); //取得总的数据数
int totalPages = m_pages.getPages(resultconts);//取出总页数
ResultSet rs = m_pages.getPageSet(sql.executeQuery("select BookId,BookName,Author,Press,BookSum from BookInfo"), curPages);
%>
<hr>
<table width="100%" align="center" style="font-size: 15;"border="1";>
<tr>
<td>图书编号</td>
<td>图书名称</td>
<td>作者</td>
<td>出版社</td>
<td>图书总量</td>
</tr>
<%
int i = 1;
%>
<%
while(rs.next())
{
%>
<tr><td width=25px><%=rs.getString("BookId")%></td>
<td><%=rs.getString("BookName")%></td>
<td width=35px><%=rs.getString("Author")%></td>
<td><%=rs.getString("Press")%></td>
<td width=25px><%=rs.getString("BookSum")%></td>
</tr>
<%
i = i + 1;
if (i > 2) break;
}
%>
</table>
<div align="center" style="font-size: 15;">
共<%=resultconts%>个记录分<%=totalPages%>页显示
<%
if (curPages > 1)
{
%>
<a href="fenye.jsp?page=<%=curPages-1%>">上一页</a>
<%
}%>
<%if (curPages < totalPages)
{%>
<a href="fenye.jsp?page=<%=curPages + 1%>">下一页</a>
<%}%>
</div>
<%
} catch (Exception e) {
e.printStackTrace();
}
%>
</body>
</html>

...全文

153 5 打赏收藏转发到动态举报

写回复

用AI写文章

5 条回复

切换为时间正序

请发表友善的回复…

发表回复

cust28 2010-03-30

打赏
举报

找个例子,改改就ok了

qinfeng891030 2010-03-30

打赏
举报

用自定义标签，分页效果很显著的！

a21768541 2010-03-30

打赏
举报

<%
try{
int curPages = m_pages.curPages(m_pages.strPage(request, "page"));
m_pages.setRows(2);
ResultSet rs_count = sql.executeQuery("select count(*) as t from BookInfo");
rs_count.next();
int resultconts = rs_count.getInt("t"); //取得总的数据数
int totalPages = m_pages.getPages(resultconts);//取出总页数
ResultSet rs = m_pages.getPageSet(sql.executeQuery("select BookId,BookName,Author,Press,BookSum from BookInfo"), curPages);
%>

这一段代码可以通过？