seppage.java

图书管理系统,B/S,C/S都有,附有源代码

package database;

import java.sql.*;
import java.sql.ResultSet;

//import   javax.servlet.http.HttpServletResponse;
//import   javax.servlet.http.*;
//import   java.io.*;

/**
 * <p>Title: library</p>
 * <p>Description: library</p>
 * <p>Copyright: Copyright (c) 2007</p>
 * <p>Company: </p>
 * @author nino
 * @version 0.1
 */

public class sepPage {
  protected ResultSet rs = null;
  protected int rowsCount;
  protected int pageSize = 5;
  protected int curPage;
  protected int row; //起始行
  protected String command = "";

  //传出rs
  public ResultSet getRS() throws SQLException, java.io.IOException,
      java.lang.NullPointerException {
    if (rs != null) {
      return rs;
    }
    else {
      return rs = null;
    }
  }

  public void setRS(ResultSet newRS) throws java.sql.SQLException,
      java.io.IOException { //取得传来记录集
    newRS.last();
    rowsCount = newRS.getRow();
    newRS.beforeFirst();
    this.rs = newRS;
    newRS = null;
  }

  public int getPageCount() { //返回总页数
    if (rowsCount == 0) {
      return 0;
    }
    if (pageSize == 0) {
      return 1;
    }
    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 getRow() { //返回起始行
    return row;
  }

  public void gotoPage(int page) { //转到指定页
    if (rs == null) {
      return;
    }
    if (page < 1) {
      page = 1;
    }
    if (page > getPageCount()) {
      page = getPageCount();
    }
    row = (page - 1) * pageSize + 1;
    curPage = page;
  }

  public void setPageSize(int pageSize) { //设置分页大小
    if (pageSize >= 0) {
      this.pageSize = pageSize;
      curPage = 1;
    }
  }

  public int getRowsCount() { //返回总记录行数
    return rowsCount;
  }

  public int getCurPage() { //返回当前页号
    return curPage;
  }

}