package com.laoer.bbscs.user;import java.sql.*;import java.io.*;import java.util.*;import com.laoer.bbscs.db.*;import com.laoer.bbscs.txthtml.*;import com.laoer.bbscs.board.Boards;/** * <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 BoardsMaster {  String SQL = "";  DbTrans DBSQL;  //DoText myDoText;  ResultSet rs = null;  //private boolean boardmaster = false;  //private boolean boardsmaster = false;  //private boolean boardsmaster1 = false;  //private boolean boardsmaster2 = false;  public BoardsMaster() {      this.DBSQL = new DbTrans();      //this.myDoText = new DoText();  }  public boolean getBoardMaster(String strUserName, String bid) {      Boards myBoards = new Boards();      myBoards.getBoards(bid);      String strBoardID = myBoards.getBoardID();      int numBoardMaster = 0;      SQL = "select count(*) as numBoardMaster from board where bmaster = '"+ strUserName +"' and ID = "+strBoardID;      try {          rs = DBSQL.executeQuery(SQL);          if (rs.next()) {              numBoardMaster = rs.getInt("numBoardMaster");          }          rs.close();      }      catch (SQLException e){      }      if (numBoardMaster == 0) {          return false;      }      else {          return true;      }  }  public boolean getBoardsMaster(String strUserName,String bid) {      int numBoardsMaster = 0;      SQL = "select count(*) as numBoardsMaster from boards where bsmaster = '"+ strUserName +"' and ID = "+bid;      try {          rs = DBSQL.executeQuery(SQL);          if (rs.next()) {              numBoardsMaster = rs.getInt("numBoardsMaster");          }          rs.close();      }      catch (SQLException e){      }      if (numBoardsMaster == 0) {          return false;      }      else {          return true;      }  }  public boolean getBoardsMaster1(String strUserName,String bid) {      String strBoardsMaster1 = "";      SQL = "select bsmaster1 from boards where ID = "+bid;      try {         rs = DBSQL.executeQuery(SQL);         if (rs.next()) {             strBoardsMaster1 = rs.getString("bsmaster1");         }         rs.close();      }      catch (SQLException e){      }      StringTokenizer masterok = new StringTokenizer(strBoardsMaster1,",");      while(masterok.hasMoreTokens()) {          if (masterok.nextToken().equals(strUserName)) {              return true;          }      }      return false;  }  public boolean getBoardsMaster2(String strUserName,String bid) {      int numBoardsMaster2 = 0;      SQL = "select count(*) as numBoardsMaster2 from boards where bsmaster2 = '"+ strUserName +"' and ID = "+bid;      try {          rs = DBSQL.executeQuery(SQL);          if (rs.next()) {              numBoardsMaster2 = rs.getInt("numBoardsMaster2");          }          rs.close();      }      catch (SQLException e){      }      if (numBoardsMaster2 == 0) {          return false;      }      else {          return true;      }  }  public void close() {      try {          DBSQL.close();      }      catch (SQLException e) {      }  }}