📄 page.java
字号:
package com.db;
import java.util.*;
final public class page{
private int pagecount=0;//分页总数
private int pagenum; //总页数 除10后的页数
private int nowpage; //当前页 除10后的页数
private int rows; //行总数
private int rownum; //每页显示多少条记录
private int pageno; //当前页
private String pageString;
private String errors="";
public page(){
}
//行总数,每页显示多少记录,当前页
public void setPageString(int rows,int rownum,int pageno,int page__,String urlval){
this.rownum=rownum;
this.pageno=pageno;
this.rows=rows;
if(rows%rownum==0){
setPagecount(rows/rownum);
}
else{
setPagecount(rows/rownum+1);
}
if(pageno<=0){
pageno=1;
}
else if(pageno>pagecount){
pageno=pagecount;
}
if(pageno%page__==0){
nowpage=pageno/page__;
}
else{
nowpage=pageno/page__+1;
}
if(pagecount%page__==0){
pagenum=pagecount/page__;
}
else{
pagenum=pagecount/page__+1;
}
if(pagenum==1){
pageString="<FONT face='webdings'>9</FONT> ";
int i=1;
while(i<=pagecount){
if(i==pageno){
pageString=pageString+"<a style='color:red'>"+i+"</a> ";
}
else{
pageString=pageString+"<a href='?pageno="+i+"&"+urlval+"'>"+i+"</a> ";
}
i++;
}
pageString=pageString+"<FONT face='webdings'>:</FONT>";
}
else if(pagenum>1){
if(nowpage==1){
pageString="<FONT face='webdings'>9</FONT><FONT face='webdings'>7</FONT> ";
int i=(nowpage-1)*page__+1;
while(i<=nowpage*page__){
if(i==pageno){
pageString=pageString+"<a style='color:red'>"+i+"</a> ";
}
else{
pageString=pageString+"<a href='?pageno="+i+"&"+urlval+"'>"+i+"</a> ";
}
i++;
}
pageString=pageString+"<a href='?pageno=11&"+urlval+"' title='下十页'><FONT face='webdings'>8</FONT></a><a href='?pageno="+pagecount+"&"+urlval+"' title='尾页'><FONT face='webdings'>:</FONT></a>";
}
else if(nowpage>1 && nowpage<pagenum){
pageString="<a href='?pageno=1&"+urlval+"' title='首页'><FONT face='webdings'>9</FONT></a><a href='?pageno="+((nowpage-1)*page__)+"&"+urlval+"' title='上十页'><FONT face='webdings'>7</FONT></a> ";
int i=(nowpage-1)*page__+1;
while(i<=nowpage*page__){
if(i==pageno){
pageString=pageString+"<a style='color:red'>"+i+"</a> ";
}
else{
pageString=pageString+"<a href='?pageno="+i+"&"+urlval+"'>"+i+"</a> ";
}
i++;
}
pageString=pageString+"<a href='?pageno="+(nowpage*page__+1)+"&"+urlval+"' title='下十页'><FONT face='webdings'>8</FONT></a><a href='?pageno="+pagecount+"&"+urlval+"' title='尾页'><FONT face='webdings'>:</FONT></a>";
}
else if(nowpage>=pagenum){
pageString="<a href='?pageno=1&"+urlval+"' title='首页'><FONT face='webdings'>9</FONT></a><a href='?pageno="+((nowpage-1)*page__)+"&"+urlval+"' title='上十页'><FONT face='webdings'>7</FONT></a> ";
int i=(nowpage-1)*page__+1;
while(i<=pagecount){
if(i==pageno){
pageString=pageString+"<a style='color:red'>"+i+"</a> ";
}
else{
pageString=pageString+"<a href='?pageno="+i+"&"+urlval+"'>"+i+"</a> ";
}
i++;
}
pageString=pageString+"<FONT face='webdings'>8</FONT><FONT face='webdings'>:</FONT>";
}
}
}
public String getPageString(){
return pageString;
}
public void setPagecount(int pagecount){
this.pagecount=pagecount;
}
public int getPagecount(){
return pagecount;
}
public int getRows(){
return rows;
}
public String getPageSql(String sql){//pageno为新页
String newsql="select * from (select rownum r_id,t.* from ("+sql+
") t where rownum <= " + (pageno*rownum) + ") where r_id >" +((pageno-1)*rownum);
return newsql;
}
public void setErrors(String error){
this.errors=error;
}
public String getErrors(){
return errors;
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -