package?通訊錄;

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

public?class?DBConn?{
	private?static?String?driverName?=?“com.mysql.jdbc.Driver“;
	private?static?String?url?=?“jdbc:mysql://localhost:3306/address?characterEncoding=utf8&useSSL=true“;
	private?static?String?userName?=?“root“;
	private?static?String?password?=?“123456“;
	private?Connection?conn;
	private?Statement?stmt;

	public?DBConn（）?{
		try?{
			Class.forName（driverName）;
		}?catch?（ClassNotFoundException?e）?{
			e.printStackTrace（）;
		}
	}

	/**
	?*?連接數(shù)據(jù)庫(kù)
	?*?
	?*?@return
	?*?@throws?SQLException
	?*/
	public?Connection?getConnection（）?throws?SQLException?{
		return?DriverManager.getConnection（url?userName?password）;
	}

	/**
	?*?釋放資源
	?*/
	public?void?dispose（）?{
		try?{
			if?（conn?!=?null）?{
				conn.close（）;
			}
			if?（stmt?!=?null）?{
				stmt.close（）;
			}
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
	}

}

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

?????文件????????266??2018-06-24?20:18??address.sql

?????文件????????301??2018-01-18?17:33??通訊錄\.classpath

?????文件????????385??2018-01-18?17:33??通訊錄\.project

?????文件????????598??2018-01-18?17:33??通訊錄\.settings\org.eclipse.jdt.core.prefs

?????文件???????1529??2018-06-25?22:56??通訊錄\bin\通訊錄\DBConn.class

?????文件???????8453??2018-06-25?22:59??通訊錄\bin\通訊錄\MyAddressBook.class

?????文件???????8225??2018-06-25?22:46??通訊錄\bin\通訊錄\MyDialog.class

?????文件??????15542??2018-02-09?00:13??通訊錄\image\create.png

?????文件???????6937??2018-02-08?23:37??通訊錄\image\delete.png

?????文件??????12511??2018-02-08?23:37??通訊錄\image\flash.png

?????文件??????13230??2018-02-08?23:37??通訊錄\image\search.png

?????文件??????14094??2018-02-08?23:37??通訊錄\image\update.png

?????文件???????1066??2018-06-25?22:56??通訊錄\src\通訊錄\DBConn.java

?????文件???????7000??2018-06-25?22:59??通訊錄\src\通訊錄\MyAddressBook.java

?????文件???????6735??2018-06-25?22:46??通訊錄\src\通訊錄\MyDialog.java

?????目錄??????????0??2018-06-25?22:43??通訊錄\bin\通訊錄

?????目錄??????????0??2018-02-10?23:26??通訊錄\src\通訊錄

?????目錄??????????0??2018-01-18?17:33??通訊錄\.settings

?????目錄??????????0??2018-06-25?22:43??通訊錄\bin

?????目錄??????????0??2018-02-09?00:15??通訊錄\image

?????目錄??????????0??2018-01-18?17:34??通訊錄\src

?????目錄??????????0??2018-02-08?23:38??通訊錄

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

????????????????96872????????????????????22