package?commons;

import?java.sql.CallableStatement;
import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;
import?java.util.Properties;

public?class?DBUtil?{
	static?Properties?properties?=?null;??
????public?DBUtil（）{??
??????
????}??
????public?static?Connection?getConn（）{??
????????Connection?connection?=?null;??
????????try{??
????????????Class.forName（“com.mysql.jdbc.Driver“）;??
????????????connection?=?DriverManager.getConnection（“jdbc:mysql://localhost:3306/shop1?useUnicode=true&characterEncoding=UTF-8““root““123“）;??
????????}catch?（Exception?err）?{??
????????????System.out.println（“連接ConDB-->getCon（）____JDBC錯誤!“）;??
????????????err.printStackTrace（）;????
????????????return?null;?????
????????}??
????????return?connection;??
????}??
????/**?
?????*?以下是關閉重載方法?
?????*?@param?rs?
?????*?@param?st?
?????*?@param?conn?
?????*?@throws?SQLException?
?????*/??
????public?static?void?closeAll（ResultSet?rsStatement?stConnection?conn）{??
????	try?{
????		if（rs!=null）{??
????????????????rs.close（）;??
????????????}??
????????????if（st!=null）{??
????????????????st.close（）;??
????????????}?
????????????if（conn!=null）{????
????????????????conn.close（）;??
????????????}?
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
		}
?????????
????}??
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2015-07-24?14:26??00_項目源代碼\
?????文件??????????10??2014-11-19?09:19??00_項目源代碼\Desktop_.ini
?????目錄???????????0??2015-07-24?14:26??00_項目源代碼\shop\
?????目錄???????????0??2015-07-24?14:26??00_項目源代碼\shop\shop\
?????文件?????????623??2015-01-04?16:20??00_項目源代碼\shop\shop\.classpath
?????目錄???????????0??2015-08-27?10:44??00_項目源代碼\shop\shop\.myeclipse\
?????文件?????????285??2015-01-19?09:36??00_項目源代碼\shop\shop\.mymetadata
?????文件????????1747??2015-01-04?15:53??00_項目源代碼\shop\shop\.project
?????目錄???????????0??2015-07-24?14:26??00_項目源代碼\shop\shop\.settings\
?????文件?????????500??2015-01-04?15:01??00_項目源代碼\shop\shop\.settings\.jsdtscope
?????文件?????????684??2015-01-19?10:47??00_項目源代碼\shop\shop\.settings\org.eclipse.core.resources.prefs
?????文件?????????395??2015-01-04?15:01??00_項目源代碼\shop\shop\.settings\org.eclipse.jdt.core.prefs
?????文件?????????450??2015-01-04?15:01??00_項目源代碼\shop\shop\.settings\org.eclipse.wst.common.component
?????文件?????????252??2015-01-04?15:01??00_項目源代碼\shop\shop\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2015-01-04?15:01??00_項目源代碼\shop\shop\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2015-01-04?15:01??00_項目源代碼\shop\shop\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2015-07-24?14:26??00_項目源代碼\shop\shop\WebRoot\
?????目錄???????????0??2015-07-24?14:26??00_項目源代碼\shop\shop\WebRoot\meta-INF\
?????文件??????????36??2015-01-04?15:01??00_項目源代碼\shop\shop\WebRoot\meta-INF\MANIFEST.MF
?????文件????????5512??2015-01-17?20:46??00_項目源代碼\shop\shop\WebRoot\Mycart.jsp
?????文件????????4771??2015-01-17?14:35??00_項目源代碼\shop\shop\WebRoot\Mygood.jsp
?????文件????????4989??2015-01-17?14:34??00_項目源代碼\shop\shop\WebRoot\Mygoods.jsp
?????文件????????1248??2015-01-19?09:50??00_項目源代碼\shop\shop\WebRoot\SB.jsp
?????目錄???????????0??2015-07-24?14:26??00_項目源代碼\shop\shop\WebRoot\WEB-INF\
?????目錄???????????0??2015-07-24?14:26??00_項目源代碼\shop\shop\WebRoot\WEB-INF\classes\
?????目錄???????????0??2015-07-24?14:26??00_項目源代碼\shop\shop\WebRoot\WEB-INF\classes\commons\
?????文件????????1660??2015-01-19?11:17??00_項目源代碼\shop\shop\WebRoot\WEB-INF\classes\commons\DBUtil.class
?????目錄???????????0??2015-07-24?14:26??00_項目源代碼\shop\shop\WebRoot\WEB-INF\classes\dao\
?????文件????????1630??2015-01-19?11:17??00_項目源代碼\shop\shop\WebRoot\WEB-INF\classes\dao\DBUtil.class
?????文件????????3018??2015-01-19?11:17??00_項目源代碼\shop\shop\WebRoot\WEB-INF\classes\dao\GoodTypeDao.class
?????文件?????????610??2015-01-19?11:17??00_項目源代碼\shop\shop\WebRoot\WEB-INF\classes\dao\GoodsDao.class
............此處省略391個文件信息