package?cn.ebuy.dao;

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

?

public?class?baseDAO?{
	private?final?String?DRIVERCLASS?=?“com.mysql.jdbc.Driver“;

	private?final?String?URL?=?“jdbc:mysql://localhost:3306/ebuy?useUnicode=true&characterEncoding=utf-8“;

	private?final?String?UNAME?=?“root“;

	private?final?String?UPWD?=?“admin123“;

	public?static?void?main（String[]?args）?throws?Exception?{
		System.out.println（new?baseDAO（）.getConnection（））;
	}

	/**
	?*?獲取MySQL數據庫連接
	?*?
	?*?@return
	?*?@throws?Exception
	?*/
	public?Connection?getConnection（）?throws?Exception?{
		Connection?conn?=?null;
		try?{
			Class.forName（DRIVERCLASS）;
			conn?=?DriverManager.getConnection（URL?UNAME?UPWD）;
		}?catch?（Exception?ex）?{
			throw?ex;
		}
		return?conn;
	}

	/**
	?*?關閉數據庫連接
	?*?
	?*?@param?rs
	?*?@param?ps
	?*?@param?conn
	?*?@throws?Exception
	?*/
	public?void?closeAll（ResultSet?rs?PreparedStatement?ps?Connection?conn）?throws?Exception?{
		try?{
			if?（rs?!=?null）?{
				rs.close（）;
			}
			if?（ps?!=?null）?{
				ps.close（）;
			}
			if?（conn?!=?null）?{
				conn.close（）;
			}
		}?catch?（Exception?ex）?{
			throw?ex;
		}
	}

}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件????????7224??2021-06-22?18:13??20210622162247.sql
?????目錄???????????0??2021-07-02?22:51??ebuy\
?????文件?????????661??2021-06-21?12:46??ebuy\.classpath
?????文件?????????904??2021-06-21?08:38??ebuy\.project
?????目錄???????????0??2021-07-02?22:51??ebuy\.settings\
?????文件?????????567??2021-06-21?08:38??ebuy\.settings\.jsdtscope
?????文件?????????180??2021-06-22?14:46??ebuy\.settings\org.eclipse.core.resources.prefs
?????文件?????????358??2021-06-21?08:38??ebuy\.settings\org.eclipse.jdt.core.prefs
?????文件?????????464??2021-06-21?08:38??ebuy\.settings\org.eclipse.wst.common.component
?????文件?????????343??2021-06-21?08:38??ebuy\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2021-06-21?08:38??ebuy\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2021-06-21?08:38??ebuy\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2021-07-02?22:51??ebuy\WebContent\
?????目錄???????????0??2021-07-02?22:51??ebuy\WebContent\meta-INF\
?????文件??????????39??2021-06-21?08:38??ebuy\WebContent\meta-INF\MANIFEST.MF
?????目錄???????????0??2021-07-02?22:51??ebuy\WebContent\WEB-INF\
?????目錄???????????0??2021-07-02?22:51??ebuy\WebContent\WEB-INF\lib\
?????文件???????62983??2021-06-21?12:53??ebuy\WebContent\WEB-INF\lib\activation-1.1.jar
?????文件??????353793??2021-06-21?12:40??ebuy\WebContent\WEB-INF\lib\commons-codec-1.15.jar
?????文件??????414240??2021-06-21?10:29??ebuy\WebContent\WEB-INF\lib\jstl-1.2.jar
?????文件??????521157??2021-06-21?12:37??ebuy\WebContent\WEB-INF\lib\mail-1.4.7.jar
?????文件??????566623??2021-06-21?08:53??ebuy\WebContent\WEB-INF\lib\mysql-connector-java-5.1.0-bin.jar
?????文件?????????650??2021-06-21?15:24??ebuy\WebContent\WEB-INF\web.xml
?????目錄???????????0??2021-07-02?22:51??ebuy\WebContent\css\
?????文件???????13418??2021-06-21?09:19??ebuy\WebContent\css\style.css
?????文件????????2348??2021-06-22?11:12??ebuy\WebContent\guestbook.jsp
?????文件????????1864??2021-06-21?15:35??ebuy\WebContent\header.jsp
?????目錄???????????0??2021-07-02?22:51??ebuy\WebContent\images\
?????文件????????6538??2021-06-21?09:19??ebuy\WebContent\images\bg.png
?????文件????????1376??2021-06-21?09:19??ebuy\WebContent\images\logo.gif
?????目錄???????????0??2021-07-02?22:51??ebuy\WebContent\images\product\
............此處省略120個文件信息