package?Parking_JDBC;
import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;

public?class?JdbcParkingsta?{
	Connection?con;
	
	public?JdbcParkingsta（）?{
		//?TODO?Auto-generated?constructor?stub
		this.con?=?JdbcUser.con;
	}
	
	
	

	public?int?insert（String?carnumString?carcharge）?{//增加
	????int?i?=?0;
	????String?sql?=?“insert?into?dbo.parkingsta?（carnumcarchargecarstate）?values（???）“;
	????PreparedStatement?pstmt;
	????try?{
	????????pstmt?=?（PreparedStatement）?con.prepareStatement（sql）;
	????????pstmt.setString（1?carnum）;
	????????pstmt.setString（2?carcharge）;
	????????pstmt.setString（3?“空閑“）;
	????????i?=?pstmt.executeUpdate（）;
	????????pstmt.close（）;
	????}?catch?（SQLException?e）?{
	????????e.printStackTrace（）;
	????}
	????return?i;
	}
	

	public?int?update（String?carnumString?carcharge）?{//修改
	????int?i?=?0;
	????String?sql?=?“update?dbo.parkingsta?set?carcharge=‘“?+?carcharge?+?“‘?where?carnum=‘“?+?carnum?+?“‘“;
	????PreparedStatement?pstmt;
	????try?{
	????????pstmt?=?（PreparedStatement）?con.prepareStatement（sql）;
	????????i?=?pstmt.executeUpdate（）;
	????????System.out.println（“resutl:?“?+?i）;
	????????pstmt.close（）;
	????}?catch?（SQLException?e）?{
	????????e.printStackTrace（）;
	????}
	????return?i;
	}
	
	public?int?delete（String?carnum）?{//刪除
	????int?i?=?0;
	????String?sql?=?“delete?from?dbo.parkingsta?where?carnum=‘“?+?carnum?+?“‘“;
	????PreparedStatement?pstmt;
	????try?{
	????????pstmt?=?（PreparedStatement）?con.prepareStatement（sql）;
	????????i?=?pstmt.executeUpdate（）;
	????????System.out.println（“resutl:?“?+?i）;
	????????pstmt.close（）;
	????}?catch?（SQLException?e）?{
	????????e.printStackTrace（）;
	????}
	????return?i;
	}
	
	
	
	/*
	?*?用于實現添加車輛信息
	?*/
	public?void?addCar（String?carnumString?carchargeString?carstate）?throws?Exception{
	????String?sql?=?“insert?into?dbo.parkingsta?（carnumcarchargecarstate）?values（???）“;
	????carcharge?=?carcharge?+?“元/小時“;
	????PreparedStatement?pstmt;
	????try?{
	????????pstmt?=?（PreparedStatement）?con.prepareStatement（sql）;
	????????pstmt.setString（1?carnum）;
	????????pstmt.setString（2?carcharge）;
	????????pstmt.setString（3?carstate）;
		????????try?{
		????????pstmt.executeUpdate（）;
		????????}catch（com.microsoft.sqlserver.jdbc.SQLServerException?e1）?{
		????????	//車位已存在時拋出異常，由外部使用該代碼塊時進行處理
		????????	throw?new?Exception（“com.microsoft.sqlserver.jdbc.SQLServerException“）;
		????????}
		????????pstmt.close（）;
		????}?catch?（SQLException?e）?{
		????????e.printStackTrace（）;
		????}
		}
	
	public?int?getRow（int?x）?{//獲取表中行數
		int?i?=?0;
		String?sql?=?“select?*?from?db_jdbc.dbo.parkingsta“;
		if（x?==?1）?{//獲取全部行數
	????sql?=?“select?*?from?db_jdbc.dbo.parkingsta“;
		}else?if（x?==?2）{//獲取空閑車位行數
			sql?=?“select?*?from?db_jdbc.dbo.parkingsta?where?carstate?=?“?+?“‘“?+?“空閑“??+“‘“;
		}else?if（x?==?3

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-08-19?21:11??ParkingM\
?????文件?????????412??2018-08-18?16:42??ParkingM\.classpath
?????文件?????????384??2018-08-18?16:42??ParkingM\.project
?????目錄???????????0??2018-08-19?21:11??ParkingM\.settings\
?????文件?????????598??2018-08-18?16:42??ParkingM\.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2018-08-19?21:11??ParkingM\bin\
?????目錄???????????0??2018-08-19?21:11??ParkingM\bin\Parking_JDBC\
?????文件????????4834??2018-08-19?17:35??ParkingM\bin\Parking_JDBC\JdbcParkingsta.class
?????文件????????4022??2018-08-19?18:25??ParkingM\bin\Parking_JDBC\JdbcPlate.class
?????文件????????5042??2018-08-19?17:35??ParkingM\bin\Parking_JDBC\JdbcUser.class
?????目錄???????????0??2018-08-19?21:11??ParkingM\bin\Parking_UI\
?????文件????????2617??2018-08-19?18:47??ParkingM\bin\Parking_UI\MyButtonEditor$1.class
?????文件????????2778??2018-08-19?18:47??ParkingM\bin\Parking_UI\MyButtonEditor.class
?????文件????????1287??2018-08-19?16:47??ParkingM\bin\Parking_UI\MyButtonRender.class
?????文件????????2390??2018-08-19?18:31??ParkingM\bin\Parking_UI\UIlogon$1.class
?????文件????????1644??2018-08-19?18:31??ParkingM\bin\Parking_UI\UIlogon$2$1.class
?????文件?????????785??2018-08-19?18:31??ParkingM\bin\Parking_UI\UIlogon$2$2.class
?????文件????????2312??2018-08-19?18:31??ParkingM\bin\Parking_UI\UIlogon$2.class
?????文件????????2576??2018-08-19?18:31??ParkingM\bin\Parking_UI\UIlogon.class
?????文件????????1737??2018-08-19?18:54??ParkingM\bin\Parking_UI\UImain$1.class
?????文件????????1791??2018-08-19?18:54??ParkingM\bin\Parking_UI\UImain$2.class
?????文件????????1636??2018-08-19?18:54??ParkingM\bin\Parking_UI\UImain$3.class
?????文件?????????852??2018-08-19?18:54??ParkingM\bin\Parking_UI\UImain$4.class
?????文件????????9460??2018-08-19?18:54??ParkingM\bin\Parking_UI\UImain.class
?????目錄???????????0??2018-08-19?21:11??ParkingM\src\
?????目錄???????????0??2018-08-19?21:11??ParkingM\src\Parking_JDBC\
?????文件????????4841??2018-08-19?17:35??ParkingM\src\Parking_JDBC\JdbcParkingsta.java
?????文件????????3550??2018-08-19?18:25??ParkingM\src\Parking_JDBC\JdbcPlate.java
?????文件????????4463??2018-08-19?17:35??ParkingM\src\Parking_JDBC\JdbcUser.java
?????目錄???????????0??2018-08-19?21:11??ParkingM\src\Parking_UI\
?????文件????????4789??2018-08-19?18:47??ParkingM\src\Parking_UI\MyButtonEditor.java
............此處省略3個文件信息