package?com.bipt.dao;

import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?com.bipt.util.JDBCUtil;
import?com.bipt.vo.Car;
import?com.bipt.vo.Delivery;
import?com.bipt.vo.Routline;

public?class?AddDao?{
	private?boolean?isTrue?=?false;
	public?boolean?addBasic（Routline?routline）{
		Connection?connection?=?new?JDBCUtil（）.getConnection（）;
		
		String?onePort?=?routline.getOnePort（）;
		String?anotherPort?=?routline.getAnotherPort（）;
		String?stop?=?routline.getStop（）;
		float?totalKm?=?routline.getTotalKm（）;
		String?routlineId?=?onePort+“到“+anotherPort;
		
		String?sql?=?“insert?into?routline（routlineIdonePortstopanotherPorttotalKm）?values（?????）“;
		PreparedStatement?st;
		
		try?{
			st?=?connection.prepareStatement（sql）;
			st.setString（1routlineId）;
			st.setString（2onePort）;
			st.setString（3stop）;
			st.setString（4anotherPort）;
			st.setFloat（5totalKm）;
			
			st.execute（）;
			isTrue?=?true;
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
		}
		return?isTrue;
		
	}
	public?boolean?addCar（Car?car）?{
		Connection?connection?=?new?JDBCUtil（）.getConnection（）;
		
		int?carType?=?car.getCarType（）;//貨車類型（數(shù)據(jù)字典：大，中，小卡車對(duì)應(yīng)012）
		float?loadMg?=?car.getLoadMg（）;//車載質(zhì)量
		float?loadV?=?car.getLoadV（）;//車載體積
		String?driverName?=?car.getDriverName（）;//駕駛員姓名
		String?driverName2?=?car.getDriverName2（）;//副駕駛姓名
		
		String?sql?=?“insert?into?car（carTypeloadMgloadVdriverNamedriverName2）?values（?????）“;
		PreparedStatement?ps;
		try?{
			ps?=?connection.prepareStatement（sql）;
			ps.setInt（1?carType）;
			ps.setFloat（2?loadMg）;
			ps.setFloat（3?loadV）;
			ps.setString（4?driverName）;
			ps.setString（5?driverName2）;
			
			ps.execute（）;
			isTrue?=?true;
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
		}
		return?isTrue;
	}
	//增加配送點(diǎn)
	public?boolean?addPoint（Delivery?delivery）?{
		Connection?connection?=?new?JDBCUtil（）.getConnection（）;
		
		String?address?=?delivery.getAddrss（）;
		String?name?=?delivery.getName（）;
		String?createTime?=?delivery.getCreateTime（）;
		
		String?sql?=?“insert?into?delivery（addressnamecreateTime）?values（???）“;
		
		PreparedStatement?ps;
		try?{	
			ps?=?connection.prepareStatement（sql）;
			ps.setString（1?address）;
			ps.setString（2?name）;
			ps.setString（3?createTime）;
			System.out.println（sql）;
			ps.execute（）;
			isTrue?=?true;
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
		}
		return?isTrue;
	}

}

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件????3991552??2015-03-23?11:06??01論文定稿.doc

?????文件????3416161??2015-03-23?11:06??答辯.pptx

?????文件????????180??2015-03-23?11:06??說明.txt

?????文件????????455??2015-03-23?11:06??02程序\Wuliu\.classpath

?????文件????????288??2015-03-23?11:06??02程序\Wuliu\.mymetadata

?????文件???????1411??2015-03-23?11:06??02程序\Wuliu\.project

?????文件????????500??2015-03-23?11:06??02程序\Wuliu\.settings\.jsdtscope

?????文件?????????86??2015-03-23?11:06??02程序\Wuliu\.settings\org.eclipse.core.resources.prefs

?????文件?????????83??2015-03-23?11:06??02程序\Wuliu\.settings\org.eclipse.core.runtime.prefs

?????文件?????????49??2015-03-23?11:06??02程序\Wuliu\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2015-03-23?11:06??02程序\Wuliu\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????2547??2015-03-23?11:06??02程序\Wuliu\src\com\bipt\dao\AddDao.java

?????文件???????6987??2015-03-23?11:06??02程序\Wuliu\src\com\bipt\dao\AddRegulationDao.java

?????文件???????2783??2015-03-23?11:06??02程序\Wuliu\src\com\bipt\dao\CarDao.java

?????文件???????4772??2015-03-23?11:06??02程序\Wuliu\src\com\bipt\dao\DeliveryDao.java

?????文件???????8360??2015-03-23?11:06??02程序\Wuliu\src\com\bipt\dao\HandoverDao.java

?????文件???????1903??2015-03-23?11:06??02程序\Wuliu\src\com\bipt\dao\LoginDao.java

?????文件??????17235??2015-03-23?11:06??02程序\Wuliu\src\com\bipt\dao\OrderDao.java

?????文件??????16112??2015-03-23?11:06??02程序\Wuliu\src\com\bipt\dao\QueryDao.java

?????文件??????13054??2015-03-23?11:06??02程序\Wuliu\src\com\bipt\dao\QueryStationDao.java

?????文件???????9598??2015-03-23?11:06??02程序\Wuliu\src\com\bipt\dao\RegulationDao.java

?????文件?????????57??2015-03-23?11:06??02程序\Wuliu\src\com\bipt\dao\RoleDao.java

?????文件???????3437??2015-03-23?11:06??02程序\Wuliu\src\com\bipt\dao\RoutLineDao.java

?????文件???????1895??2015-03-23?11:06??02程序\Wuliu\src\com\bipt\dao\StationOrderDao.java

?????文件???????5234??2015-03-23?11:06??02程序\Wuliu\src\com\bipt\dao\UpdateStationDao.java

?????文件??????10498??2015-03-23?11:06??02程序\Wuliu\src\com\bipt\dao\UserDao.java

?????文件???????2163??2015-03-23?11:06??02程序\Wuliu\src\com\bipt\dao\XiaOrderStationDao.java

?????文件???????1240??2015-03-23?11:06??02程序\Wuliu\src\com\bipt\fo\Index1OrderSelectFo.java

?????文件???????1447??2015-03-23?11:06??02程序\Wuliu\src\com\bipt\fo\Index2BancichaxunFo.java

?????文件???????3433??2015-03-23?11:06??02程序\Wuliu\src\com\bipt\fo\OrderxiangqingFo.java

............此處省略1013個(gè)文件信息