pages.java

天乙代码src_531.rar 天乙代码src_531.rar 天乙代码src_531.rar 天乙代码src_531.rar

package com.laoer.bbscs.db;

import java.sql.*;

/**
 * <p>Title: 天乙社区V5.0</p>
 * <p>Description: BBS-CS天乙社区V5.0</p>
 * <p>Copyright: Copyright (c) 2003</p>
 * <p>Company: laoer.com</p>
 * @author 龚天乙
 * @version 5.0
 */

public abstract class Pages {

  String filename = ""; //Jsp文件名
  int pages = 1; //页号
  int totals = 0; //记录总数
  int perpagenum = 20; //每页显示记录数
  int style = 0; //分页字串样式
  int allpage = 1; //总页数
  int cpage = 1; //当前页
  int spage = 1; //开始记录数
  String sSQL = "";
  String listPageBreak = "";
  String[] pagesign = {
      "", "", "", ""};

  public Pages() {
  }

  public String getFileName() {
    return this.filename;
  }

  public void setFileName(String aFileName) {
    this.filename = aFileName;
  }

  public int getPages() {
    return this.pages;
  }

  public void setPages(int aPages) {
    this.pages = aPages;
  }

  public int getTotals() {
    return this.totals;
  }

  public void setTotals(int aTotals) {
    this.totals = aTotals;
  }

  public int getPerPageNum() {
    return this.perpagenum;
  }

  public void setPerPageNum(int aperpagenum) {
    this.perpagenum = aperpagenum;
  }

  public int getStyle() {
    return this.style;
  }

  public void setStyle(int aStyle) {
    this.style = aStyle;
  }

  public void setSQL(String SQL) {
    this.sSQL = SQL;
  }

  public void setPagesign(String[] apagesign) {
    this.pagesign = apagesign;
  }

  public void doPageBreak() {
    this.allpage = (int) Math.ceil( (this.totals + this.perpagenum - 1) /
                                   this.perpagenum);
    int intPage = this.pages;
    if (intPage > this.allpage) { // pages == 0
      this.cpage = 1;
    }
    else {
      this.cpage = intPage;
    }
    this.spage = (this.cpage - 1) * this.perpagenum;
    getPageBreakStr();
  }

  public String getListPageBreak() {
    return this.listPageBreak;
  }

  public void getPageBreakStr() {
    if (this.style == 0) {
      if (this.cpage > 1) {
        this.listPageBreak += "[<a href='" + this.filename + "pages=" +
            (cpage - 1) +
            "'><font color=#FF0000>" +
            pagesign[1] + "</font></a>]";
      }
      if (this.cpage < this.allpage) {
        this.listPageBreak += "[<a href='" + this.filename + "pages=" +
            (cpage + 1) +
            "' ><font color=#FF0000>" +
            pagesign[2] + "</font></a>]";
      }
    }
    if (this.style == 1) {
      if (this.cpage > 1) {
        this.listPageBreak +=
            "<img src=images/prepage.gif  align=absmiddle><font color=#FF0000>[<a href='" +
            this.filename + "pages=" +
            (cpage - 1) + "'><font color=#FF0000>" +
            pagesign[1] + "</font></a>]</font>";
      }
      if (this.cpage < this.allpage) {
        this.listPageBreak +=
            "<img src=images/nextpage.gif  align=absmiddle><font color=#FF0000>[<a href='" +
            this.filename + "pages=" +
            (cpage + 1) + "'><font color=#FF0000>" +
            pagesign[2] + "</font></a>]</font>";
      }
    }
    if (this.style == 2) {
      if (this.cpage > 1) {
        this.listPageBreak +=
            "[<a href='" + this.filename +
            "inpages=1' target='mainFrame'><font color=#FF0000>" +
            pagesign[0] +
            "</font></a>] [<a href='" + this.filename + "inpages=" + (cpage - 1) +
            "' target='mainFrame'><font color=#FF0000>" +
            pagesign[1] + "</font></a>]";
      }
      if (this.cpage < this.allpage) {
        this.listPageBreak += "[<a href='" + this.filename + "inpages=" +
            (cpage + 1) +
            "' target='mainFrame'><font color=#FF0000>" +
            pagesign[2] +
            "</font></a>] [<a href='" + this.filename + "inpages=" +
            this.allpage +
            "' target='mainFrame'><font color=#FF0000>" +
            pagesign[3] + "</font></a>]";
      }
    }
  }

  public abstract String getSQLString(String pk);

  public abstract ResultSet getRs(TranContext DBSQL, String pk);
}