我在jsp中用的分页显示
//Source file: C://PageResultSet.java
package db;
import java.sql.*;
public class PageResultSet{
private ResultSet rst;
private ResultSetMetaData rsmd;
private int page;
private int pageCount;
private int rows;
private int pageRows=10;
private ViewQueryBean v ;
public PageResultSet()
{
try {
v = new ViewQueryBean();
}
catch (SQLException ex) {ex.printStackTrace();
}
}
public void deleteRow()throws SQLException{
rst.deleteRow();}
public void init()//
{
initPage();//ready rowcount,pagecount,currentpage
initRsmd();//ready resultsetmetadata;
}
public int getColumnCount(){
try {
return rsmd.getColumnCount();
}
catch (SQLException ex) {
return 0;
}
}
public String getColumnLabel(int index)
{
try {
return rsmd.getColumnLabel(index);
}
catch (SQLException ex) {
return "";
}
}
private void initPage(){
if(rows%pageRows==0)
{ pageCount=rows/pageRows;}
else
{ pageCount=rows/pageRows+1;
}
System.out.println("page"+pageCount);
}
private void initRsmd(){
try{rsmd=rst.getMetaData();
}
catch(SQLException s)
{}
}
public void executeQuery(String sql) throws SQLException{
this.setRst(v.executeQuery(sql));
this.rows = v.getRowCount();//
this.init();}
public void scrollToPage(int page){
int i;
i =(page -1) * this.pageRows +1;
try{ rst.absolute(i);
System.out.println("absolute="+i);
}
catch(SQLException s)
{System.out.println(s);}
}
public void scrollToRows(int i)
{
try{ rst.absolute(i);
System.out.println("absolute success");
}
catch(SQLException s)
{s.printStackTrace();}
}
public ResultSet getRst()
{
return rst;
}
public void setRst(ResultSet aRst)
{
rst = aRst;
}
public int getPage()
{
return page;
}
public void setPage(int page){
this.page=page;}
public int getRows()
{
return rows;
}
public void setRows(int row)
{
this.rows = row;}
public int getPageRows()
{
return pageRows;
}
public void setPageRows(int aPageRows)
{
pageRows = aPageRows;
}
public boolean next(){
try {
return rst.next();
}
catch (SQLException ex) {
return false;
}
}
public String getString(int index) {
try {
return rst.getString(index);
}
catch (SQLException ex) {
return null;
}
}
public String getString(String columnName){
try {
return rst.getString(columnName);
}
catch (SQLException ex) {
return null;
}}
public int getPageCount(){
return this.pageCount;}
public void close(){
if (this.rst!= null ) this.rst=null;
if (this.v!=null) this.v.close();
}
}
//Source file: C://PageResultSet.java
package db;
import java.sql.*;
public class PageResultSet{
private ResultSet rst;
private ResultSetMetaData rsmd;
private int page;
private int pageCount;
private int rows;
private int pageRows=10;
private ViewQueryBean v ;
public PageResultSet()
{
try {
v = new ViewQueryBean();
}
catch (SQLException ex) {ex.printStackTrace();
}
}
public void deleteRow()throws SQLException{
rst.deleteRow();}
public void init()//
{
initPage();//ready rowcount,pagecount,currentpage
initRsmd();//ready resultsetmetadata;
}
public int getColumnCount(){
try {
return rsmd.getColumnCount();
}
catch (SQLException ex) {
return 0;
}
}
public String getColumnLabel(int index)
{
try {
return rsmd.getColumnLabel(index);
}
catch (SQLException ex) {
return "";
}
}
private void initPage(){
if(rows%pageRows==0)
{ pageCount=rows/pageRows;}
else
{ pageCount=rows/pageRows+1;
}
System.out.println("page"+pageCount);
}
private void initRsmd(){
try{rsmd=rst.getMetaData();
}
catch(SQLException s)
{}
}
public void executeQuery(String sql) throws SQLException{
this.setRst(v.executeQuery(sql));
this.rows = v.getRowCount();//
this.init();}
public void scrollToPage(int page){
int i;
i =(page -1) * this.pageRows +1;
try{ rst.absolute(i);
System.out.println("absolute="+i);
}
catch(SQLException s)
{System.out.println(s);}
}
public void scrollToRows(int i)
{
try{ rst.absolute(i);
System.out.println("absolute success");
}
catch(SQLException s)
{s.printStackTrace();}
}
public ResultSet getRst()
{
return rst;
}
public void setRst(ResultSet aRst)
{
rst = aRst;
}
public int getPage()
{
return page;
}
public void setPage(int page){
this.page=page;}
public int getRows()
{
return rows;
}
public void setRows(int row)
{
this.rows = row;}
public int getPageRows()
{
return pageRows;
}
public void setPageRows(int aPageRows)
{
pageRows = aPageRows;
}
public boolean next(){
try {
return rst.next();
}
catch (SQLException ex) {
return false;
}
}
public String getString(int index) {
try {
return rst.getString(index);
}
catch (SQLException ex) {
return null;
}
}
public String getString(String columnName){
try {
return rst.getString(columnName);
}
catch (SQLException ex) {
return null;
}}
public int getPageCount(){
return this.pageCount;}
public void close(){
if (this.rst!= null ) this.rst=null;
if (this.v!=null) this.v.close();
}
}