????????package?DAL;

????????import?java.util.*;
????????
????????import?DBUtil.SQLUtil;
????????
????????public?class?Car?{

		//獲取車輛表信息列表
		public?Listject>?getEntity（）
		{
			String?sqlCmd=“select?*from?Car“;
			return?DBUtil.SQLUtil.executeQuery（sqlCmd?null）;//執(zhí)行查詢操作executeQuery
		}
????????????
???????????????//獲取分頁后車輛表信息列表
		public?Listject>?getEntity（int?page）
		{
			int?size=（page-1）*15;
			String?sqlCmd=“select?*from?Car?limit?“+size+“15“;
			return?DBUtil.SQLUtil.executeQuery（sqlCmd?null）;//執(zhí)行查詢操作executeQuery
		}
????????????????
????????//根據(jù)查詢條件sqlWhere獲取分頁后車輛表信息列表
		public?Listject>?getEntityByWhere（String?sqlWhereint?page）
		{
			int?size=（page-1）*15;
			String?sqlCmd=“select?*from?Car?where?“+sqlWhere+“?limit?“+?size+“15“;
			return?DBUtil.SQLUtil.executeQuery（sqlCmd?null）;//執(zhí)行查詢操作executeQuery
????????}
		
		//獲取問分配的車輛
		public?Listject>?getNoUseCar（）
		{
			String?sqlCmd=“SELECT?CarIdCarType?FROM?Car??WHERE?CarId?NOT?IN（SELECT?CarId?FROM?Driving）“;
			return?DBUtil.SQLUtil.executeQuery（sqlCmd?null）;//執(zhí)行查詢操作executeQuery
????????}

????????//刪除車輛表信息
????????public?int?deleteEntity（String?CarId）
????????{
????????????String?sqlCmd=“delete?from?Car?where?CarId=‘“+CarId+“‘“;
????????????return?DBUtil.SQLUtil.executeNonQuery（sqlCmd?null）;//執(zhí)行非查詢操作executeNonQuery
????????}
????????
????????//根據(jù)車輛表編號(hào)獲取車輛表信息
????????public?Listject>?getEntityById（String?CarId）
????????{
????????????String?sqlCmd=“select?*From?Car?where?CarId=‘“+CarId+“‘“;
????????????return?DBUtil.SQLUtil.executeQuery（sqlCmd?null）;//執(zhí)行查詢操作executeQuery
????????}
????????
????????//更新車輛表信息
????????public?int?updateEntity（String?CarIdString?CarTypeString?CarOperNumString?CarNumString?CarColorString?CarEndTime）
????????{
????????????String?sqlCmd=“Update?Car?set?CarType=‘“?+?CarType?+?“‘CarOperNum=‘“?+?CarOperNum?+?“‘CarNum=‘“?+?CarNum?+?“‘CarColor=‘“?+?CarColor?+?“‘CarEndTime=‘“?+?CarEndTime?+?“‘?where?CarId=‘“+CarId+“‘“;
????????????return?SQLUtil.executeNonQuery（sqlCmd?null）;
????????}
????????
????????//插入車輛表信息
????????public?int?insertEntity（String?CarIdString?CarTypeString?CarOperNumString?CarNumString?CarColorString?CarEndTime）
????????{
????????????String?sqlCmd=“Insert?into?Car?values（‘“?+?CarId?+?“‘‘“?+?CarType?+?“‘‘“?+?CarOperNum?+?“‘‘“?+?CarNum?+?“‘‘“?+?CarColor?+?“‘‘“+CarEndTime+“‘）“;
????????????return?SQLUtil.executeNonQuery（sqlCmd?null）;
????????}
????????
????????//檢查插入主鍵是否重復(fù)
????????public?boolean?checkExist（String?CarId）
????????{
????????????String?sqlCmd=“select?count（*）?from?Car?where?CarId=‘“+CarId+“‘“;
????????????if（1==Integer.parseInt（SQLUtil.excuteScalar（sqlCmd?null）.toString（））?）
????????????{
????????????????return?true;
????????????}
????????????return?false;
????????}
????????
????????//檢查插入主鍵是否重復(fù)
????????public?boolean?checkCarNumExist（String?CarNum）
????????{
????????????String?sqlCmd=“select?count（*）?from?Car?where?Car

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2015-12-08?17:49??Taxi\
?????文件????????1093??2015-04-02?10:08??Taxi\.classpath
?????文件????????1329??2015-04-02?10:15??Taxi\.project
?????目錄???????????0??2015-12-08?17:49??Taxi\.settings\
?????文件?????????522??2015-04-02?10:08??Taxi\.settings\.jsdtscope
?????文件?????????364??2015-04-02?10:08??Taxi\.settings\org.eclipse.jdt.core.prefs
?????文件?????????473??2015-04-02?10:08??Taxi\.settings\org.eclipse.wst.common.component
?????文件?????????414??2015-04-02?10:08??Taxi\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2015-04-02?10:08??Taxi\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2015-04-02?10:08??Taxi\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2015-12-08?17:49??Taxi\WebRoot\
?????目錄???????????0??2015-12-08?17:49??Taxi\WebRoot\Admin\
?????文件????????1432??2015-12-08?16:08??Taxi\WebRoot\Admin\CarAdd.jsp
?????文件????????2183??2015-12-08?16:08??Taxi\WebRoot\Admin\CarEdit.jsp
?????文件????????4118??2015-12-08?16:08??Taxi\WebRoot\Admin\CarMsg.jsp
?????文件????????1947??2015-12-08?16:08??Taxi\WebRoot\Admin\DrivingAdd.jsp
?????文件????????3116??2015-12-08?16:08??Taxi\WebRoot\Admin\DrivingEdit.jsp
?????文件????????4048??2015-12-08?16:09??Taxi\WebRoot\Admin\DrivingMsg.jsp
?????文件????????1899??2015-12-08?16:09??Taxi\WebRoot\Admin\EmployeeAdd.jsp
?????文件????????3041??2015-12-08?16:09??Taxi\WebRoot\Admin\EmployeeEdit.jsp
?????文件????????4302??2015-12-08?16:09??Taxi\WebRoot\Admin\EmployeeMsg.jsp
?????文件????????1339??2015-12-08?16:09??Taxi\WebRoot\Admin\NoticeAdd.jsp
?????文件????????3668??2015-12-08?16:09??Taxi\WebRoot\Admin\NoticeCenter.jsp
?????文件????????2124??2015-12-08?16:10??Taxi\WebRoot\Admin\NoticeEdit.jsp
?????文件????????3904??2015-12-08?16:10??Taxi\WebRoot\Admin\NoticeMsg.jsp
?????文件????????2136??2015-12-08?16:10??Taxi\WebRoot\Admin\RepairAdd.jsp
?????文件????????2271??2015-12-08?16:10??Taxi\WebRoot\Admin\RepairEdit.jsp
?????文件????????4113??2015-12-08?16:10??Taxi\WebRoot\Admin\RepairMsg.jsp
?????文件????????3826??2015-12-08?16:10??Taxi\WebRoot\Admin\RepairSearch.jsp
?????文件????????1072??2015-12-08?16:08??Taxi\WebRoot\Admin\RoleAdd.jsp
?????文件????????1756??2015-12-08?16:10??Taxi\WebRoot\Admin\RoleEdit.jsp
............此處省略93個(gè)文件信息