package?data;

import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.Statement;

public?class?DatabaseCreator?{
	private?Connection?cn;
	private?Statement?stmt;
	private?PreparedStatement?prepStmt;
	
	public?DatabaseCreator（）?{
		cn=new?DatabaseManager（）.openConnection（）;
	}
	public?void?dropTable（）{
		try{
			stmt=?cn.createStatement（）;		
			stmt.execute（“drop?table?driver“）;
			System.out.println（“drop?table?driver“）;
		}catch（Exception?e）{
			System.out.println（“drop?table?driver?error:“+e）;
		}		
	}
	public?void?ceateTable（）{
		try{
			stmt=?cn.createStatement（）;		

			stmt.execute（“?create?table?driver（DriverNo?varchar（18）DriverName?varchar（8）?DriverSex?varchar（2）“?+
					“?BirthDate?varchar（18）?LicenseNo?varchar（10）?LicenseDate?varchar（18）LicenseValidTime?varchar（15）“?+
					“?DrivingExp?doubleDrivingType?varchar（14）?EntryDate?varchar（18）?TelNo?varchar（16）ExamRec?varchar（20）“?+
					“?Memo?varchar（80）?）?“）;
			stmt.execute（“?create?table?vehicle（VehicleNo?varchar（18）VehicleType?varchar（8）DriverNo?varchar（2）?“?+
					“?BuyDate?DateVehicleModel?varchar（30）DriverOrUnit?varchar（30）SubordinateUnit?varchar（15）“?+
					“?ExamRec?varchar（200）InsureranceRec?varchar（200）VehicleStatus?varchar（20）Memo?varchar（80）?）?“）;
			stmt.execute（“?create?table?accidentrec?（AccidentNo?varchar（18）?VehicleNo?varchar（18）VehicleType?varchar（8）“?+
					“?DriverNo?varchar（2）AccidentDate?DateAccidentType?varchar（30）AccidentBrief?varchar（80）?“?+
					“?AccidentConfirm?varchar（15）UnitFee?doubleOpposingFee?doubleOpposingName?varchar（20）“?+
					“?OpposingAddr?varchar（20）OpposingUnit?varchar（20）OpposingTelNo?varchar（16）OpposingDamage?varchar（20）“?+
					“?ReconcilMemo?varchar（80））?“）;
			stmt.execute（“?create?table?vehiclerepair（RepairNo?varchar（18）vehicleNo?varchar（18）RepairDate?DateRepairType?varchar（10）“?+
					“?BreakdownConfirm?varchar（10）BreakdownBrief?varchar（80）RepairmanOrComp?varchar（20）PartReplace?varchar（100）“?+
					“?Receiver?varchar（10）ReceiveDate?DateTotalFee?doubleMemo?varchar（80））?“）;
			stmt.execute（“?create?table?vehiclechange（ChangeNo?varchar（18）vehicleNo?varchar（18）ChangeDate?dateChangeType?varchar（10）“?+
					“?Handler?varchar（10）Confirm?varchar（10）ChangeReason?varchar（80）changeAddr?varchar（20）Memo?varchar（80））?“）;
			stmt.execute（“?create?table?vehicleoperate（TaskNo?varchar（18）vehicleNo?varchar（18）Operdate?DateTaskBrief?varchar（100）“?+
					“?AssignPeople?varchar（10）EstimateTime?double?PraticalTime?doubleExtraTimeReason?varchar（80）Cost?doubleMemo?varchar（80））?“）;
			stmt.execute（“?create?table?achievemnts（DriverNo?varchar（18）VehicleNo?varchar（18）Month?char（6）TaskNum?int?OperTotalTime?double“?+
					“?Repairnum?int?RepairTotalFee?doubleAccinum?intAcciTotalFee?doubleArchiveMark?doubleArchiveReward?double）?“）;
		}catch（Exception?e）{
			System.out.println（“Created?table?student?error:“+e）;
		}		
	}
	public?

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

?????文件????????433??2012-01-09?18:33??車輛管理系統1\.classpath

?????文件????????296??2012-01-09?23:00??車輛管理系統1\.mymetadata

?????文件???????1228??2012-01-09?18:33??車輛管理系統1\.project

?????文件????????424??2012-01-09?18:33??車輛管理系統1\.settings\org.eclipse.core.resources.prefs

?????文件????????629??2012-01-09?18:33??車輛管理系統1\.settings\org.eclipse.jdt.core.prefs

?????文件?????151820??2012-01-09?18:33??車輛管理系統1\image\p2.jpg

?????文件??????69975??2012-01-09?18:33??車輛管理系統1\image\pp1.jpg

?????文件??????69072??2012-01-09?18:33??車輛管理系統1\image\pp2.jpg

?????文件??????68572??2012-01-09?18:33??車輛管理系統1\image\pp3.jpg

?????文件??????68823??2012-01-09?18:33??車輛管理系統1\image\pp4.jpg

?????文件??????68624??2012-01-09?18:33??車輛管理系統1\image\pp5.jpg

?????文件??????68713??2012-01-09?18:33??車輛管理系統1\image\pp6.jpg

?????文件??????67036??2012-01-09?18:33??車輛管理系統1\image\pp7.jpg

?????文件???????4462??2012-01-09?18:33??車輛管理系統1\src\data\DatabaseCreator.java

?????文件????????578??2012-01-09?18:33??車輛管理系統1\src\data\DatabaseManager.java

?????文件???????3217??2012-01-09?18:33??車輛管理系統1\src\servlet\AccidentServlet.java

?????文件???????2734??2012-01-09?18:33??車輛管理系統1\src\servlet\AchieveServlet.java

?????文件???????2383??2012-01-09?18:33??車輛管理系統1\src\servlet\ChangeServlet.java

?????文件???????2789??2012-01-09?18:33??車輛管理系統1\src\servlet\DriverServlet.java

?????文件???????2493??2012-01-09?18:33??車輛管理系統1\src\servlet\OperateServlet.java

?????文件???????2872??2012-01-09?18:33??車輛管理系統1\src\servlet\RepairServlet.java

?????文件???????2534??2012-01-09?18:33??車輛管理系統1\src\servlet\VehicleServlet.java

?????文件???????2969??2012-01-09?18:33??車輛管理系統1\src\vehicleclass\Accident.java

?????文件???????5154??2012-01-09?18:33??車輛管理系統1\src\vehicleclass\AccidentManager.java

?????文件???????1906??2012-01-09?18:33??車輛管理系統1\src\vehicleclass\Achieve.java

?????文件???????4047??2012-01-09?18:33??車輛管理系統1\src\vehicleclass\AchieveManager.java

?????文件???????1509??2012-01-09?18:33??車輛管理系統1\src\vehicleclass\Change.java

?????文件???????3692??2012-01-09?18:33??車輛管理系統1\src\vehicleclass\ChangeManager.java

?????文件???????4422??2012-01-09?18:33??車輛管理系統1\src\vehicleclass\DriverManager.java

?????文件???????2240??2012-01-09?18:33??車輛管理系統1\src\vehicleclass\Drivers.java

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