Java web 分页技术

第一步数据库分页语句

第二部 完成model模块 建立 pagebean

import  java.util.*;

public class PageBean

{

privatee Collection objs ;//从数据库中读取的集合；

private int  totalCount ;//总的条数

private int pageNo;//当前的页数

private int pageCount ;//每页的条数

public int  getPageCouunt()

{

return pageCount ;

}

public void setPageCouunt( int pageCount)

{

this.pageCount = pageCount ;

}

public int  getPageNo()

{

return pageNo ;

}

public void   setPageNo( int pageNo)

{

this.pageNo= pageNo

}

public int getTotalPage()

{

if(tatolCouunt$pageCount == 0)

{

return totalCouunt/pageCount;

}else
{

return totalCount / pageCount + 1;

}

}

//多写的一个判断下一页的方法

public boolean isNext()

{

return pageNo < getTotalPage() ;

}

//上一页的方法

public boolean isPrevious(){

return pageNo > 1 ;

}

public Collection getObjs()

{

return objs ;

}

public void setObjs (Collection objs)

{

this.objs = objs ;

}

public int getPageNo(){

return pageNo ;

}

public int getTotalCount()

{

return totalCount ;

}

public void setTotalCount(iint totalCount)

{

this.totalCouunt = totalCount ;

}

public PageBean(Collection objs ,int tatolCount , int pageNo ,int  pageCount)

{

this.objs = objs ;

this.totalCount = totalCount ;

this.PageNo = pageNo ;

this.pageCount = pageCount ;

}

开始写biz模块

写一个具体的分页逻辑

import java.util.*;

import java.sql.*;

public class EmpBiz{

public EmpBIz()

{

//具体实现分页的方法

public PageBean listEmps(int pageNo ,int  pageCount)

{

Connection con = null ;

Statement stmt = null ;

ResultSet rs = null ;

ArrayList emps = new ArrayList();

//

int a = pageNo * pageCount;

int b = (pageNo - 1) * pageCount ;

try{

Class.forName ("com.microsoft.sqlserver.jdbc.SQLSeerverDriver");

con = DriverManager.getConnection("数据库端口号和名字  " ,"用户名","密码");

stmt = con.createStatement();

rs = stmt.executeQuery("sql语句");

while(rs.next())

{

}

rs = stmt.executeQuery("select count(*) from emp ");

int totalCount = 0 ;

if(rs.next)

{

totalCount = rs.getInt(1);

}

PageBean pageBean = new PageBean(emps, totalCount ,pageNo ,pageCount );

return pageBean ;

}catch(){

}finally

{

//关闭资源

}

}

}

servlet类

jsp 页面实现

文章引用http://wenku.baidu.com/view/249e35d276eeaeaad1f33060.html