81,092
社区成员
发帖
与我相关
我的任务
分享
package com.dz.tool;
/**
* 做分页操作的工具类
* @author Administrator
*
*/
public class Page {
private int pageidid;//页数
private int prepage;//上一页
private int nextpage;//下一页
private String next;
private String pre;
private int pagesize;
private int totalRecord;
public int getTotalRecord() {
return totalRecord;
}
public void setTotalRecord(int totalRecord) {
this.totalRecord = totalRecord;
}
public int getPagesize() {
return pagesize;
}
public void setPagesize(int pagesize) {
this.pagesize = pagesize;
}
private int totalpage;
public int getTotalpage() {
return totalpage;
}
public void setTotalpage(int totalpage) {
this.totalpage = totalpage;
}
public int getPageidid() {
return pageidid;
}
public void setPageidid(int pageidid) {
this.pageidid = pageidid;
}
public int getPrepage() {
return prepage;
}
public void setPrepage(int prepage) {
this.prepage = prepage;
}
public int getNextpage() {
return nextpage;
}
public void setNextpage(int nextpage) {
this.nextpage = nextpage;
}
public String getNext() {
return next;
}
public void setNext(String next) {
this.next = next;
}
public String getPre() {
return pre;
}
public void setPre(String pre) {
this.pre = pre;
}
public Page(String next, int nextpage, int pageidid,
String pre, int prepage,int totalpage) {
super();
this.next = next;
this.nextpage = nextpage;
this.pageidid = pageidid;
this.pre = pre;
this.prepage = prepage;
this.totalpage=totalpage;
}
public Page() {
super();
}
//pageid当前页,all总记录数,num为每页显示大小
public void apartPage(int pageid,int all,int num){
this.totalpage=this.computeTotal(all, num);//首先计算总页数
this.totalRecord=all;
this.setPagesize(num);
this.setPageidid(pageid);
this.setNextpage(pageid);
this.setPrepage(pageid);
this.setNext("下一页");
this.setPre("上一页");
if(pageid>1){//表示有上一页
this.setPrepage(pageid-1);
}else{
this.setPre("首页");
}
int rest=all-pageid*num;
if(rest>0){//表示有下一页
this.setNextpage(pageid+1);
}else{this.setNext("尾页");}
if(this.pre.equals("首页")&&this.next.equals("尾页")){
this.setNext("");
}
}
//计算总页数
private int computeTotal(int all,int num){
int page=all/num;
page=all/num>0?page+1:page;
setTotalpage(page);
return this.totalpage;
}
}
String sql="select id,title,content,time from news order by time desc LIMIT 0, 10";
//关键就是这句sql,后面的0,10,表示查询的数据,第一页是0-10,第二页就是11-20,
//根据页面来计算这个参数然后查询就可以了!需要从页面传递一个页面page参数,根据这个参
//数计算应该查询的数据范围,另外这里用了limit,是不是有点不好,有的数据库没有这个关键字的