//管理員管理類
package?db;

import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.util.ArrayList;
import?java.util.Hashtable;

import?db.SqlManger;

public?class?adminUser?{
	//表名
	private?static?final?String?adminTableName?=?“admin“;

	int?roleid;					//用戶身份
	String?username;			//用戶名
	String?password;			//密碼
	String?sex?=?““;			//性別
	String?email?=?““;			//電子郵件
	String?company?=?““;		//公司
	String?ip?=?““;				//注冊IP	
	boolean?logon;				//是否登錄
	
	final?static?int?REGISITER?=?0;
	final?static?int?GUEST?=?1;
	final?static?int?USER?=?2;
	final?static?int?ADMIN?=?3;
	final?static?int?SUPERADMIN?=?4;
	
	public?adminUser（）{
		this.password?=?“unknown“;
		this.username?=?“unknown“;
		this.roleid?=?ADMIN;
		this.logon?=?false;
	}
	
	//添加管理員
	public??boolean?registerAdmin（String?username?String?password?int?role）{
		if（role?>?roleid）?return?false;
		
		SqlManger?DBm?=?SqlManger.createInstance（）;
		DBm.connectDB（）;
		
		String?sql?=?“insert?into?“
			+?adminTableName
			+?“（username??password??role）?“
			+?“values?（‘“?+?username?+?“‘??‘“?+?basicUser.getMD5Str（password）?+“‘??“?+?role?+?“）“;
		
		System.out.println（sql）;
		int?ret?=?DBm.executeUpdate（sql）;
		DBm.closeDB（）;
		if（ret?>?0）?return?true;
		return?false;
	}
	//獲得管理員數(shù)量
	public?int?getAdminnum（）{
		int?num?=?0;
		
		SqlManger?DBm?=?SqlManger.createInstance（）;
		DBm.connectDB（）;
		String?sql?=?“SELECT?COUNT（*）?AS?num?FROM?admin“;
		System.out.println（sql）;
		try?{
			ResultSet?rs?=?DBm.executeQuery（sql）;
			while（rs.next（））
				num?=?rs.getInt（“num“）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			System.out.println（e.getErrorCode（））;
			System.out.println（e.getMessage（））;
			e.printStackTrace（）;
		}
		DBm.closeDB（）;
		return?num;
	}
	//內(nèi)容管理
	
	//判斷是否是管理員
	public?boolean?isAdmin（）{
		if（this.roleid?>=?ADMIN）{
			return?true;
		}
		return?false;
	}
	//判斷是否是內(nèi)容管理者
	public?boolean?isSuperAdmin（）{
		if（this.roleid?==?SUPERADMIN）{
			return?true;
		}
		return?false;
	}
	//獲得權(quán)限管理者列表
	public?static?String?getAdminList（）{
		SqlManger?DBm?=?SqlManger.createInstance（）;
		DBm.connectDB（）;
		String?sql?=?“select?*?from?admin?where?role?=?3“;
		String?strlist?=?““;
		int?i?=?0;
		AuthManger?auth?=?AuthManger.createInstance（）;
		Hashtable?admins?=?auth.getOnlineAdmins（）;
		try{
			ResultSet?rs?=?DBm.executeQuery（sql）;
			while（rs.next（））{
				strlist?+=?“\n“
				+?“權(quán)限管理者\n“
				+?““?+?rs.getString（“username“）?+?“\n“;
				if（AuthManger.isAdminLogin（admins?rs.getString（“username“）））{
					strlist?+=?“在線\n“;
					String?ipp?=?admins.get（rs.getString（“username“））.getIp（）;
					strlist?+=?““?+?ipp?+?“\n“;
				}
				else?strlist?+=?“離線\n\n“;?
				i++;
			}
			strlist?+=?““;
			strlist?+=?“\n“;
			strlist?+=?“Total“?+?i?+?“\n“;
			st

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件????????442??2009-08-27?17:35??Km_System\.classpath

?????文件????????300??2010-03-06?09:18??Km_System\.mymetadata

?????文件???????1415??2009-08-27?17:26??Km_System\.project

?????文件????????588??2009-09-07?16:00??Km_System\.jazz5\.descriptors.dat

?????文件??????????0??2009-09-07?19:53??Km_System\.jazz5\.jazzlock

?????文件??????????0??2009-09-07?16:00??Km_System\.jazz5\.flags\.descriptors.isComplete

?????文件??????????0??2009-09-07?16:00??Km_System\.jazz5\.flags\.inverseItemInfos.isComplete

?????文件??????????0??2009-09-07?16:00??Km_System\.jazz5\.flags\.loadedComponents.isComplete

?????文件??????????0??2009-09-07?16:00??Km_System\.jazz5\.flags\.metadata.isComplete

?????文件??????????0??2009-09-07?16:00??Km_System\.jazz5\.flags\.persistentmetadata.isComplete

?????文件????????500??2009-08-27?17:24??Km_System\.settings\.jsdtscope

?????文件????????330??2009-08-27?17:24??Km_System\.settings\org.eclipse.jdt.core.prefs

?????文件?????????49??2009-08-27?17:24??Km_System\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2009-08-27?17:24??Km_System\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????8662??2009-09-03?04:13??Km_System\src\db\adminUser.java

?????文件???????2147??2009-09-02?16:54??Km_System\src\db\AuthManger.java

?????文件???????8662??2009-09-01?20:14??Km_System\src\db\basicUser.java

?????文件???????4800??2009-09-24?00:58??Km_System\src\db\DoList.java

?????文件???????3484??2009-09-04?21:50??Km_System\src\db\Graphic.java

?????文件??????12085??2009-09-17?16:57??Km_System\src\db\knowledge.java

?????文件???????3921??2009-09-17?16:08??Km_System\src\db\SqlManger.java

?????文件???????6053??2009-09-23?15:25??Km_System\src\db\UploadBean.java

?????文件???????1693??2009-09-09?00:20??Km_System\src\knowledgeBody\KElement.java

?????文件??????99231??2009-08-12?12:47??Km_System\src\org\jgraph\JGraph.java

?????文件?????????88??2009-08-12?12:47??Km_System\src\org\jgraph\package.html

?????文件???????3926??2009-08-12?12:47??Km_System\src\org\jgraph\event\GraphLayoutCacheEvent.java

?????文件????????702??2009-08-12?12:47??Km_System\src\org\jgraph\event\GraphLayoutCacheListener.java

?????文件???????3406??2009-08-12?12:47??Km_System\src\org\jgraph\event\GraphModelEvent.java

?????文件????????862??2009-08-12?12:47??Km_System\src\org\jgraph\event\GraphModelListener.java

?????文件???????3989??2009-08-12?12:47??Km_System\src\org\jgraph\event\GraphSelectionEvent.java

............此處省略688個(gè)文件信息