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){      }  }}