package?com.access;

import?java.sql.Connection;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;


import?com.model.adminInfo;
import?com.util.MyDButil;



public?class?adminDao?{

	Connection?conn;
	Statement?st;
	ResultSet?rs;
	
	public?boolean?isAdmin（adminInfo?admin）{
		boolean?isFlag?=?false;
		MyDButil?mydbutil?=?new?MyDButil（）;
		Connection?conn?=?mydbutil.getConn（）;
		try?{
			st=conn.createStatement（）;
			String?strSql?=“select?*?from?admin?where?loginName?=‘“+admin.getLoginName（）+“‘and?passWord=‘“+admin.getPassWord（）+“‘“;
			System.out.println（strSql）;
			rs=st.executeQuery（strSql）;
			while（rs.next（））{
			isFlag?=?true;
			}
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block???????????
			e.printStackTrace（）;
		}finally
		{
			return?isFlag;
		}
	}	
	
	public?boolean?AddAdmin（adminInfo?admin）//注冊新用戶??userRegister.jsp
	{
		boolean?isFlag?=?false;
		
		MyDButil?mydbutil?=?new?MyDButil（）;
		Connection?conn?=?mydbutil.getConn（）;
		try?{
			?st?=?conn.createStatement（）;
			String?strSQL?=?“insert?into?admin（adminIdloginNamepassWord）values?（‘“+admin.getAdminId（）+“‘‘“+admin.getLoginName（）+“‘‘“+admin.getPassWord（）+“‘）“;
			System.out.println（strSQL）;
			st.executeUpdate（strSQL）;
			isFlag?=?true;
	
			
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}finally
		{
			return?isFlag;
		}

	}
	public?String?getAdminbyName（String?AName）{
	
			MyDButil?mydbutil?=?new?MyDButil（）;
			conn=mydbutil.getConn（）;
			int?adminId?=0;
			String?aIdStr=““;
			try?{
				st?=conn.createStatement（）;
				String?strSql=“select?adminId?from?admin?where?loginName=‘“+AName+“‘“;
				System.out.println（strSql）;
				rs=st.executeQuery（strSql）;
				while（rs.next（））{
				adminId=rs.getInt（“adminId“）;
				}
				aIdStr?=?adminId+““;
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
			}finally{
			return?aIdStr;
			}
	
	
	}
}

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

?????文件????????863??2014-01-13?17:38??car\.classpath

?????文件????????282??2014-01-16?08:58??car\.mymetadata

?????文件???????1409??2014-01-14?12:12??car\.project

?????文件????????500??2014-01-13?17:36??car\.settings\.jsdtscope

?????文件????????330??2014-01-13?17:36??car\.settings\org.eclipse.jdt.core.prefs

?????文件?????????49??2014-01-13?17:36??car\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2014-01-13?17:36??car\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????4723??2014-01-15?17:56??car\car.sql

?????文件???????2066??2014-01-15?11:29??car\src\com\access\adminDao.java

?????文件??????10017??2014-01-15?20:31??car\src\com\access\CarDao.java

?????文件???????2127??2014-01-15?13:22??car\src\com\access\gwcDao.java

?????文件???????5382??2014-01-17?13:51??car\src\com\access\memberDao.java

?????文件???????3391??2014-01-17?15:20??car\src\com\access\neibieDao.java

?????文件???????5074??2014-01-17?13:51??car\src\com\access\orderDao.java

?????文件???????2443??2014-01-16?09:06??car\src\com\access\pinjiaDao.java

?????文件????????533??2014-01-15?11:27??car\src\com\model\adminInfo.java

?????文件???????1351??2014-01-15?14:52??car\src\com\model\carInfo.java

?????文件????????658??2014-01-14?09:57??car\src\com\model\gwcInfo.java

?????文件????????843??2014-01-14?10:00??car\src\com\model\gwcselectInfo.java

?????文件???????1388??2014-01-17?13:51??car\src\com\model\MemberInfo.java

?????文件????????356??2014-01-17?14:40??car\src\com\model\NeibieInfo.java

?????文件????????890??2014-01-14?16:56??car\src\com\model\orderInfo.java

?????文件????????898??2014-01-16?09:03??car\src\com\model\pinjiaInfo.java

?????文件???????2777??2014-01-15?11:46??car\src\com\servlet\adminLoginServlet.java

?????文件???????2613??2014-01-16?09:49??car\src\com\servlet\AmemberUpdateServlet.java

?????文件???????3541??2014-01-17?12:07??car\src\com\servlet\carAdd.java

?????文件???????2526??2014-01-15?16:01??car\src\com\servlet\carAServlet.java

?????文件???????2284??2014-01-17?10:00??car\src\com\servlet\carServlet.java

?????文件???????2965??2014-01-17?12:02??car\src\com\servlet\carUpdateServlet.java

?????文件???????2522??2014-01-17?16:00??car\src\com\servlet\delCar.java

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