package?com.shuangyulin.dao;

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

import?com.shuangyulin.Utils.DB;
import?com.shuangyulin.javabean.Admin;??

/*關于管理員信息操作的業務處理類*/
public?class?AdminDAO?{

	/*?驗證管理員身份登陸?*/
	public?static?boolean?checkLogin（Admin?admin）?{
		DB?db?=?new?DB（）;
		boolean?flag?=?false;
		String?sql?=?“select?*?from?admin?where?adminUsername=‘“
				+?admin.getAdminUsername（）?+?“‘?and?adminPassword=‘“
				+?admin.getAdminPassword（）?+?“‘“;
		try?{
			ResultSet?rs?=?db.executeQuery（sql）;
			if?（rs.next（））
				flag?=?true;
			else
				flag?=?false;
			db.all_close（）;
		}?catch?（Exception?e）?{
			flag?=?false;
			e.printStackTrace（）;
		}?
		return?flag;
	}
	
	/*更改用戶密碼*/
	public?static?boolean?ChangePassword（Admin?admin）?{
		try?{
			DB?db?=?new?DB（）;
			String?sql?=?“update?admin?set?adminPassword=‘“?+?admin.getAdminPassword（）?+?“‘?where?adminUsername=‘“?+?admin.getAdminUsername（）?+?“‘“;
			int?result?=?db.executeUpdate（sql）;
			db.all_close（）;
			if（?result?>?0）
				return?true;
		}?catch?（Exception?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		return?false;
	}
	
	/*得到某個用戶的權限*/
	public?static?int?getIsRoot（String?adminUsername）?{?
		String?sql?=?“select?isRoot?from?admin?where?adminUsername=‘“?+?adminUsername?+?“‘“;
		DB?db?=?new?DB（）;
		ResultSet?rs;
		int?isRoot?=?0;
		try?{
			rs?=?db.executeQuery（sql）;
			if?（rs.next（））?{
				isRoot?=?rs.getInt（“isRoot“）;
			}
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
		}?finally?{
			db.all_close（）;
		}
		return?isRoot;
	}
	
	/*得到所有的用戶信息*/
	public?static?ArrayList?QueryAllAdminInfo（）?{
		String?sqlString?=?“select?*?from?admin“;
		ArrayList?adminList?=?new?ArrayList（）;
		DB?db?=?new?DB（）;
		ResultSet?rs;?
		try?{
			rs?=?db.executeQuery（sqlString）;
			while?（rs.next（））?{
				Admin?admin?=?new?Admin（）;
				admin.setAdminUsername（rs.getString（“adminUsername“））;
				admin.setAdminPassword（rs.getString（“adminPassword“））;
				admin.setIsRoot（rs.getInt（“isRoot“））;
				adminList.add（admin）;
			}
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
		}?finally?{
			db.all_close（）;
		}?
		
		return?adminList;
	}
	
	/*根據記錄編號刪除某個黨員信息*/
	public?static?int?DelAdminInfo（String?adminUsername）?{
		int?result?=?0;
		String?sqlString?=?“delete?from?admin?where?adminUsername=‘“?+?adminUsername?+?“‘“;
		DB?db?=?new?DB（）;
		try?{
			result?=?db.executeUpdate（sqlString）;
			db.all_close（）;
		}?catch?（Exception?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		return?result;
		
	}
	
	/*添加管理員信息*/
	public?static?boolean?AddAdminInfo（Admin?admin）?{
		
		String?sqlString?=?“insert?into?admin?（adminUsernameadminPasswordisRoot）?values?（‘“;
		sqlString?+=?admin.getAdminUsername（）?+?“‘‘“;
		sqlString?+=?admin.getAdminPassword（）?+?“‘“;
		sqlString?+=?admin.getIsRoot（）?+?“）“;?
		?
		int?effectCount?=?0;
		DB?db?=?new?DB（）;
		try?{
			Sy

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2015-07-01?12:57??DYIMS\
?????文件?????????597??2010-01-10?21:17??DYIMS\.classpath
?????目錄???????????0??2015-07-01?12:57??DYIMS\.myeclipse\
?????文件?????????288??2010-01-09?14:29??DYIMS\.mymetadata
?????文件????????1223??2010-01-09?14:29??DYIMS\.project
?????目錄???????????0??2010-03-02?10:02??DYIMS\WebRoot\
?????文件????????2555??2010-01-16?11:54??DYIMS\WebRoot\ChangePassword.jsp
?????文件????????3800??2010-01-17?12:22??DYIMS\WebRoot\DyxxbAdd.jsp
?????文件????????4148??2010-01-18?22:37??DYIMS\WebRoot\DyxxbQuery.jsp
?????文件????????5159??2010-01-17?19:14??DYIMS\WebRoot\DyxxbUpdate.jsp
?????目錄???????????0??2010-03-02?10:02??DYIMS\WebRoot\meta-INF\
?????文件??????????39??2010-01-09?14:29??DYIMS\WebRoot\meta-INF\MANIFEST.MF
?????文件????????1168??2010-01-16?10:31??DYIMS\WebRoot\UserAdd.jsp
?????文件?????????869??2010-01-16?10:14??DYIMS\WebRoot\UserDel.jsp
?????文件????????3056??2010-01-18?22:38??DYIMS\WebRoot\UserManage.jsp
?????目錄???????????0??2010-03-02?10:02??DYIMS\WebRoot\WEB-INF\
?????目錄???????????0??2010-03-02?10:02??DYIMS\WebRoot\WEB-INF\classes\
?????目錄???????????0??2010-03-02?10:02??DYIMS\WebRoot\WEB-INF\classes\com\
?????目錄???????????0??2010-03-02?10:02??DYIMS\WebRoot\WEB-INF\classes\com\shuangyulin\
?????目錄???????????0??2010-03-02?10:02??DYIMS\WebRoot\WEB-INF\classes\com\shuangyulin\Utils\
?????文件????????1091??2010-02-28?20:49??DYIMS\WebRoot\WEB-INF\classes\com\shuangyulin\Utils\ConnectionPool$PooledConnection.class
?????文件????????6398??2010-02-28?20:49??DYIMS\WebRoot\WEB-INF\classes\com\shuangyulin\Utils\ConnectionPool.class
?????文件????????2801??2010-02-28?20:49??DYIMS\WebRoot\WEB-INF\classes\com\shuangyulin\Utils\ConnectionPoolTest.class
?????文件????????1052??2010-02-28?20:49??DYIMS\WebRoot\WEB-INF\classes\com\shuangyulin\Utils\ConnectionPoolUtils.class
?????文件????????3415??2010-02-28?20:49??DYIMS\WebRoot\WEB-INF\classes\com\shuangyulin\Utils\DB.class
?????文件????????3896??2010-02-28?20:49??DYIMS\WebRoot\WEB-INF\classes\com\shuangyulin\Utils\RandImgCreater.class
?????文件????????1975??2010-02-28?20:49??DYIMS\WebRoot\WEB-INF\classes\com\shuangyulin\Utils\SetCharacterEncodingFilter.class
?????目錄???????????0??2010-03-02?10:02??DYIMS\WebRoot\WEB-INF\classes\com\shuangyulin\dao\
?????文件????????3748??2010-03-02?08:07??DYIMS\WebRoot\WEB-INF\classes\com\shuangyulin\dao\AdminDAO.class
?????文件????????8034??2010-02-28?20:49??DYIMS\WebRoot\WEB-INF\classes\com\shuangyulin\dao\DyxxbDAO.class
?????目錄???????????0??2010-03-02?10:02??DYIMS\WebRoot\WEB-INF\classes\com\shuangyulin\javabean\
............此處省略102個文件信息