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

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件????????8924??2018-05-11?11:25??dy.sql
?????目錄???????????0??2018-03-16?11:41??DYIMS\
?????文件?????????708??2018-03-15?11:28??DYIMS\.classpath
?????目錄???????????0??2018-03-15?11:29??DYIMS\.myeclipse\
?????文件?????????288??2010-01-09?14:29??DYIMS\.mymetadata
?????文件????????1223??2010-01-09?14:29??DYIMS\.project
?????目錄???????????0??2018-03-15?11:29??DYIMS\src\
?????目錄???????????0??2018-03-15?11:29??DYIMS\src\com\
?????目錄???????????0??2018-03-15?11:29??DYIMS\src\com\shuangyulin\
?????目錄???????????0??2018-03-15?11:29??DYIMS\src\com\shuangyulin\dao\
?????文件????????3287??2018-03-15?12:53??DYIMS\src\com\shuangyulin\dao\AdminDAO.java
?????文件????????7850??2010-01-15?11:27??DYIMS\src\com\shuangyulin\dao\DyxxbDAO.java
?????目錄???????????0??2018-03-15?11:29??DYIMS\src\com\shuangyulin\javabean\
?????文件?????????879??2010-01-10?12:42??DYIMS\src\com\shuangyulin\javabean\Admin.java
?????文件????????3589??2010-01-13?13:57??DYIMS\src\com\shuangyulin\javabean\Dyxxb.java
?????目錄???????????0??2018-03-15?11:29??DYIMS\src\com\shuangyulin\servlet\
?????文件????????2409??2010-01-09?14:32??DYIMS\src\com\shuangyulin\servlet\CheckLoginServlet.java
?????文件????????9332??2010-01-18?22:40??DYIMS\src\com\shuangyulin\servlet\DyxxbManageServlet.java
?????文件????????3745??2010-01-17?12:21??DYIMS\src\com\shuangyulin\servlet\FileUploadServlet.java
?????目錄???????????0??2018-03-15?11:29??DYIMS\src\com\shuangyulin\Utils\
?????文件???????13646??2018-03-15?12:16??DYIMS\src\com\shuangyulin\Utils\ConnectionPool.java
?????文件????????2661??2010-01-09?14:29??DYIMS\src\com\shuangyulin\Utils\ConnectionPoolTest.java
?????文件?????????873??2018-03-15?12:15??DYIMS\src\com\shuangyulin\Utils\ConnectionPoolUtils.java
?????文件????????3844??2018-03-15?12:13??DYIMS\src\com\shuangyulin\Utils\DB.java
?????文件????????3549??2010-01-09?14:29??DYIMS\src\com\shuangyulin\Utils\RandImgCreater.java
?????文件????????5120??2010-01-09?14:29??DYIMS\src\com\shuangyulin\Utils\SetCharacterEncodingFilter.java
?????目錄???????????0??2018-03-15?11:29??DYIMS\WebRoot\
?????文件????????2591??2018-03-15?13:14??DYIMS\WebRoot\about.html
?????文件???????23864??2010-01-08?19:20??DYIMS\WebRoot\calendar.js
?????文件?????????715??2010-01-09?14:29??DYIMS\WebRoot\center.html
?????文件????????2555??2010-01-16?11:54??DYIMS\WebRoot\ChangePassword.jsp
............此處省略101個文件信息