pagebreak.java

BBS-CS是采用JSP+JavaBean+Servlet开发的一套网络虚拟社区系统. 运行平台： Liunx + JDK + Apache + Tomcat + MYSQL 或 Window

package com.laoer.bbscs.db;

import java.sql.*;
import java.io.*;
import java.util.*;
import com.laoer.bbscs.txthtml.*;

/**
 * <p>Title: BBS-CS</p>
 * <p>Description: BBS-CS(BBS式虚拟社区系统)</p>
 * <p>Copyright: Copyright (c) 2002</p>
 * <p>Company: loveroom.com.cn</p>
 * @author 龚天乙（laoer）
 * @version 3.0
 */

public class PageBreak {

  String SQL = "";
  DbTrans DBSQL;
  DoText myDoText;
  ResultSet rs = null;

  int i;
  int allCol = 0;//总纪录数
  int ipage = 0; //分页单位
  int allpage = 1; //总页数
  //int pages = 1; //接受的页码变量
  int cpage = 1; //当前页
  int spage = 1; //开始页

  public PageBreak() {
      this.DBSQL = new DbTrans();
      this.myDoText = new DoText();
  }

  public ResultSet getPageBreak(String pages, String strCountSQL, String strSQL, int intPageSize) {
      try {
          rs = DBSQL.executeQuery(strCountSQL);
          if (rs.next()) {
              this.allCol = rs.getInt("total");
          }
          rs.close();
      }
      catch (SQLException e){
      }
      //if (this.allCol != 0) {
      this.ipage = intPageSize;
      this.allpage = (int)Math.ceil((this.allCol + this.ipage-1) / this.ipage);
      int intPage = Integer.parseInt(pages);
      if(intPage > this.allpage){ // pages == 0
          this.cpage = 1;
      }
      else {
          this.cpage = intPage;
      }
      this.spage = (this.cpage-1)*this.ipage;
      ResultSet rsPageBreak = null;
      strSQL = strSQL + " limit "+ this.spage +","+ this.ipage;
      try {
          rsPageBreak = DBSQL.executeQuery(strSQL);
      }
      catch (SQLException e){
      }
      return rsPageBreak;
      //}
      //else {
      //    return null;
      //}
  }

  public int getSpage() {
      return this.spage;
  }

  public int getAllCol() {
      return this.allCol;
  }

  public String listPageBreak(String fileName) {
      String listPageBreak = "";
      int pages = 0;
      if (this.cpage>1) {
          pages = this.cpage - 1;
          listPageBreak += "[<a href='"+ fileName +"pages="+ pages +"'><font color=#FF0000>上一页</font></a>]";
      }
      if (this.cpage<this.allpage) {
          pages = this.cpage + 1;
          listPageBreak += "[<a href='"+ fileName +"pages="+ pages +"'><font color=#FF0000>下一页</font></a>]";
      }
      return listPageBreak;
  }

  public String listPageBreakPic(String fileName) {
      String listPageBreak = "";
      int pages = 0;
      if (this.cpage>1) {
          pages = this.cpage - 1;
          listPageBreak += "<img src=images/prepage.gif  align=absmiddle><font color=#FF0000>[<a href='"+ fileName +"pages="+ pages +"'><font color=#FF0000>上一页</font></a>]</font>";
      }
      if (this.cpage<this.allpage) {
          pages = this.cpage + 1;
          listPageBreak += " <img src=images/nextpage.gif  align=absmiddle><font color=#FF0000>[<a href='"+ fileName +"pages="+ pages +"'><font color=#FF0000>下一页</font></a>]</font>";
      }
      return listPageBreak;
  }

  public void close() {
      try {
          DBSQL.close();
      }
      catch (SQLException e){
      }
  }
}