boardsmaster.java

BBS虚拟社区

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