adminmain.java

BBS虚拟社区

package com.laoer.bbscs.admin;

import java.sql.*;
import java.io.*;
import java.util.*;
import com.laoer.bbscs.db.*;
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 AdminMain {

  String SQL = "";
  DbTrans myDbTrans;
  DoText myDoText;
  ResultSet rs = null;

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

  /**
   * 取得管理员列表
   * @return String型管理员列表表格
   */
  public String listAdminUser() {
      String listAdminUser = "";
      SQL = "select * from adminuser";
      try {
          rs = myDbTrans.executeQuery(SQL);
          while (rs.next()) {
              listAdminUser = listAdminUser + "<form name=\"\" method=\"post\" action=\"modadmin.jsp\">\n";
              listAdminUser = listAdminUser + "<INPUT TYPE=\"hidden\" name=\"uid\" value="+ rs.getString("UID") +">\n";
              listAdminUser = listAdminUser + "<tr bgcolor=\"#ECECEC\">\n";
              listAdminUser = listAdminUser + "<td width=43>\n";
              listAdminUser = listAdminUser + "<div align=\"center\">"+ rs.getString("UID") +"</div>\n";
              listAdminUser = listAdminUser + "</td>\n";
              listAdminUser = listAdminUser + "<td width=\"93\">\n";
              listAdminUser = listAdminUser + "<div align=\"center\">"+ rs.getString("Uname") +"</div>\n";
              listAdminUser = listAdminUser + "</td>\n";
              listAdminUser = listAdminUser + "<td width=\"68\">\n";
              listAdminUser = listAdminUser + "<div align=\"center\">\n";
              listAdminUser = listAdminUser + "<input type=\"checkbox\" name=\"s_uper\" value=\"1\" ";
              if (rs.getInt("superadmin") == 1) {
                  listAdminUser = listAdminUser + "checked ";
              }
              else {
                  listAdminUser = listAdminUser + ">\n";
              }
              listAdminUser = listAdminUser + "</div>\n";
              listAdminUser = listAdminUser + "</td>\n";
              listAdminUser = listAdminUser + "<td width=\"68\">\n";
              listAdminUser = listAdminUser + "<div align=\"center\">\n";
              listAdminUser = listAdminUser + "<input type=\"checkbox\" name=\"board\" value=\"1\" ";
              if (rs.getInt("board") == 1) {
                  listAdminUser = listAdminUser + " checked ";
              }
              else {
                  listAdminUser = listAdminUser + ">\n";
              }
              listAdminUser = listAdminUser + "</div>\n";
              listAdminUser = listAdminUser + "</td>\n";
              listAdminUser = listAdminUser + "<td width=\"68\">\n";
              listAdminUser = listAdminUser + "<div align=\"center\">\n";
              listAdminUser = listAdminUser + "<input type=\"checkbox\" name=\"bulletin\" value=\"1\" ";
              if (rs.getInt("bulletin") == 1) {
                  listAdminUser = listAdminUser + " checked ";
              }
              else {
                  listAdminUser = listAdminUser + ">\n";
              }
              listAdminUser = listAdminUser + "</div>\n";
              listAdminUser = listAdminUser + "</td>\n";
              listAdminUser = listAdminUser + "<td width=\"68\">\n";
              listAdminUser = listAdminUser + "<div align=\"center\">\n";
              listAdminUser = listAdminUser + "<input type=\"checkbox\" name=\"uadmin\" value=\"1\" ";
              if (rs.getInt("useradmin") == 1) {
                  listAdminUser = listAdminUser + " checked ";
              }
              else {
                  listAdminUser = listAdminUser + ">\n";
              }
              listAdminUser = listAdminUser + "</div>\n";
              listAdminUser = listAdminUser + "</td>\n";
              listAdminUser = listAdminUser + "<td width=70>\n";
              listAdminUser = listAdminUser + "<div align=center>\n";
              listAdminUser = listAdminUser + "<input type=submit name=pub_chu value=修改>\n";
              listAdminUser = listAdminUser + "</div>\n";
              listAdminUser = listAdminUser + "</td>\n";
              listAdminUser = listAdminUser + "</tr>\n";
              listAdminUser = listAdminUser + "</form>\n";
          }
          rs.close();
      }
      catch (SQLException e){
      }
      return listAdminUser;
  }

  /**
   * 判断用户是否已经是管理员
   * @param adminName 管理员用户名
   * @return 布尔逻辑值 是返回真，否则返回假
   */
  public boolean isAdmin(String adminName) {
      boolean isAdmin = false;
      int numIsAdmin = 0;
      SQL = "select count(*) as numIsAdmin from adminuser where Uname='"+ adminName +"'";
      try {
          rs = myDbTrans.executeQuery(SQL);
          if (rs.next()) {
              numIsAdmin = rs.getInt("numIsAdmin");
          }
          rs.close();
      }
      catch (SQLException e){
      }
      if (numIsAdmin != 0) {
          isAdmin = true;
      }
      else {
          isAdmin = false;
      }
      return isAdmin;
  }

  /**
   * 添加管理员
   * @param ID 管理员ID
   * @param adminName 管理员用户名
   * @return 布尔逻辑值 添加成功返回真，否则返回假
   */
  public boolean insertAdmin(String ID,String adminName) {
      boolean insertAdmin = false;
      SQL = "insert into adminuser (UID,Uname) values ('"+ ID +"','"+ adminName +"')";
      try {
          myDbTrans.executeUpdate(SQL);
          insertAdmin = true;
      }
      catch (SQLException e){
          insertAdmin = false;
      }
      return insertAdmin;
  }

  /**
   * 修改管理员权限
   * @param strSuper 超级管理员标志
   * @param strBoard 版区管理标志
   * @param strBulletin 发布公告标志
   * @param strUadmin 用户管理标志
   * @param strUID 管理员ID
   * @return 布尔逻辑值 修改成功返回真，否则返回假
   */
  public boolean modAdmin(String strSuper, String strBoard, String strBulletin, String strUadmin, String strUID) {
      boolean modAdmin = false;
      SQL = "update adminuser set superadmin='"+ strSuper +"',board='"+ strBoard +"',bulletin='"+ strBulletin +"',useradmin ='"+ strUadmin +"' where UID='"+ strUID +"'";
      try {
          myDbTrans.executeQuery(SQL);
          modAdmin = true;
      }
      catch (SQLException e){
          modAdmin = false;
      }
      return modAdmin;
  }

  /**
   * 取得自动序号
   * @return int型自动序号
   */
  public int getAutoBoardXu() {
      int numAutoBoardXu = 1;
      SQL = "select max(xu)+5 as numAutoBoardXu from board";
      try {
          rs = myDbTrans.executeQuery(SQL);
          if (rs.next()) {
              numAutoBoardXu = rs.getInt("numAutoBoardXu");
          }
          rs.close();
          if (numAutoBoardXu == 0) {
              numAutoBoardXu = 5;
          }
      }
      catch (SQLException e){
      }
      return numAutoBoardXu;
  }

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

  /**
   * 判断用户是否具有版区或超级权限
   * @param strBMaster 斑竹用户名
   * @return 布尔逻辑值 有权限返回真，否则返回假
   */
  public boolean checkUserIsBoard(String strBMaster) {
      boolean userIsBoard = false;
      int numUserIsBoard = 0;
      SQL = "select count(*) as numUserIsBoard from adminuser where Uname='"+ strBMaster +"' and (superadmin=1 or board=1)";
      try {
          rs = myDbTrans.executeQuery(SQL);
          if (rs.next()) {
              numUserIsBoard = rs.getInt("numUserIsBoard");
          }
          rs.close();
      }
      catch (SQLException e){
      }
      if (numUserIsBoard != 0) {
          userIsBoard = true;
      }
      else {
          userIsBoard = false;
      }
      return userIsBoard;
  }

  /**
   * 增加一级版区
   * @param strBoardName 中文版区名称
   * @param strEBoardName 英文版区名
   * @param strBMaster 管理员
   * @param strAttrib 属性
   * @param strXu 序
   * @return 布尔逻辑值 添加成功返回真，否则返回假
   */
  public boolean addBoard(String strBoardName, String strEBoardName, String strBMaster, String strAttrib, String strXu) {
      boolean addBoard = false;
      SQL = "insert into board (boardname,eboardname,bmaster,attrib,xu) values ('"+ strBoardName +"','"+ strEBoardName +"','"+ strBMaster +"','"+ strAttrib +"','"+ strXu +"')";
      try {
          myDbTrans.executeUpdate(SQL);
          addBoard = true;
      }
      catch (SQLException e){
          addBoard = false;
      }
      return addBoard;
  }

  /**
   * 取得一级版区列表表格
   * @return String型一级版区列表表格
   */
  public String listBorad() {
      String listBorad = "";
      SQL = "select * from board order by xu";
      try {
          rs = myDbTrans.executeQuery(SQL);
          while (rs.next()) {
              listBorad += "<tr bgcolor=#ECECEC>\n";
              listBorad += "<td width=161><CENTER><a href=\"modboard.jsp?bid="+ rs.getString("ID") +"\">"+ myDoText.iso2gb(rs.getString("boardname")) +"("+ rs.getString("eboardname") +")</a></CENTER></td>\n";
              listBorad += "<td width=155><CENTER>"+ rs.getString("bmaster") +"</CENTER></td>\n";
              listBorad += "<td width=45><CENTER><a href='delboard.jsp?bid="+ rs.getString("ID") +"'>删除</CENTER></td>\n";
              listBorad += "</tr>\n";
          }
          rs.close();
      }
      catch (SQLException e){
      }
      return listBorad;
  }

  /**
   * 设定社区属性
   * @param pageStyle 页面风格属性
   * @param upImg 图像上传属性
   * @return 布尔逻辑值 修改成功返回真，否则返回假
   */
  public boolean setBBSConf(String pageStyle, String upImg, String website, String webURL) {
      boolean isConf = false;
      SQL = "update bbsconf set pagestyle = '"+ pageStyle +"',upimg = '"+ upImg +"',website = '"+website+"',webURL = '"+webURL+"' where ID = 1";
      try {
          myDbTrans.executeQuery(SQL);
          isConf = true;
      }
      catch (SQLException e){
          isConf = false;
      }
      return isConf;
  }

  /**
   * 取得页面风格属性
   * @return int型页面风格属性值
   */
  public int getConfStyle() {
      int confStyle = 1;
      SQL = "select pagestyle from bbsconf where ID = 1";
      try {
          rs = myDbTrans.executeQuery(SQL);
          if (rs.next()) {
              confStyle = rs.getInt("pagestyle");
          }
          rs.close();
      }
      catch (SQLException e){
      }
      return confStyle;
  }

  /**
   * 取得上传图片属性
   * @return int型图像上传属性
   */
  public int getConfUpImg() {
      int confUpImg = 2;
      SQL = "select upimg from bbsconf where ID = 1";
      try {
          rs = myDbTrans.executeQuery(SQL);
          if (rs.next()) {
              confUpImg = rs.getInt("upimg");
          }
          rs.close();
      }
      catch (SQLException e){
      }
      return confUpImg;
  }

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

}