package?com.jmm.Connection;

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

public?class?atmConnection?{
	private?static?final?String?DriverName?=?“com.mysql.jdbc.Driver“;
	private?static?final?String?UserName?=?“root“;
	private?static?final?String?PassWord?=?“root“;
	private?static?final?String?URL?=?“jdbc:mysql://localhost:3306/atmdb?useUnicode=true&characterEncoding=utf8“;

	private?static?Connection?connection?=?null;
	private?static?PreparedStatement?ps?=?null;
	private?static?ResultSet?rs?=?null;

	//?打開數據庫
	public?static?Connection?getconnection（）?throws?SQLException
			ClassNotFoundException?{
		Class.forName（DriverName）;
		connection?=?DriverManager.getConnection（URL?UserName?PassWord）;
		return?connection;
	}

	//?關閉數據庫連接
	public?static?void?closedb（）?throws?SQLException?{
		if?（rs?!=?null）?{
			rs.close（）;
		}
		if?（ps?!=?null）?{
			ps.close（）;
		}
		if?（connection?!=?null）?{
			connection.close（）;
		}
	}

}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-03-23?20:10??atm取款機\
?????目錄???????????0??2017-05-09?00:22??atm取款機\atm\
?????文件????????1187??2016-06-07?11:29??atm取款機\atm\.classpath
?????文件????????1328??2016-06-01?18:05??atm取款機\atm\.project
?????目錄???????????0??2017-05-09?00:22??atm取款機\atm\.settings\
?????文件?????????522??2016-06-01?18:04??atm取款機\atm\.settings\.jsdtscope
?????文件??????????66??2016-06-01?18:13??atm取款機\atm\.settings\org.eclipse.core.resources.prefs
?????文件?????????598??2016-06-07?11:19??atm取款機\atm\.settings\org.eclipse.jdt.core.prefs
?????文件?????????468??2016-06-01?18:04??atm取款機\atm\.settings\org.eclipse.wst.common.component
?????文件?????????414??2016-06-01?18:04??atm取款機\atm\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2016-06-01?18:04??atm取款機\atm\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2016-06-01?18:04??atm取款機\atm\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2017-05-09?00:22??atm取款機\atm\src\
?????目錄???????????0??2017-05-09?00:22??atm取款機\atm\src\com\
?????目錄???????????0??2017-05-09?00:22??atm取款機\atm\src\com\jmm\
?????目錄???????????0??2017-05-09?00:22??atm取款機\atm\src\com\jmm\Connection\
?????文件????????1105??2016-06-07?17:33??atm取款機\atm\src\com\jmm\Connection\atmConnection.java
?????目錄???????????0??2017-05-09?00:22??atm取款機\atm\src\com\jmm\Dao\
?????文件????????2559??2016-06-21?22:32??atm取款機\atm\src\com\jmm\Dao\atmDao.java
?????目錄???????????0??2017-05-09?00:22??atm取款機\atm\src\com\jmm\Entity\
?????文件????????2296??2016-06-02?22:05??atm取款機\atm\src\com\jmm\Entity\atmUserEntity.java
?????目錄???????????0??2017-05-09?00:22??atm取款機\atm\src\com\jmm\servlet\
?????文件?????????929??2016-06-08?00:56??atm取款機\atm\src\com\jmm\servlet\atmexitServlet.java
?????文件????????3717??2016-06-08?00:35??atm取款機\atm\src\com\jmm\servlet\atmgaimiServlet.java
?????文件????????3088??2016-06-07?21:45??atm取款機\atm\src\com\jmm\servlet\atmqukuanServlet.java
?????文件????????2062??2016-06-07?18:02??atm取款機\atm\src\com\jmm\servlet\atmServlet.java
?????目錄???????????0??2017-05-09?00:22??atm取款機\atm\WebRoot\
?????文件????????1482??2018-03-23?19:57??atm取款機\atm\WebRoot\chaxun.jsp
?????目錄???????????0??2017-05-09?00:22??atm取款機\atm\WebRoot\css\
?????文件?????????919??2016-06-02?23:42??atm取款機\atm\WebRoot\css\indexcss.css
?????文件????????1137??2016-06-08?00:55??atm取款機\atm\WebRoot\exit.jsp
............此處省略44個文件信息