board.java

又是一个虚拟社区

package com.laoer.bbscs.board;

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

/**
 * 该类用于取得一级版区的各项属性
 * Title:        BBS-CS
 * Description:  BBS-CS(BBS式虚拟社区系统)
 * Copyright:    Copyright (c) 2002
 * Company:      loveroom.com.cn
 * @author 龚天乙（laoer）
 * @version 3.0
 */

public class Board {

  String SQL = "";
  DbTrans DBSQL;
  ResultSet rs = null;
  DoText myDoText;
  private String strBID = "";
  private String strBoardName = "";
  private String strEBoardName = "";
  private String strBMaster = "";
  private int numAttrib = 1;
  private String strXu = "";

  /**
   * 构造函数
   */
  public Board() {
      this.DBSQL = new DbTrans();
      this.myDoText = new DoText();
  }

  /**
   * 取得版区各项属性
   * @param bid 版区ID号
   */
  public void getBoard(String bid) {
      SQL = "select * from board where ID="+ bid;
      try {
          rs = DBSQL.executeQuery(SQL);
          if (rs.next()) {
              this.strBID = rs.getString("ID");
              this.strBoardName = rs.getString("boardname");
              this.strEBoardName = rs.getString("eboardname");
              this.strBMaster = rs.getString("bmaster");
              this.numAttrib = rs.getInt("attrib");
              this.strXu = rs.getString("xu");
          }
          rs.close();
      }
      catch (SQLException e){
      }
  }

  /**
   * 取得版区ID
   * @return String型版区ID
   */
  public String getBID() {
      return this.strBID;
  }

  /**
   * 取得中文版区名
   * @return String型版区名
   */
  public String getBoardName() {
      return this.strBoardName;
  }

  /**
   * 取得英文版区名
   * @return String型英文版区名
   */
  public String getEBoardName() {
      return this.strEBoardName;
  }

  /**
   * 取得版区管理员名
   * @return String型版区管理员
   */
  public String getBMaster() {
      return this.strBMaster;
  }

  /**
   * 取得版区属性
   * @return String型版区属性
   */
  public int getAttrib() {
      return this.numAttrib;
  }

  /**
   * 取得序
   * @return String序
   */
  public String getXu() {
      return this.strXu;
  }

  /**
   * 判断版区名是否重复
   * @param bid 版区ID
   * @param strBoardName 中文版区名
   * @param strEBoardName 英文版区名
   * @return 布尔逻辑值 如果重复返回真，否则返回假
   */
  public boolean isHaveBoarName(String bid, String strBoardName, String strEBoardName) {
      boolean isHaveBoardName = false;
      int numIsHaveBoardName = 0;
      SQL = "select count(*) as numIsHaveBoardName from board where (boardname='"+ strBoardName +"' or eboardname='" + strEBoardName +"') and ID <> "+ bid +"";
      try {
          rs = DBSQL.executeQuery(SQL);
          if (rs.next()) {
              numIsHaveBoardName = rs.getInt("numIsHaveBoardName");
          }
          rs.close();
      }
      catch (SQLException e){
      }
      if (numIsHaveBoardName != 0) {
          isHaveBoardName = true;
      }
      else {
          isHaveBoardName = false;
      }
      return isHaveBoardName;
  }

  /**
   * 修改一级版区属性
   * @param bid 版区ID
   * @param strBoardName 中文版区名称
   * @param strEBoardName 英文版区名
   * @param strBMaster 管理员
   * @param strAttrib 属性
   * @param strXu 序
   * @return 布尔逻辑值 修改成功返回真，否则返回假
   */
  public boolean setUpdateBoard(String bid, String strBoardName, String strEBoardName, String strBMaster, String strAttrib, String strXu) {
      boolean isCanUpdate = false;
      SQL = "update board set boardname='"+ strBoardName +"',eboardname='"+ strEBoardName +"',bmaster='"+ strBMaster +"',attrib='"+ strAttrib +"',xu='"+ strXu +"' where ID="+ bid;
      try {
          DBSQL.executeUpdate(SQL);
          isCanUpdate = true;
      }
      catch (SQLException e){
          isCanUpdate = false;
      }
      return isCanUpdate;
  }

  public String getListBoardConf(String strUserName,String tablecolor) {
      String strListBoardConf = "";
      SQL = "select * from board where bmaster=\""+ strUserName +"\"";
      try {
          rs = DBSQL.executeQuery(SQL);
          while (rs.next()) {
              strListBoardConf += "<tr bgcolor="+tablecolor+">\n";
              strListBoardConf += "<td><CENTER>"+rs.getInt("ID")+"</CENTER></td>\n";
              strListBoardConf += "<td><CENTER><a href='boardsconf.jsp?boid="+rs.getInt("ID")+"'>"+myDoText.iso2gb(rs.getString("boardname"))+"("+myDoText.iso2gb(rs.getString("eboardname"))+")</a></CENTER></td>\n";
              strListBoardConf += "</tr>\n";
          }
          rs.close();
      }
      catch (SQLException e){
      }
      return strListBoardConf;
  }

  public boolean isBoardMaster(String boid,String strUserName) {
      int numMaster = 0;
      SQL = "select count(*) as numMaster from board where bmaster = '"+strUserName+"' and ID = "+boid;
      try {
          rs = DBSQL.executeQuery(SQL);
          if (rs.next()) {
              numMaster = rs.getInt("numMaster");
          }
          rs.close();
      }
      catch (SQLException e){
      }
      if (numMaster!=0) {
          return true;
      }
      else {
          return false;
      }
  }

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

}