---
title: "分页的类及调用"
author: "fanjava"
date: "2004-10-05T19:54:00Z"
tags: []
slug: "untitled"
draft: false
lastmod: "2004-10-05T19:54:00Z"
id: 601852
url: "https://fanjava.iteye.com/blog/601852"
---

//PageCt.java 分页的类  
/*  
\*\** @version \*\*\*\*\*\*\*\*\*\**  
![](/Emoticons/tongue_smile.gif)![](/Emoticons/tongue_smile.gif)![](/Emoticons/tongue_smile.gif)![](/Emoticons/tongue_smile.gif)![](/Emoticons/tongue_smile.gif)  
\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\**  
\*/  
package vod;  
import java.sql.\*;  
import java.util.\*;

public class PageCt  
{  
private long l\_start; //开始纪录  
private long l\_end; //结束纪录  
private long l\_curpage; //当前页数  
private long l\_totalnum;//总记录数  
private int int\_num=5; //每页10条  
private long l\_totalpage; //总的页数

public void Init(long currentpage,long totalnum)  
{  
l\_curpage = currentpage;  
l\_totalnum = totalnum;

if (currentpage&gt;=0)  
{  
if (currentpage&gt;=(long)Math.ceil((double)l\_totalnum/(double)int\_num))  
l\_curpage = (long)Math.floor((double)l\_totalnum/(double)int\_num);  
else  
l\_curpage = currentpage;  
}  
else  
{  
l\_curpage = 0;  
}  
l\_start = l\_curpage * int\_num;  
l\_end = l\_start + int\_num;  
if (l\_end &gt; l\_totalnum)  
l\_end = l\_totalnum;  
l\_totalpage = (long)Math.ceil((double)l\_totalnum/(double)int\_num);  
}  
public long getCurpage()  
{  
return l\_curpage;  
}  
public long getPrepage()  
{  
if (l\_curpage-1&gt;=0)  
{  
return l\_curpage-1;  
}  
else  
{  
return 0;  
}  
}  
public long getNextpage()  
{  
if (l\_curpage+1&lt;=l\_totalpage)  
{  
return l\_curpage+1;  
}  
else  
{  
return l\_totalpage;  
}  
}  
public long getTotalnum()  
{  
return l\_totalnum;  
}  
public long getTotalpage()  
{  
return l\_totalpage;  
}  
public long getStart()  
{  
return l\_start;  
}  
public long getEnd()  
{  
return l\_end;  
}

};  
\===============================================  
//调用例子  
&lt;%  
/*  
![](/Emoticons/tongue_smile.gif)![](/Emoticons/tongue_smile.gif)![](/Emoticons/tongue_smile.gif)![](/Emoticons/tongue_smile.gif)![](/Emoticons/tongue_smile.gif)  
\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\**  
\*/  
&lt;%@ page import="java.sql.\*"%&gt;  
&lt;%@ page import="java.lang.\*"%&gt;  
&lt;%@ page contentType="text/html;charset=gb2312" %&gt;  
&lt;jsp:useBean id="PageCount" scope="page" class="kstest.PageCt" /&gt;  
&lt;jsp:useBean id="sqlbean" scope="page" class="vod.sql\_data" /&gt;  
&lt;html&gt;  
&lt;head&gt;  
&lt;TITLE&gt;测试&lt;/TITLE&gt;  
&lt;STYLE&gt;  
body,table{font-size:9pt}  
A:link {  
COLOR: #000084; TEXT-DECORATION: none  
}  
A:visited {  
COLOR: #000084; TEXT-DECORATION: none  
}  
A:hover {  
COLOR: black; TEXT-DECORATION: underline  
}  
.ourfont {  
FONT-SIZE: 9pt  
}  
&lt;/STYLE&gt;  
&lt;/head&gt;  
&lt;body bgcolor=#eff3ff&gt;  
&lt;center&gt;  
&lt;font color=#000084&gt;&lt;h3&gt;Test for Test&lt;/h3&gt;&lt;/font&gt;  
&lt;hr width=600 color=#b5dbff&gt;  
&lt;br&gt;  
&lt;%  
ResultSet rs0 = sqlbean.executeQuery("select count(\*) from UserList );  
rs0.next();  
long data\_num=rs0.getLong(1);  
long Current\_Page = 0;  
String currentpage=(String)request.getParameter("currentpage");  
if (currentpage != null && !currentpage.equals(""))  
{  
Current\_Page = Integer.parseInt(request.getParameter("currentpage"));  
}  
String Query\_Page=(String)request.getParameter("Query\_Page");  
if (Query\_Page!=null && !Query\_Page.equals(""))  
{  
Current\_Page = Integer.parseInt(request.getParameter("Query\_Page"))-1;  
}  
PageCt.Init(Current\_Page,data\_num);  
long l\_start = PageCt.getStart();  
long l\_end = PageCt.getEnd();  
//查询记录  
ResultSet rs = sqlbean.executeQuery("select * from UserList " );  
long i=0;  
while((i&lt;l\_start) && rs.next())  
{  
i++;  
}  
//输出查询结果  
long j=0;  
while(rs.next() && (i&lt;l\_end))  
{  
j=i+1;  
String col2 = rs.getString(2);  
String col3 = rs.getString(3);  
String col4 = rs.getString(4);  
String col5 = rs.getString(5);  
String col6 = rs.getString(6);  
String col7 = rs.getString(7);  
String col8 = rs.getString(8);  
//打印所显示的数据  
out.println("&lt;table border=0 width=600&gt;");  
out.println("&lt;tr&gt;&lt;td colspan=2&gt;&lt;font color=#000084&gt;" + j + "、"+(col2==null?"":col2)+"&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td colspan=2&gt;答案："+(col3==null?"":col3)+"&lt;/td&gt;&lt;/tr&gt;");  
out.println("&lt;tr&gt;&lt;td&gt;&nbsp;&nbsp;选项1："+(col4==null?"":col4)+"&lt;/td&gt;&lt;td&gt;&nbsp;&nbsp;选项2："+(col5==null?"":col5)+"&lt;/td&gt;&lt;/tr&gt;");  
out.println("&lt;tr&gt;&lt;td&gt;&nbsp;&nbsp;选项3："+(col6==null?"":col6)+"&lt;/td&gt;&lt;td&gt;&nbsp;&nbsp;选项4："+(col7==null?"":col7)+"&lt;/td&gt;&lt;/tr&gt;");  
if (col8!=null && !col8.equals(""))  
{  
out.println("&lt;tr&gt;&lt;td colspan=2&gt;备注："+col8+"&lt;/td&gt;&lt;/tr&gt;");  
}  
out.println("&lt;/table&gt;&lt;br&gt;");  
i++;  
}  
%&gt;  
&lt;table width=600&gt;  
&lt;tr bgcolor=#b5dbff&gt;  
&lt;form method=GET action=index.jsp&gt;  
&lt;td width=80 align=center valign=bottom&gt;共 &lt;%=PageCt.getTotalnum()%&gt; 条&lt;/td&gt;  
&lt;td width=80 align=center valign=bottom&gt;&lt;%=PageCt.getCurpage()+1%&gt;/&lt;%=PageCt.getTotalpage()%&gt; 页&lt;/td&gt;  
&lt;td width=120 align=center&gt;查看第 &lt;input type=text name=Query\_Page size=3&gt; 页&lt;/td&gt;  
&lt;td width=50 align=center valign=bottom&gt;&lt;a href=index.jsp?currentpage=&lt;%=PageCt.getPrepage()%&gt;&gt;上页&lt;/a&gt;&lt;/td&gt;  
&lt;td width=50 align=center valign=bottom&gt;&lt;a href=index.jsp?currentpage=&lt;%=PageCt.getNextpage()%&gt;&gt;下页&lt;/a&gt;  
&lt;/td&gt;  
&lt;/tr&gt;  
&lt;/table&gt;  
&lt;br&gt;&lt;br&gt;&lt;br&gt;  
&lt;table cellspacing=20&gt;  
&lt;tr&gt;  
&lt;td&gt;问题包含&lt;input type=text name=question\_str size=10 value=&lt;% if (question\_str != null) out.println(question\_str); %&gt; &gt;&lt;/td&gt;  
&lt;td&gt;答案包含&lt;input type=text name=answer\_str size=10 value=&lt;% if (answer\_str != null) out.println(answer\_str); %&gt; &gt;&lt;/td&gt;  
&lt;td&gt;选项包含&lt;input type=text name=sel\_str size=10 value=&lt;% if (sel != null) out.println(sel); %&gt; &gt;&lt;/td&gt;  
&lt;/tr&gt;  
&lt;tr&gt;  
&lt;td colspan=3 align=center&gt;&lt;input type=submit value=查询&gt;&lt;/td&gt;  
&lt;/tr&gt;  
&lt;/form&gt;  
&lt;/table&gt;  
&lt;br&gt;&lt;br&gt;  
&lt;a href="insert.jsp"&gt;添加&lt;/a&gt;  
&lt;center&gt;  
&lt;/body&gt;  
&lt;/html&gt;