package?com.logistic.business;

import?com.logistic.dao.ICarManagerDAO;
import?com.logistic.model.CarInfo;
import?java.util.Vector;
import?com.logistic.data.DataConnect;
import?java.sql.Statement;
import?java.sql.ResultSet;

public?class?CarManager?implements?ICarManagerDAO?{
	
	DataConnect?dc=new?DataConnect（）;
	Statement???stat=null;
	ResultSet???rs=null;
	
??public?int?AddCarManager（String?caridString?driveridString?teamid）{
		
		int?flag=-10;
	??try{
		??
		??String?cid=carid;
	?	??String?did=driverid;
	?	??String?tid=teamid;
		??String?strsql=“insert?into?carmanagetable（CarIdCarDriverIdCarTeamId）values（‘“+cid+“‘‘“+did+“‘‘“+tid+“‘）“;
		??flag=dc.updata（strsql）;
		??
		??if（flag>0）{
			??System.out.print（“車輛管理信息添加成功!“）;
		??}else{
			??System.out.print（“車輛管理信息添加失敗!“）;
		??}
		
	????}catch（Exception?ex）{ex.printStackTrace（）;}finally{dc.close（）;}
		?
		?return?flag;
	}
	
??public?Vector?CarSearch（String?strsqlint?page）{
????	
		Vector?items=new?Vector（）;
		try{
			
			stat=dc.getStmtread（）;
			rs=stat.executeQuery（strsql）;
			PageAble?pgb=new?PageAble（rs）;
			pgb.setPagesize（5）;
			pgb.setCurrentpage（1）;
			pgb.gotoPage（page）;
			
			rs.absolute（pgb.getRowscount（））;
			int?i=0;
			do{
				items.add（new?CarInfo（rs.getInt（“ID“）rs.getString（“CarId“）rs.getString（“CarDriverId“）rs.getString（“CarTeamId“）））;
			??
			???}while（rs.next（）&&i	
			}catch（Exception?ex）{ex.printStackTrace（）;}finally{dc.close（）;}
			
		return?items;
????}
???????
??public?int?DelCar（String?carid）{
????	
		String?delcar=“delete?from?carmanagertable?where?CarId=“+carid;
		
		int?flag=0;
		
		try{
			flag=dc.updata（delcar）;
			if（flag>0）{
				System.out.println（“車輛管理信息刪除成功，編號:“+carid）;
			???}else{
				System.out.println（“車輛管理信息刪除失敗，編號:“+carid）;
			?????????}
		????}catch（Exception?ex）{ex.printStackTrace（）;}finally{dc.close（）;}
			
	????return?flag;
????}

??public?int?ModifyCarManager（int?idString?caridString?driveridString?teamid）{
	??
	??int?flag=-10;
	??try{
		??int????mid=id;
		??String?cid=carid;
		??String?did=driverid;
		??String?tid=teamid;
		??String?strsql=“update?carmanagetable?set?CarId=‘“+cid+“‘CarDriverId=‘“+did+“‘CarTeamId=‘“+tid+“‘?where?ID=‘“+mid+“‘“;
		??
??????????flag=dc.updata（strsql）;?
		??if（flag>0）{
			??System.out.println（“編號=“+mid+“的汽車信息更新成功!“）;
		??}else{
			??System.out.println（“編號=“+mid+“的汽車信息更新失敗!“）;
		??}
	??}catch（Exception?ex）{ex.printStackTrace（）;}finally{dc.close（）;}
	?
	?return?flag;?
??}

??public?CarInfo?CarSearchById（int?id）{
	??
	??String?strsql=“select?*?from?carmanagetable?where?ID=“+id;
	??CarInfo?ci=new?CarInfo（）;
	??try{		??
		??stat=dc.getStmtread（）;
		??rs??=stat.executeQuery（strsql）;
		??while（rs.next（））{
			??ci.setId（rs.getInt（“ID“））;
			??ci.setCarid（rs.getString（“CarId“））;
			??ci.setCardriverid（rs.getString（“CarDriverId“））;
			??ci.setCarteamid（rs.getString（“CarTeamId“））

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

?????文件????????980??2007-04-20?18:43??js實現日期控件\PopupCalendar.htm

?????文件???????8656??2007-04-21?10:23??js實現日期控件\PopupCalendar.js

?????目錄??????????0??2007-04-20?18:19??js實現日期控件

-----------?---------??----------?-----??----

?????????????????9636????????????????????3