package com.laoer.bbscs.board;import java.sql.*;import java.io.*;import java.util.*;import com.laoer.bbscs.db.*;import com.laoer.bbscs.txthtml.*;import com.laoer.bbscs.user.User;/** * <p>Title: BBS-CS</p> * <p>Description: BBS-CS(BBS式虛擬社區(qū)系統(tǒng))</p> * <p>Copyright: Copyright (c) 2002</p> * <p>Company: loveroom.com.cn</p> * @author 龔天乙（laoer） * @version 3.0 */public class Boards {  String SQL = "";  DbTrans DBSQL;  ResultSet rs = null;  DoText myDoText;  private String strBoardID = "";  private String strBoardsName = "";  private String strEBoardsName = "";  private String strBsMaster = "";  private String strBsMaster1 = "";  private String strBsMaster2 = "";  private String strBoardgg = "";  private int numAttrib = 1;  private int numUseState = 1;  private int numXu = 1;  private int numArtCount = 0;  public Boards() {      this.DBSQL = new DbTrans();      this.myDoText = new DoText();  }  public Boards(String bsid) {      this.DBSQL = new DbTrans();      this.myDoText = new DoText();      getBoards(bsid);  }  /**   * 取得版面各項屬性   * @param bsid 一級版區(qū)ID   */  public void getBoards(String bsid) {      SQL = "select * from boards where ID = "+bsid;      try {          rs = DBSQL.executeQuery(SQL);          if (rs.next()) {              this.strBoardID = rs.getString("boardID");              this.strBoardsName = rs.getString("boardsname");              this.strEBoardsName = rs.getString("eboardsname");              this.strBsMaster = rs.getString("bsmaster");              this.strBsMaster1 = rs.getString("bsmaster1");              this.strBsMaster2 = rs.getString("bsmaster2");              this.strBoardgg = rs.getString("boardgg");              this.numAttrib = rs.getInt("attrib");              this.numUseState = rs.getInt("usestate");              this.numXu = rs.getInt("xu");              this.numArtCount = rs.getInt("artcount");          }          rs.close();      }      catch (SQLException e){      }  }  public String getBoardID() {      return this.strBoardID;  }  public String getBoardsName() {      return this.strBoardsName;  }  public String getEBoardName() {      return this.strEBoardsName;  }  public String getBsMaster() {      return this.strBsMaster;  }  public String getBsMaster1() {      return this.strBsMaster1;  }  public String getBsMaster2() {      return this.strBsMaster2;  }  public String getBoardgg() {      return this.strBoardgg;  }  public int getAttrib() {      return this.numAttrib;  }  public int getUseState() {      return this.numUseState;  }  public int getBoardsXu() {      return this.numXu;  }  public int getArtCount() {      return this.numArtCount;  }  /**   * 取得版面自動序號   * @param bid 一級版區(qū)ID   * @return int型版面自動序號   */  public int getAutoBoardsXu(String bid) {      int numAutoBoardsXu = 1;      SQL = "select max(xu)+5 as numAutoBoardsXu from boards where boardID = "+bid;      try {          rs = DBSQL.executeQuery(SQL);          if (rs.next()) {              numAutoBoardsXu = rs.getInt("numAutoBoardsXu");          }          rs.close();          if (numAutoBoardsXu == 0) {              numAutoBoardsXu = 5;          }      }      catch (SQLException e){      }      return numAutoBoardsXu;  }  /**   * 驗證版副   * @param BsMaster1 版副字串   * @return 布爾邏輯值 如果都是注冊用戶返回真，否則返回假   */  public boolean checkBsMaster1(String BsMaster1) {      StringTokenizer masterok = new StringTokenizer(BsMaster1,",");      User myUser = new User();       while(masterok.hasMoreTokens()) {           if (!myUser.isUser(masterok.nextToken())) {               return false;           }       }       return true;  }  /**   * 判斷版面名是否重復(fù)   * @param strBoardsName 中文版面名   * @param strEBoardsName 英文版面名   * @return 布爾邏輯值 已存在返回真，否則返回假   */  public boolean isHaveBoards(String strBoardsName, String strEBoardsName) {      boolean isHaveBoards = false;      int numIsHaveBoards = 0;      SQL = "select count(*) as numIsHaveBoards from boards where boardsname='"+ strBoardsName +"' or eboardsname='" + strEBoardsName +"'";      try {          rs = DBSQL.executeQuery(SQL);          if (rs.next()) {              numIsHaveBoards = rs.getInt("numIsHaveBoards");          }          rs.close();      }      catch (SQLException e){      }      if (numIsHaveBoards != 0) {          isHaveBoards = true;      }      else {          isHaveBoards = false;      }      return isHaveBoards;  }  public boolean isBoards(String bsid) {      int numIsBoards = 0;      SQL = "select count(*) as numIsBoards from boards where ID = "+bsid;      try {          rs = DBSQL.executeQuery(SQL);          if (rs.next()) {              numIsBoards = rs.getInt("numIsBoards");          }          rs.close();      }      catch (SQLException e){      }      if (numIsBoards == 1) {          return true;      }      else {          return false;      }  }  public boolean isHaveBoards(String strBoardsName, String strEBoardsName,String bsid) {      boolean isHaveBoards = false;      int numIsHaveBoards = 0;      SQL = "select count(*) as numIsHaveBoards from boards where (boardsname='"+ strBoardsName +"' or eboardsname='" + strEBoardsName +"') and ID <>"+bsid;      try {          rs = DBSQL.executeQuery(SQL);          if (rs.next()) {              numIsHaveBoards = rs.getInt("numIsHaveBoards");          }          rs.close();      }      catch (SQLException e){      }      if (numIsHaveBoards != 0) {          isHaveBoards = true;      }      else {          isHaveBoards = false;      }      return isHaveBoards;  }  /**   * 增加版面   * @param bid 一級版區(qū)ID   * @param strBoardsName 中文版面名   * @param strEBoardsName 英文版面名   * @param strBsMaster 斑竹   * @param strBsMaster1 版副   * @param strBsMaster2 隱身版竹   * @param strBoardsgg 版面公告   * @param strAttrib 版區(qū)屬性   * @param strUseState 版面狀態(tài)   * @param strXu 序   * @return 布爾邏輯值 添加成功返回真，否則返回假   */  public boolean addBoards(String bid, String strBoardsName, String strEBoardsName, String strBsMaster, String strBsMaster1, String strBsMaster2, String strBoardsgg, String strAttrib, String strUseState, String strXu) {      boolean isCanAdd = false;      SQL = "insert into boards (boardID,boardsname,eboardsname,bsmaster,bsmaster1,bsmaster2,boardgg,attrib,usestate,xu) values ('"+ bid +"','"+ strBoardsName +"','"+ strEBoardsName +"','"+ strBsMaster +"','"+ strBsMaster1 +"','"+ strBsMaster2 +"','"+ strBoardsgg +"','"+ strAttrib +"','"+ strUseState +"','"+ strXu +"')";      try {          DBSQL.executeQuery(SQL);          isCanAdd = true;      }      catch (SQLException e){          isCanAdd = false;      }      return isCanAdd;  }