package?com.yzq.ms.DAO;
import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;

import?com.yzq.ms.javabeans.Admin;
/**
?*?描述:?數據庫表admin連接類
?*?@Copyright?（c）?2010?Zu?Qing
?*?@author?祖清
?*?@version?1.0
?*/
public?class?AdminDAO?{

	/**
	?*?驗證是否是管理員名
	?*/
	public?boolean?isAdminName（String?adminname）
	{
		boolean?flag=false;
		Connection?con=null;
		PreparedStatement?pst=null;
		ResultSet?rs=null;
		try{	
			String?sql=“select?*?from?admin?where?adminname?=??“;
			con=ConnectionTool.getConnection（）;
			pst=con.prepareStatement（sql）;
			pst.setString（1adminname）;
			rs=pst.executeQuery（）;
			if（rs.next（））
			{
				flag=true;
System.out.println（rs.getString（“adminname“））;
				
			}
		}catch?（Exception?e）?{
			e.printStackTrace（）;
			}?finally?{
				//?關閉連接，釋放數據庫資源：
				ConnectionTool.closeRs（rs）;
				ConnectionTool.closePst（pst）;
				ConnectionTool.closeCon（con）;
			}
		return?flag;
	}
	/**
	?*?驗證是否是管理員密碼
	?*/
	public?boolean?isAdminPwd（String?adminnameString?adminpwd）
	{
		boolean?flag=false;
		Connection?con=null;
		PreparedStatement?pst=null;
		ResultSet?rs=null;
		try{	
			String?sql=“select?*?from?admin?where?adminname?=???and?password?=??“;
			con=ConnectionTool.getConnection（）;
			pst=con.prepareStatement（sql）;
			pst.setString（1adminname）;
			pst.setString（2adminpwd）;
			rs=pst.executeQuery（）;
			if（rs.next（））
			{
				flag=true;
System.out.println（rs.getString（“adminpwd“））;
			}
		}catch?（Exception?e）?{
			e.printStackTrace（）;
			}?finally?{
				//?關閉連接，釋放數據庫資源：
				ConnectionTool.closeRs（rs）;
				ConnectionTool.closePst（pst）;
				ConnectionTool.closeCon（con）;
			}
		return?flag;
	}
	
//	public?static?void?main（String[]?args）?{
//		//?進行調試，測試一下以上數據庫類是否寫成功
//		boolean?flag?=AdminDAO.isAdmin（new?Admin（“祖清““123456“））;
//		System.out.println（flag）;
//	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????1499??2010-05-24?17:08??MobileShop\.project

?????文件????????685??2010-05-24?17:03??MobileShop\.classpath

?????文件????????303??2010-05-24?16:56??MobileShop\.mymetadata

?????文件????????260??2010-05-24?16:56??MobileShop\.mystrutsdata

?????文件???????1932??2010-05-28?16:21??MobileShop\WebRoot\WEB-INF\.struts-config.mex

?????文件???????8860??2010-05-24?16:56??MobileShop\WebRoot\WEB-INF\struts-bean.tld

?????文件???????1404??2010-05-28?16:21??MobileShop\WebRoot\WEB-INF\struts-config.xml

?????文件??????73617??2010-05-27?14:12??MobileShop\WebRoot\WEB-INF\struts-html.tld

?????文件??????14731??2010-05-24?16:56??MobileShop\WebRoot\WEB-INF\struts-logic.tld

?????文件??????71483??2010-05-24?16:56??MobileShop\WebRoot\WEB-INF\struts-nested.tld

?????文件???????7842??2010-05-24?16:56??MobileShop\WebRoot\WEB-INF\struts-tiles.tld

?????文件??????13781??2010-05-24?16:56??MobileShop\WebRoot\WEB-INF\validator-rules.xml

?????文件??????17390??2010-05-28?16:31??MobileShop\WebRoot\WEB-INF\web.xml

?????文件??????21195??2010-05-24?16:56??MobileShop\WebRoot\WEB-INF\lib\jstl.jar

?????文件?????394583??2010-05-24?16:56??MobileShop\WebRoot\WEB-INF\lib\standard.jar

?????文件?????456729??2010-05-19?13:13??MobileShop\WebRoot\WEB-INF\lib\mysql-connector-java-3.1.13-bin.jar

?????文件???????1947??2010-05-28?18:27??MobileShop\WebRoot\WEB-INF\classes\filters\SetCharacterEncodingFilter.class

?????文件??????10922??2010-05-28?18:27??MobileShop\WebRoot\WEB-INF\classes\com\yzq\ms\DAO\UserDAO.class

?????文件???????4766??2010-05-28?18:27??MobileShop\WebRoot\WEB-INF\classes\com\yzq\ms\DAO\OrderItemDAO.class

?????文件???????8120??2010-05-28?18:27??MobileShop\WebRoot\WEB-INF\classes\com\yzq\ms\DAO\OrderDAO.class

?????文件??????17261??2010-05-28?18:27??MobileShop\WebRoot\WEB-INF\classes\com\yzq\ms\DAO\MobileDAO.class

?????文件???????5761??2010-05-28?18:27??MobileShop\WebRoot\WEB-INF\classes\com\yzq\ms\DAO\MessageBoardDAO.class

?????文件???????1800??2010-05-28?18:27??MobileShop\WebRoot\WEB-INF\classes\com\yzq\ms\DAO\ConnectionTool.class

?????文件???????2216??2010-05-28?18:27??MobileShop\WebRoot\WEB-INF\classes\com\yzq\ms\DAO\AdminDAO.class

?????文件???????1631??2010-05-28?18:27??MobileShop\WebRoot\WEB-INF\classes\com\yzq\ms\javabeans\VoteCount.class

?????文件???????3406??2010-05-28?18:27??MobileShop\WebRoot\WEB-INF\classes\com\yzq\ms\javabeans\User.class

?????文件???????1793??2010-05-28?18:27??MobileShop\WebRoot\WEB-INF\classes\com\yzq\ms\javabeans\OrderItem.class

?????文件???????2694??2010-05-28?18:27??MobileShop\WebRoot\WEB-INF\classes\com\yzq\ms\javabeans\Order.class

?????文件???????4025??2010-05-28?18:27??MobileShop\WebRoot\WEB-INF\classes\com\yzq\ms\javabeans\Mobile.class

?????文件???????1435??2010-05-28?18:27??MobileShop\WebRoot\WEB-INF\classes\com\yzq\ms\javabeans\MessageBoard.class

............此處省略521個文件信息