package?com.database;

import?java.sql.*;

/**

?*?數據庫連接類

?*

?*/

public?class?DBConnection?{

	private?static?Connection?con?=?null;?????//定義一個connection變量
	private?static?String?url?=?“jdbc:mysql://localhost:3306/store“;??//url=“jdbc:mysql://主機地址:端口號：數據庫名“?默認端口3306
	private?static?String?user?=?“root“;???//數據庫用戶名
	private?static?String?password?=?“jinlingxiao“;??//數據庫密碼

	public?static?Connection?getCon（）?{
		//加載數據庫驅動
		try?{
			Class.forName（“com.mysql.jdbc.Driver“）;??//在一些應用中，無法事先知道使用者將加載什么類，而必須讓使用者指定類名稱以加載類，可以使用?Class?的靜態?forName（）?方法實現動態加載類。Mysql驅動程序類名：?com.mysql.jdbc.Driver
		}?catch?（ClassNotFoundException?e）?{
			System.out.println（“加載數據庫驅動失敗！“）;
			e.printStackTrace（）;
		}
		//獲取數據庫連接
		try?{
			con?=?DriverManager.getConnection（url?user?password）;??//建立數據庫對象
			if（con?!=?null）?{?????//建立成功
				System.out.println（“數據庫連接成功！“）;
			}
		}?catch?（SQLException?e）?{???????//拋出異常
			System.out.println（“數據庫連接失敗！“）;
			e.printStackTrace（）;
		}
		//返回Connection對象
		return?con;
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2019-05-12?15:53??靳凌霄\
?????文件?????????459??2019-05-12?16:18??靳凌霄\.classpath
?????文件?????????385??2019-05-14?19:29??靳凌霄\.project
?????目錄???????????0??2019-05-12?15:53??靳凌霄\.settings\
?????文件?????????598??2019-05-12?15:53??靳凌霄\.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2019-06-12?08:11??靳凌霄\bin\
?????文件?????????459??2019-05-12?16:18??靳凌霄\bin\.classpath
?????文件?????????385??2019-05-14?19:29??靳凌霄\bin\.project
?????目錄???????????0??2019-06-12?08:11??靳凌霄\bin\.settings\
?????文件?????????598??2019-05-12?15:53??靳凌霄\bin\.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2019-06-12?08:11??靳凌霄\bin\com\
?????目錄???????????0??2019-06-12?08:11??靳凌霄\bin\com\database\
?????文件????????1485??2019-06-12?08:11??靳凌霄\bin\com\database\DBConnection.class
?????目錄???????????0??2019-06-12?08:11??靳凌霄\bin\com\login\
?????文件?????????620??2019-06-12?08:11??靳凌霄\bin\com\login\Login.class
?????文件????????1811??2019-06-12?08:11??靳凌霄\bin\com\login\Students.class
?????目錄???????????0??2019-06-12?08:11??靳凌霄\bin\com\management\
?????文件????????5189??2019-06-12?08:11??靳凌霄\bin\com\management\AddManagement.class
?????文件????????5270??2019-06-12?08:11??靳凌霄\bin\com\management\AlterManagement.class
?????文件????????3930??2019-06-12?08:11??靳凌霄\bin\com\management\DeleteManagement.class
?????文件????????7850??2019-06-12?08:11??靳凌霄\bin\com\management\SearchManagement.class
?????文件?????????738??2019-06-12?08:11??靳凌霄\bin\com\management\StudentManagement$1.class
?????文件????????3064??2019-06-12?08:11??靳凌霄\bin\com\management\StudentManagement.class
?????文件???????86003??2019-05-14?19:31??靳凌霄\bin\com\management\主界面.jpg
?????目錄???????????0??2019-05-12?15:53??靳凌霄\src\
?????目錄???????????0??2019-05-12?15:57??靳凌霄\src\com\
?????目錄???????????0??2019-05-12?15:53??靳凌霄\src\com\database\
?????文件????????1206??2019-05-16?22:23??靳凌霄\src\com\database\DBConnection.java
?????目錄???????????0??2019-05-12?22:26??靳凌霄\src\com\login\
?????文件?????????670??2019-05-16?22:23??靳凌霄\src\com\login\Login.java
?????文件????????1148??2019-05-16?22:23??靳凌霄\src\com\login\Students.java
............此處省略7個文件信息