servlet mysql 分页_servlet jsp实现分页功能代码解析（一）

2  model层,一个数据库对应的model(Blog)，还有一个pageBean(BlogPage)

import java.sql.Date;

public class Blog {

private int id;

private int category_id;

private String title;

private String content;

private Date created_time;

//getter和setter方法

@Override

public String toString() {

return "Blog [id=" + id + ",

category_id=" + category_id + ",

title=" + title + ",

content=" + content

+ ",

created_time=" + created_time + "]";

}

}

public class BlogPage {

private List pagerecord;//每页记录

private int pageno;//当前页

private int pagenostart;//每页开始索引

private int pagesize=5;//每页多少数据

private int totalrecord;//总记录数

private int totalpage;//总页数

public BlogPage(int pageno,int totalrecord){

//pageno totalrecord都可以当做已有信息

this.totalrecord=totalrecord;

//计算总页数

totalpage=(totalrecord%pagesize==0)?totalrecord/pagesize:totalrecord/pagesize+1;

//pageno的边界处理

if(pageno<=1)

this.pageno=1;

else if(pageno>=totalpage)

this.pageno=totalpage;

else

this.pageno=pageno;

//计算每页开始索引，即每页第一个数据的索引，用于分页查询

pagenostart=(this.pageno-1)*pagesize;

}

public int getPagenostart() {

return pagenostart;

}

public void setPagenostart(int pagenostart) {

this.pagenostart = pagenostart;

}

public List getPagerecord() {

return pagerecord;

}

public void setPagerecord(List pagerecord) {

this.pagerecord = pagerecord;

}

public int getPageno() {

return pageno;

}

public void setPageno(int pageno) {

this.pageno = pageno;

}

public int getPagesize() {

return pagesize;

}

public void setPagesize(int pagesize) {

this.pagesize = pagesize;

}

public int getTotalrecord() {

return totalrecord;

}

public void setTotalrecord(int totalrecord) {

this.totalrecord = totalrecord;

}

public int getTotalpage() {

return totalpage;

}

public void setTotalpage(int totalpage) {

this.totalpage = totalpage;

}

}