java resultset分页_重写ResultSet实现分页功能(最好的分页技术)（转）

1.首先定义一个接口Pageable 继承ResultSet这个类

并在接口中定义一些自己的方法,具体方法如下:

package com.page;

import java.sql.ResultSet;

public interface Pageable extends ResultSet {

/**返回总页数

*/

int getPageCount();

/**返回当前页的记录条数

*/

int getPageRowsCount();

/**返回分页大小

*/

int getPageSize();

/**转到指定页

*/

void gotoPage(int page) ;

/**设置分页大小

*/

void setPageSize(int pageSize);

/**返回总记录行数

*/

int getRowsCount();

/**

* 转到当前页的第一条记录

* @exception java.sql.SQLException 异常说明。

*/

void pageFirst() throws java.sql.SQLException;

/**

* 转到当前页的最后一条记录

* @exception java.sql.SQLException 异常说明。

*/

void pageLast() throws java.sql.SQLException;

/**返回当前页号

*/

int getCurPage();

}

2.然后定义一个类PageableResultSet 实现这个接口,覆盖ResultSet的所有方法.并实现接口Pageable 中自定义的方法,具体实现方式如下:

package com.page;

import java.io.InputStream;

import java.io.Reader;

import java.math.BigDecimal;

import java.net.URL;

import java.sql.Array;

import java.sql.Blob;

import java.sql.Clob;

import java.sql.Date;

import java.sql.Ref;

import java.sql.ResultSetMetaData;

import java.sql.SQLException;

import java.sql.SQLWarning;

import java.sql.Statement;

import java.sql.Time;

import java.sql.Timestamp;

import java.util.Calendar;

import java.util.Map;

public class PageableResultSet implements Pageable {

protected java.sql.ResultSet rs=null;

protected int rowsCount;

protected int pageSize;

protected int curPage;

protected String command = "";

public PageableResultSet(java.sql.ResultSet rs) throws java.sql.SQLException {

if(rs==null) throw new SQLException("given ResultSet is NULL","user");

rs.last();

rowsCount=rs.getRow();

System.out.println(rowsCount);

rs.beforeFirst();

this.rs=rs;

}

public int getCurPage() {

return curPage;

}

public int getPageCount() {

if(rowsCount==0) return 0;

if(pageSize==0) return 1;

//  calculate PageCount

double tmpD=(double)rowsCount/pageSize;

int tmpI=(int)tmpD;

if(tmpD>tmpI) tmpI++;

return tmpI;

}

public int getPageRowsCount() {

if(pageSize==0) return rowsCount;

if(getRowsCount()==0) return 0;

if(curPage!=getPageCount()) return pageSize;

return rowsCount-(getPageCount()-1)*pageSize;

}

public int getPageSize() {

return pageSize;

}

public int getRowsCount() {

return rowsCount;

}

public void gotoPage(int page) {

if (rs == null)

return;

if (page < 1)

page = 1;

if (page > getPageCount())

page = getPageCount();

int row = (page - 1) * pageSize + 1;

try {

rs.absolute(row);

curPage = page;

}

catch (java.sql.SQLException e) {

}

}

public void pageFirst() throws SQLException {

int row=(curPage-1)*pageSize+1;

rs.absolute(row);

}

public void pageLast() throws SQLException {

int row=(curPage-1)*pageSize+getPageRowsCount();

rs.absolute(row);

}

public void setPageSize(int pageSize) {

if(pageSize>=0){

this.pageSize=pageSize;

curPage=1;

}

}

public boolean next() throws SQLException {

return rs.next();

}

public boolean absolute(int row) throws SQLException {

return rs.absolute(row);

}

public void afterLast() throws SQLException {

rs.afterLast();

}

public void beforeFirst() throws SQLException {

rs.beforeFirst();

}

public void cancelRowUpdates() throws SQLException {

rs.cancelRowUpdates();

}

public void clearWarnings() throws SQLException {

rs.clearWarnings();

}

public void close() throws SQLException {

rs.close();

}

public void deleteRow() throws SQLException {

rs.deleteRow();

}

public int findColumn(String columnName) throws SQLException {

return rs.findColumn(columnName);

}

public boolean first() throws SQLException {

return rs.first();

}

public Array getArray(int i) throws SQLException {