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式虛擬社區(qū)系統(tǒng))</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;  /**   * 構(gòu)造函數(shù)   */  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;  }  /**   * 判斷用戶是否已經(jīng)是管理員   * @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;  }  /**   * 修改管理員權(quán)限   * @param strSuper 超級(jí)管理員標(biāo)志   * @param strBoard 版區(qū)管理標(biāo)志   * @param strBulletin 發(fā)布公告標(biāo)志   * @param strUadmin 用戶管理標(biāo)志   * @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;  }  /**   * 取得自動(dòng)序號(hào)   * @return int型自動(dòng)序號(hào)   */  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;  }  /**   * 判斷版區(qū)是否重復(fù)   * @param strBoardName 版區(qū)中文名   * @param strEBoardName 版區(qū)英文名   * @return 布爾邏輯值 重復(fù)返回真，否則返回假   */  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;  }  /**   * 判斷用戶是否具有版區(qū)或超級(jí)權(quán)限   * @param strBMaster 斑竹用戶名   * @return 布爾邏輯值 有權(quán)限返回真，否則返回假   */  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;  }  /**   * 增加一級(jí)版區(qū)   * @param strBoardName 中文版區(qū)名稱   * @param strEBoardName 英文版區(qū)名   * @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;  }  /**   * 取得一級(jí)版區(qū)列表表格   * @return String型一級(jí)版區(qū)列表表格   */  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;  }  /**   * 設(shè)定社區(qū)屬性   * @param pageStyle 頁面風(fēng)格屬性   * @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;  }  /**   * 取得頁面風(fēng)格屬性   * @return int型頁面風(fēng)格屬性值   */  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){      }  }}