📄 624919.xml
字号:
<?xml version='1.0' encoding='GB2312'?>
<?xml-stylesheet type='text/xsl' href='../csdn.xsl'?>
<Topic>
<Issue>
<PostUserNickName>水中之邦</PostUserNickName>
<rank>二级(初级)</rank>
<ranknum>user2</ranknum>
<credit>100</credit>
<TopicId>624919</TopicId>
<TopicName>JSP分页的问题(20)</TopicName>
<PostUserId>152856</PostUserId>
<PostUserName>arnoldyu</PostUserName>
<RoomName>JSP</RoomName>
<ReplyNum>7</ReplyNum>
<PostDateTime>2002-4-5 13:11:59</PostDateTime>
<Point>20</Point>
<ReadNum>0</ReadNum>
<RoomId>28</RoomId>
<EndState>2</EndState>
<Content>我是一个JSP新手，请问JSP网页的分页问题怎么解决(Oracle数据库)，请举例说明！！</Content>
</Issue>
<Replys>
<Reply>
<PostUserNickName>水中之邦</PostUserNickName>
<rank>二级(初级)</rank>
<ranknum>user2</ranknum>
<credit>100</credit>
<ReplyID>4124720</ReplyID>
<TopicID>624919</TopicID>
<PostUserId>152856</PostUserId>
<PostUserName>arnoldyu</PostUserName>
<Point>0</Point>
<Content>请大家快来帮忙啊</Content>
<PostDateTime>2002-4-5 13:54:48</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>没爱，怎么行？</PostUserNickName>
<rank>二级(初级)</rank>
<ranknum>user2</ranknum>
<credit>95</credit>
<ReplyID>4124943</ReplyID>
<TopicID>624919</TopicID>
<PostUserId>113322</PostUserId>
<PostUserName>apboy</PostUserName>
<Point>0</Point>
<Content>我们做的分页是一次读出放到Vector向量中，然后分页</Content>
<PostDateTime>2002-4-5 14:06:41</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>水中之邦</PostUserNickName>
<rank>二级(初级)</rank>
<ranknum>user2</ranknum>
<credit>100</credit>
<ReplyID>4125609</ReplyID>
<TopicID>624919</TopicID>
<PostUserId>152856</PostUserId>
<PostUserName>arnoldyu</PostUserName>
<Point>0</Point>
<Content>请说的详细点
</Content>
<PostDateTime>2002-4-5 14:41:43</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>经历单纯的男人不要奢谈成熟和魅力</PostUserNickName>
<rank>四级(中级)</rank>
<ranknum>user4</ranknum>
<credit>119</credit>
<ReplyID>4126667</ReplyID>
<TopicID>624919</TopicID>
<PostUserId>172275</PostUserId>
<PostUserName>huyuefox</PostUserName>
<Point>5</Point>
<Content>一般的方法：
oracle;用rownum分段查出，速度很快
sql server:用absolute()指向结果集的某一条数据;再利用总页数，每页显示的纪录数，来计算并指向某一页第一条纪录。
</Content>
<PostDateTime>2002-4-5 15:42:37</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>滕老四</PostUserNickName>
<rank>一级(初级)</rank>
<ranknum>user1</ranknum>
<credit>100</credit>
<ReplyID>4127955</ReplyID>
<TopicID>624919</TopicID>
<PostUserId>125086</PostUserId>
<PostUserName>tengyong</PostUserName>
<Point>10</Point>
<Content>你可以用“tag”,标签啊，网上有现成的处理分页显示的“tag lib”，你去下载下来，网址是www.jsptags.com ，名称叫做“Pager Tag Library v1.1”，
1、编辑WEB-INF/Web.xml文件，在<web-app>...</web-app>里添加——
<taglib>
  <taglib-uri>
    http://jsptags.com/tags/navigation/pager
  </taglib-uri>
  <taglib-location>
    /WEB-INF/jsp/pager-taglib.tld
  </taglib-location>
</taglib>
2、建立/WEB-INF/jsp 文件夹，把pager-taglib.tld复制到此目录。
3、建立/WEB-INF/lib 文件夹，把pager-taglib.jar复制到此目录。
4、把pager-demo.jsp 复制到站点根目录。
5、重新启动TOMCAT，然后访问pager-demo.jsp文件。 
我这里有一段程序例子，你可以参考——
<html>
<head>
<title>tag_test</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<%response.setContentType("text/html;Charset=GB2312");%>
<%@ taglib uri="http://jsptags.com/tags/navigation/pager" prefix="pg" %>
<%@ page import="java.sql.*"%>
<jsp:useBean id="db" class="com.bigchina.bugstat.dbquery" scope="page" />
</head>
<body bgcolor="#FFFFFF" text="#000000">
<!-- 设置分页显示程序的相关变量 -->
<%
	String requestUri = request.getRequestURI();
	int indexOfqm = requestUri.indexOf('?');
	if (indexOfqm != -1)
		requestUri = requestUri.substring(0, indexOfqm);
	String style = request.getParameter("style");
%>
<!-- END -->
<!-- 选择分页形式 -->
<table width="85%" border="0" cellspacing="0" cellpadding="0" align="center">
  <tr> 
    <td width="56%" height="4" > 
      <h4 align="right"><font face="Arial, Helvetica, sans-serif">请选择分页形式<br>
        </font><font face="Arial, Helvetica, sans-serif">
        <a href="<%= requestUri %>?style=simple">Simple</a> 
        <a href="<%= requestUri %>?style=jsptags">JSPTags.com</a> 
        <a href="<%= requestUri %>?style=altavista">AltaVista&reg;</a> 
        <a href="<%= requestUri %>?style=google"><font color="#0000cc">G</font><font color="#cccc00">oo</font><font color="#0000cc">g</font><font color="#00cc00">l</font><font color="#cc0000">e</font><small><sup>SM</sup></small></a> 
        </font>
	   </h6>
      </td>
  </tr>
</table>
<!-- END -->
<!-- 设置分页显示每页的记录个数 -->
<pg:pager maxIndexPages="<%= 10 %>">
  <pg:param name="style"/> 
<!-- END -->
<table width="85%" border="1" cellspacing="0" cellpadding="0" align="center">
  <tr>
  	<td width="10%"><div align="center">序号</div></td>
    <td width="25%"><div align="center">发表时间</div></td>
    <td width="50%"><div align="center">主题</div></td>
    <td width="10%"><div align="center">长度</div></td>
  </tr>
<%
String boardID="3";
db.connectDB();
String strSQL="select * from bbs1 where boardID='"+boardID+"' and isdelete='N' order by createtime asc ";
int i=0;
db.executeQuery("benss",strSQL);
while(db.next("benss"))
{
	String topic=db.getString("benss","topic");
    String time=db.getString("benss","createtime");
    String lenth=db.getString("benss","lengh"); 
	i=i+1;
%>
<!-- 显示一条记录 -->
<pg:item> 
  <tr>
	<td width="10%"><%=i%></td>
    <td width="25%"><%=time%></td>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -