package?com.zbdx.web.dao;

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

/**
?*?數據庫簡單工具類
?*?@author?Gao
?*/
public?class?DBUtil?{
	
	private?static?String?driverUri=“com.mysql.jdbc.Driver“;
	private?static?String?uri=“jdbc:mysql://localhost:3306/library“;
	private?static?String?username=“root“;
	private?static?String?password=“root“;
	
	/**
	?*?加載驅動，并打開一個數據庫的鏈接。
	?*/
	public?static?Connection?getConn（）{
		try?{
			Class.forName（driverUri）;
			return?DriverManager.getConnection（uri?username?password）;
		}?catch?（ClassNotFoundException?e）?{
			System.err.println（“驅動加載失?。≌垯z查是否已添加驅動包或驅動類地址是否正確！“）;
			e.printStackTrace（）;
		}?catch?（SQLException?e）?{
			System.err.println（“數據庫鏈接位置錯誤/用戶名密碼不匹配/services服務未啟動！“）;
			e.printStackTrace（）;
		}
		return?null;
	}
	
	/**
	?*?關閉打開的鏈接，釋放資源
	?*/
	public?static?void?closeConn（Connection?conn）{
		if（conn!=null）{
			try?{
				conn.close（）;
			}?catch?（SQLException?e）?{
				System.err.println（“鏈接關閉異常！“）;
				e.printStackTrace（）;
			}finally?{
				conn?=?null;
			}
		}
	}
	
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-03-20?16:15??library\
?????文件?????????841??2018-03-15?15:46??library\.classpath
?????文件????????1040??2018-03-15?15:46??library\.project
?????目錄???????????0??2018-03-20?16:15??library\.settings\
?????文件?????????567??2018-03-15?15:46??library\.settings\.jsdtscope
?????文件?????????670??2018-03-15?15:47??library\.settings\org.eclipse.jdt.core.prefs
?????文件?????????473??2018-03-15?15:46??library\.settings\org.eclipse.wst.common.component
?????文件?????????345??2018-03-15?15:46??library\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2018-03-15?15:46??library\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2018-03-15?15:46??library\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2018-03-20?16:15??library\WebContent\
?????目錄???????????0??2018-03-20?16:15??library\WebContent\meta-INF\
?????文件??????????39??2018-03-15?15:46??library\WebContent\meta-INF\MANIFEST.MF
?????目錄???????????0??2018-03-20?16:15??library\WebContent\WEB-INF\
?????目錄???????????0??2018-03-20?16:15??library\WebContent\WEB-INF\lib\
?????文件??????832960??2018-03-15?16:01??library\WebContent\WEB-INF\lib\mysql-connector-java-5.1.22.jar
?????文件?????????419??2018-03-15?15:52??library\WebContent\WEB-INF\web.xml
?????目錄???????????0??2018-03-20?16:15??library\WebContent\css\
?????文件????????5556??2018-03-15?15:50??library\WebContent\css\admin.html
?????文件????????4508??2018-03-15?15:50??library\WebContent\css\common1.css
?????文件????????5543??2018-03-15?15:50??library\WebContent\css\control.css
?????文件???????16419??2018-03-16?10:02??library\WebContent\css\css.css
?????文件????????6639??2018-03-15?15:50??library\WebContent\css\head.css
?????文件????????3028??2018-03-16?09:19??library\WebContent\css\style.css
?????文件????????1487??2018-03-15?15:50??library\WebContent\css\style0.css
?????文件?????????790??2018-03-15?15:50??library\WebContent\css\tab.js
?????目錄???????????0??2018-03-20?16:15??library\WebContent\images\
?????文件??????????74??2018-03-15?15:50??library\WebContent\images\01.gif
?????文件??????????76??2018-03-15?15:50??library\WebContent\images\02.gif
?????文件?????????225??2018-03-15?15:50??library\WebContent\images\03.gif
?????文件??????????54??2018-03-15?15:50??library\WebContent\images\04.gif
............此處省略120個文件信息