seppage.java~1~

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

package database;

import java.sql.*;

/**
 * <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;
  protected int curPage;
  protected String command = "";

  //传出rs
  public ResultSet getRS() throws SQLException, java.io.IOException,
      java.lang.NullPointerException {
    try {
      return this.rs;
    }
    catch (Exception e) {
      System.out.println("fenyebean里getrs出错" + e.toString() + e.getMessage());
      return this.rs = null;
    }
  }

  public void setRS(ResultSet newRS) throws java.sql.SQLException,
      java.io.IOException { //由QueryBean传来RS
    try {
      newRS.last();
      rowsCount = newRS.getRow();
      newRS.beforeFirst();
      this.rs = newRS;
      newRS = null;
    }
    catch (Exception e) {
      System.out.println("fenyebean里setrs出错" + e.toString() + e.getMessage());

    }
    finally {
      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 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) {
      System.out.println("转到指定页时出现错误" + e.toString());
    }

  }

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

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

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

}