?? adminmain.java
字號:
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){ } }}?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -