package?com.xtkj.oop.project;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.ResultSet;
import?java.sql.Statement;

public?class?DBManager?{
	private?static?final?String?DRIVER?=“com.mysql.jdbc.Driver“;
	private?static?final?String?URL=“jdbc:mysql://localhost:3306/oopxm?useSSL=false“;
	private?static?final?String?USER=“root“;
	private?static?final?String?PWD=“03013296“;
	Connection?con=null;
	
	//建立與數據庫的連接
	public?Connection?getConnection（）throws?Exception?{
		try?{
			Class.forName（DRIVER）;
		
			con=DriverManager.getConnection（URL?USER?PWD）;		
			
		}catch（Exception?e）?{
			e.printStackTrace（）;
		}
		return?con;
	}
	public?void?close（ResultSet?rst??Statement?ste?Connection?conn）?{
		try?{
			if（rst!=null）?{
				rst.close（）;
			}
			if（ste!=null）?{
				ste.close（）;
			}
			if（conn!=null）?{
				conn.close（）;
			}
		}catch（Exception?e）?{
			e.printStackTrace（）;
		}
	}
	public?void?close（Statement?ste?Connection?conn）?{
		try?{		
			if（ste!=null）?{
				ste.close（）;
			}
			if（conn!=null）?{
				conn.close（）;
			}
		}catch（Exception?e）?{
			e.printStackTrace（）;
		}
	}
}

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

?????文件???????1180??2018-09-17?10:12??新建文件夾\project\DBManager.java

?????文件???????1712??2018-09-18?12:15??新建文件夾\project\Goods.java

?????文件???????9510??2018-09-19?12:28??新建文件夾\project\ShopCar.java

?????文件???????7069??2018-09-18?15:11??新建文件夾\project\Supermark.java

?????文件???????1286??2018-09-19?09:21??新建文件夾\project\Tborders.java

?????文件???????2932??2018-09-19?11:34??新建文件夾\project\Test.java

?????文件???????1231??2018-09-17?11:32??新建文件夾\project\User.java

?????文件???????3020??2018-09-18?17:39??新建文件夾\project\UserDatabase.java

?????目錄??????????0??2018-09-19?12:49??新建文件夾\project

?????目錄??????????0??2018-09-19?12:49??新建文件夾

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

????????????????27940????????????????????10