package?com.fxz.dao;
	
import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.util.ArrayList;
import?java.util.List;

import?com.fxz.po.Car;
import?com.fxz.po.Parking;


public?class?CarDao?{
	Connection?conn?=?null;
	PreparedStatement?pst?=?null;
	ResultSet?rst?=?null;
	static?List?list?=?new?ArrayList（）;
	boolean?flag?=?false;
	
	//查詢車輛情況
	public?List?showCars（）{
		
		List?list?=?new?ArrayList（）;
		String?sql?=?“select?idkindcolorparkIdinTimerice?from?car“;
		try?{
			conn?=?DBManager.getCon（）;
			pst?=?conn.prepareStatement（sql）;
			rst?=?pst.executeQuery（）;
			while?（rst.next（））?{
				Car?car?=?new?Car（）;
				car.setId（rst.getString（“id“））;
				car.setKind（rst.getString（“kind“））;				
				car.setColor（rst.getString（“color“））;
				car.setParkId（rst.getInt（“parkId“））;
				car.setInTime（rst.getString（“inTime“））;
				car.setRice（rst.getFloat（“rice“））;				
				list.add（car）;
			}
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}?finally?{
			DBManager.closeAll（conn?pst?rst）;
		}
		return?list;
	}
	
	//有車輛進入時，將獲取到的車輛信息存入到數據庫中
	public?boolean?AddCar（String?Id?String?kindString?colorint?parkId?String?timelong?time0float?ricefloat?money）?{	
		String?sql?=?“insert?into?car（IdkindcolorparkIdinTimetime0ricemoney）values（????????）“;
		try?{
			conn?=?DBManager.getCon（）;
			pst?=?conn.prepareStatement（sql）;
			pst.setString（1?Id）;
			pst.setString（2?kind）;
			pst.setString（3?color）;
			pst.setInt（4?parkId）;
			pst.setString（5?time）;
			pst.setLong（6?time0）;
			pst.setFloat（7?rice）;
			pst.setFloat（8?money）;
			int?i?=?pst.executeUpdate（）;
			if?（i?>?0）?{
				flag?=?true;
			}
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}?finally?{
			DBManager.closeAll（conn?pst?rst）;
		}

		return?flag;
	}
????/*
	//查詢車輛數據
	public?Car?lookCar（String?id）?{
		Car?car?=?new?Car（）;
		String?sql?=?“select?idkindcolorinTimerice?from?car?where?id?=??“;
		try?{
			conn?=?DBManager.getCon（）;
			pst?=?conn.prepareStatement（sql）;
			pst.setString（1?id）;
			rst?=?pst.executeQuery（）;
			while?（rst.next（））?{				
				car.setId（rst.getString（“id“））;
				car.setColor（rst.getString（“color“））;
				car.setInTime（rst.getString（“inTime“））;
				car.setRice（rst.getFloat（“rice“））;

			}
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}?finally?{
			DBManager.closeAll（conn?pst?rst）;
		}
		return?car;
	}
*/
	
	//查詢車輛存放的車位
	public?int?findParking（String?id）{
		String?sql?=?“select?parkId?from?car?where?id?=??“;
		Car?car?=?new?Car（）;
		try?{
			conn?=?DBManager.getCon（）;
			pst?=?conn.prepareStatement（sql）;
			pst.setString（1?id）;
			rst?=?pst.executeQuery（）;
			while（rst.next（））{
				car.setParkId（rst.getInt（“parkId“））;
				
			}
			
		}?catch?（SQLException?e）?{
			e.printStackTrac

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2012-09-23?22:02??parking\
?????文件?????????464??2012-04-14?15:47??parking\.classpath
?????文件?????????384??2012-04-12?23:03??parking\.project
?????目錄???????????0??2012-09-23?22:02??parking\bin\
?????目錄???????????0??2012-09-23?22:02??parking\bin\com\
?????目錄???????????0??2012-09-23?22:02??parking\bin\com\fxz\
?????目錄???????????0??2012-09-23?22:02??parking\bin\com\fxz\dao\
?????文件????????5371??2012-06-07?16:40??parking\bin\com\fxz\dao\CarDao.class
?????文件????????4699??2012-06-12?20:56??parking\bin\com\fxz\dao\CardDao.class
?????文件????????1947??2012-06-07?16:25??parking\bin\com\fxz\dao\DBManager.class
?????文件????????1300??2012-06-07?18:59??parking\bin\com\fxz\dao\GetSystime.class
?????文件????????3644??2012-06-15?10:55??parking\bin\com\fxz\dao\ParkingDao.class
?????目錄???????????0??2012-09-23?22:02??parking\bin\com\fxz\frame\
?????文件????????2758??2012-06-12?21:09??parking\bin\com\fxz\frame\AddAmountframe.class
?????文件?????????735??2012-06-12?21:09??parking\bin\com\fxz\frame\AddAmountframe_jButton1_actionAdapter.class
?????文件?????????735??2012-06-12?21:09??parking\bin\com\fxz\frame\AddAmountframe_jButton2_actionAdapter.class
?????文件????????2925??2012-06-14?18:21??parking\bin\com\fxz\frame\AddCarframe.class
?????文件?????????717??2012-06-14?18:21??parking\bin\com\fxz\frame\AddCarframe_jButton1_actionAdapter.class
?????文件?????????717??2012-06-14?18:21??parking\bin\com\fxz\frame\AddCarframe_jButton2_actionAdapter.class
?????文件?????????717??2012-06-14?18:21??parking\bin\com\fxz\frame\AddCarframe_jButton3_actionAdapter.class
?????文件?????????717??2012-06-14?18:21??parking\bin\com\fxz\frame\AddCarframe_jButton4_actionAdapter.class
?????文件????????3381??2012-06-12?22:44??parking\bin\com\fxz\frame\AddCardframe.class
?????文件?????????723??2012-06-12?22:44??parking\bin\com\fxz\frame\AddCardframe_jButton1_actionAdapter.class
?????文件?????????723??2012-06-12?22:44??parking\bin\com\fxz\frame\AddCardframe_jButton2_actionAdapter.class
?????文件????????5873??2012-06-19?22:23??parking\bin\com\fxz\frame\CarLeaveframe.class
?????文件?????????729??2012-06-19?22:23??parking\bin\com\fxz\frame\CarLeaveframe_jButton1_actionAdapter.class
?????文件?????????729??2012-06-19?22:23??parking\bin\com\fxz\frame\CarLeaveframe_jButton2_actionAdapter.class
?????文件?????????729??2012-06-19?22:23??parking\bin\com\fxz\frame\CarLeaveframe_jButton3_actionAdapter.class
?????文件?????????729??2012-06-19?22:23??parking\bin\com\fxz\frame\CarLeaveframe_jButton4_actionAdapter.class
?????文件????????4779??2012-06-12?21:59??parking\bin\com\fxz\frame\Cardframe.class
?????文件?????????705??2012-06-12?21:59??parking\bin\com\fxz\frame\Cardframe_jButton1_actionAdapter.class
............此處省略71個文件信息