package?com.chinasofti.dao;

import?java.sql.Connection;

import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;
import?java.util.ArrayList;
import?java.util.Date;
import?java.util.List;
import?com.chinasofti.util.JDBCUtil;
import?com.chinasofti.pojo.AdminBean;
//import??com.chinasofti.bean.Admin;

public?class?AdminDao?{
	
????private?static?final?AdminDao?adminDAO=new?AdminDao（）;
	private?JDBCUtil?carDB?=?JDBCUtil.getInstance（）;

	private?AdminDao（）?{

	}

	public??static?final?AdminDao?getInstance（）?{
		return?adminDAO;
	}
	public?void?insertAdmin（AdminBean?admin）?{
		Connection?conn?=?carDB.getConnection（）;
		String?sql?=?“insert?into?admin（adminNameadminPwdadminSexadminCertNumadminTel）values（?????）“;

		try?{
			PreparedStatement?statement?=?conn.prepareStatement（sql）;
			
			statement.setString（1admin.getAdminName（））;
			
			statement.setString（2?admin.getAdminPwd（））;
			
			statement.setString（3?admin.getAdminSex（））;
			
			statement.setString（4?admin.getAdminCertNum（））;
			
			statement.setString（5?admin.getAdminTel（））;
			//執(zhí)行上面的sql語句。
			statement.executeUpdate（）;
			
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
			System.out.println（“新增管理員失敗“）;
		}

	}
	
	public?void?deleteAdmin（int?adminId）?{
		Connection?conn?=?carDB.getConnection（）;
		String?sql?=?“delete?from?admin?where?adminId=?“;

		try?{
			PreparedStatement?statement?=?conn.prepareStatement（sql）;
			
			statement.setInt（1adminId）;
			//執(zhí)行上面的sql語句。
			statement.executeUpdate（）;
			
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
			System.out.println（“刪除管理員失敗“）;
		}

	}
	public?void?modifyAdmin（AdminBean?adminint?adminId）?{
		Connection?conn?=?carDB.getConnection（）;
		String?sql?=?“update?admin?set?adminName=?adminPwd=?adminSex=?adminCertNum=?adminTel=??where?adminId=?“;

		try?{
			PreparedStatement?statement?=?conn.prepareStatement（sql）;
			
			statement.setString（1admin.getAdminName（））;
			
			statement.setString（2?admin.getAdminPwd（））;
			
			statement.setString（3?admin.getAdminSex（））;
			
			statement.setString（4?admin.getAdminCertNum（））;
			
			statement.setString（5?admin.getAdminTel（））;
			statement.setInt（6?adminId）;
			//執(zhí)行上面的sql語句。
			statement.executeUpdate（）;
			
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
			System.out.println（“修改管理員失敗“）;
		}

	}
	

	public?List?queryAdmin（）

	{
		List?adminList?=?new?ArrayList（）;
		
		Connection?conn?=?carDB.getConnection（）;
		
		String?querySql?=?“select?*?from?admin?order?by?adminId?desc“;

		try?{
			
			Statement?st?=?conn.createStatement（）;
			//執(zhí)行查詢語句
			ResultSet?rs?=?st.executeQuery（querySql）;
			
			AdminBean?admin?=?null;
			
			while?（rs.next（））?{
				admin?=?new?AdminBean（）;			
				admin.setAdminId（rs.getInt（“adminId“））;
				admin.setAdminName（rs.getString（“admi

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

?????文件????????514??2011-08-03?15:04??RentManageEND\.classpath

?????文件????????313??2011-08-03?15:04??RentManageEND\.mymetadata

?????文件???????1416??2011-08-03?15:04??RentManageEND\.project

?????文件????????500??2011-08-03?15:04??RentManageEND\.settings\.jsdtscope

?????文件???????1040??2011-08-03?15:04??RentManageEND\.settings\com.genuitec.eclipse.j2eedt.core.prefs

?????文件????????330??2011-08-03?15:04??RentManageEND\.settings\org.eclipse.jdt.core.prefs

?????文件?????????49??2011-08-03?15:04??RentManageEND\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2011-08-03?15:04??RentManageEND\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件??????11644??2011-08-03?15:02??RentManageEND\carmanagedb.sql

?????文件???????3704??2011-08-03?15:04??RentManageEND\src\com\chinasofti\dao\AdminDao.java

?????文件???????6208??2011-08-03?15:04??RentManageEND\src\com\chinasofti\dao\CarDao.java

?????文件???????2602??2011-08-03?15:04??RentManageEND\src\com\chinasofti\dao\ChangeDao.java

?????文件???????9788??2011-08-03?15:04??RentManageEND\src\com\chinasofti\dao\DriverDao.java

?????文件???????5686??2011-08-03?15:04??RentManageEND\src\com\chinasofti\dao\LoginDao.java

?????文件???????4462??2011-08-03?15:04??RentManageEND\src\com\chinasofti\dao\RegisterDao.java

?????文件??????11284??2011-08-03?15:04??RentManageEND\src\com\chinasofti\dao\RentCarDao.java

?????文件??????14330??2011-08-03?15:04??RentManageEND\src\com\chinasofti\dao\RentDao.java

?????文件???????4053??2011-08-03?15:04??RentManageEND\src\com\chinasofti\dao\ReturnDao.java

?????文件???????7148??2011-08-03?15:04??RentManageEND\src\com\chinasofti\dao\UserDao.java

?????文件???????4774??2011-08-03?15:04??RentManageEND\src\com\chinasofti\dao\XContactDao.java

?????文件???????1051??2011-08-03?15:04??RentManageEND\src\com\chinasofti\pojo\AdminBean.java

?????文件???????1557??2011-08-03?15:04??RentManageEND\src\com\chinasofti\pojo\Car.java

?????文件???????1667??2011-08-03?15:04??RentManageEND\src\com\chinasofti\pojo\CarBean.java

?????文件???????1914??2011-08-03?15:04??RentManageEND\src\com\chinasofti\pojo\ChangeBean_Lin.java

?????文件???????1544??2011-08-03?15:04??RentManageEND\src\com\chinasofti\pojo\ContactBean.java

?????文件???????1380??2011-08-03?15:04??RentManageEND\src\com\chinasofti\pojo\DriverBean.java

?????文件???????1133??2011-08-03?15:04??RentManageEND\src\com\chinasofti\pojo\ErrorBean_Lin.java

?????文件???????1183??2011-08-03?15:04??RentManageEND\src\com\chinasofti\pojo\LoginBean.java

?????文件???????1836??2011-08-03?15:04??RentManageEND\src\com\chinasofti\pojo\OrderBean.java

?????文件???????1054??2011-08-03?15:04??RentManageEND\src\com\chinasofti\pojo\RegisterBean.java

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