package?cn.edu.dao;

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

public?class?DBConnect?{
	
	private?static?String?driverName=“com.mysql.jdbc.Driver“;	//驅動程序名
	private?static?String?userName=“root“;	//數據庫用戶名
	private?static?String?userPwd=“123456“;	//密碼
	private?static?String?dbName=“goodsinfo“;	//數據庫名
	public?static?Connection?getDBconnection（）{
		String?url1=“jdbc:mysql://localhost/“+dbName;
		String?url2=“?user=“+userName+“&password=“+userPwd;
		String?url3=“&useUnicode=true&characterEncoding=UTF-8“;
		String?url=url1+url2+url3;
		Connection?con=null;
		try?{
			Class.forName（driverName）;//加載驅動
			con=DriverManager.getConnection（url）;//獲取數據庫連接對象
		}?catch?（ClassNotFoundException?|?SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}?
		return?con;
	}
	
	public?static?void?closeDB（Connection?conPreparedStatement?pstmResultSet?rs）{
		
			try?{
				if（rs!=null）rs.close（）;
				if（pstm!=null）pstm.close（）;
				if（con!=null）con.close（）;
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
			}
	}
}

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

?????文件???????1187??2018-01-02?15:16??GoodsMeg1.0\.classpath

?????文件???????1061??2018-01-02?14:09??GoodsMeg1.0\.project

?????文件????????564??2018-01-02?14:09??GoodsMeg1.0\.settings\.jsdtscope

?????文件????????139??2018-01-02?17:11??GoodsMeg1.0\.settings\org.eclipse.core.resources.prefs

?????文件????????364??2018-01-02?14:09??GoodsMeg1.0\.settings\org.eclipse.jdt.core.prefs

?????文件????????492??2018-01-02?14:09??GoodsMeg1.0\.settings\org.eclipse.wst.common.component

?????文件????????414??2018-01-02?14:09??GoodsMeg1.0\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2018-01-02?14:09??GoodsMeg1.0\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2018-01-02?14:09??GoodsMeg1.0\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????1264??2018-01-02?14:43??GoodsMeg1.0\src\cn\edu\dao\DBConnect.java

?????文件???????3776??2018-01-05?09:06??GoodsMeg1.0\src\cn\edu\dao\GoodsDao.java

?????文件???????2064??2018-01-04?17:09??GoodsMeg1.0\src\cn\edu\dao\UserDao.java

?????文件???????1198??2018-01-02?14:38??GoodsMeg1.0\src\cn\edu\domain\GoodsInfo.java

?????文件????????995??2018-01-02?14:42??GoodsMeg1.0\src\cn\edu\domain\UsersInfo.java

?????文件???????1178??2018-01-03?10:29??GoodsMeg1.0\src\cn\edu\service\GoodsService.java

?????文件????????864??2018-01-04?17:10??GoodsMeg1.0\src\cn\edu\service\UserService.java

?????文件???????1754??2018-01-04?18:22??GoodsMeg1.0\src\cn\edu\servlet\addgoodsServlet.java

?????文件???????1790??2018-01-04?17:41??GoodsMeg1.0\src\cn\edu\servlet\alteruserServlet.java

?????文件???????1537??2018-01-03?09:58??GoodsMeg1.0\src\cn\edu\servlet\deletgoodsServlet.java

?????文件???????1624??2018-01-04?17:43??GoodsMeg1.0\src\cn\edu\servlet\loginServlet.java

?????文件???????1716??2018-01-03?08:43??GoodsMeg1.0\src\cn\edu\servlet\resgisterServlet.java

?????文件???????1838??2018-01-04?18:25??GoodsMeg1.0\src\cn\edu\servlet\updategoodsServlet.java

?????文件???????2095??2018-01-04?17:21??GoodsMeg1.0\src\filter\SetCharacterEncodingFilter.java

?????文件???????2632??2018-01-03?09:32??GoodsMeg1.0\WebRoot\AddGoods.jsp

?????文件???????2872??2018-01-03?10:10??GoodsMeg1.0\WebRoot\AlterGoods.jsp

?????文件???????2853??2018-01-04?17:58??GoodsMeg1.0\WebRoot\AlterUser.jsp

?????文件????????526??2018-01-02?16:15??GoodsMeg1.0\WebRoot\css\goods.css

?????文件????????665??2018-01-02?14:12??GoodsMeg1.0\WebRoot\css\login.css

?????文件???????1363??2018-01-02?14:12??GoodsMeg1.0\WebRoot\css\main.css

?????文件???????2199??2018-01-02?16:04??GoodsMeg1.0\WebRoot\css\normalize.min.css

............此處省略60個文件信息