package?com.shao.DAO;

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

import?com.mysql.jdbc.PreparedStatement;
import?com.shao.model.user;



public?class?ExecuteSQL?{
	protected?static?String?dbClassName?=?“com.mysql.jdbc.Driver“;
	protected?static?String?dbUrl?=?“jdbc:mysql://localhost:3306/atm“;
	protected?static?String?dbUser?=?“root“;
	protected?static?String?dbPwd?=?“root“;
	private?static?Connection?conn?=?null;
	
	private?ExecuteSQL（）?{
		try?{
			if?（conn?==?null）?{
				Class.forName（dbClassName）.newInstance（）;
				conn?=?DriverManager.getConnection（dbUrl?dbUser?dbPwd）;
			}
			else
				return;
		}?catch?（Exception?ee）?{
			ee.printStackTrace（）;
		}

	}
	
	//重寫executeQuer方法
	//返回ResultSet結果集
	private?static?ResultSet?executeQuery（String?sql）?{
		try?{
			if（conn==null）
			new?ExecuteSQL（）;
			return?conn.createStatement（）.executeQuery（sql）;//ResultSet.TYPE_SCROLL_SENS

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

?????文件????????418??2017-06-17?14:07??ATM_MySql\.classpath

?????文件????????385??2017-06-16?21:06??ATM_MySql\.project

?????文件????????598??2017-06-16?21:06??ATM_MySql\.settings\org.eclipse.jdt.core.prefs

?????文件????????988??2017-06-20?19:07??ATM_MySql\atm.sql

?????文件???????4005??2017-06-20?16:38??ATM_MySql\bin\com\shao\DAO\ExecuteSQL.class

?????文件????????781??2017-06-19?21:09??ATM_MySql\bin\com\shao\iframe\atmframe$1.class

?????文件???????1649??2017-06-19?21:09??ATM_MySql\bin\com\shao\iframe\atmframe$2.class

?????文件????????923??2017-06-19?21:09??ATM_MySql\bin\com\shao\iframe\atmframe$3.class

?????文件????????925??2017-06-19?21:09??ATM_MySql\bin\com\shao\iframe\atmframe$4.class

?????文件????????925??2017-06-19?21:09??ATM_MySql\bin\com\shao\iframe\atmframe$5.class

?????文件???????2287??2017-06-19?21:09??ATM_MySql\bin\com\shao\iframe\atmframe.class

?????文件???????2380??2017-06-20?15:35??ATM_MySql\bin\com\shao\iframe\depositframe$1.class

?????文件????????939??2017-06-20?15:35??ATM_MySql\bin\com\shao\iframe\depositframe$2.class

?????文件???????2655??2017-06-20?15:35??ATM_MySql\bin\com\shao\iframe\depositframe.class

?????文件????????761??2017-06-20?15:33??ATM_MySql\bin\com\shao\iframe\Loginframe$1.class

?????文件???????2109??2017-06-20?15:33??ATM_MySql\bin\com\shao\iframe\Loginframe$loginAction.class

?????文件????????825??2017-06-20?15:33??ATM_MySql\bin\com\shao\iframe\Loginframe$signAction.class

?????文件???????3239??2017-06-20?15:33??ATM_MySql\bin\com\shao\iframe\Loginframe.class

?????文件???????2152??2017-06-20?15:34??ATM_MySql\bin\com\shao\iframe\Signframe$OKButtonAction.class

?????文件???????2831??2017-06-20?15:34??ATM_MySql\bin\com\shao\iframe\Signframe.class

?????文件???????3216??2017-06-20?15:34??ATM_MySql\bin\com\shao\iframe\transferframe$1.class

?????文件???????2867??2017-06-20?15:34??ATM_MySql\bin\com\shao\iframe\transferframe.class

?????文件???????2589??2017-06-20?15:35??ATM_MySql\bin\com\shao\iframe\withdrawframe$1.class

?????文件????????945??2017-06-20?15:35??ATM_MySql\bin\com\shao\iframe\withdrawframe$2.class

?????文件???????2652??2017-06-20?15:35??ATM_MySql\bin\com\shao\iframe\withdrawframe.class

?????文件????????923??2017-06-20?16:38??ATM_MySql\bin\com\shao\model\user.class

?????文件??????46825??2017-06-16?21:37??ATM_MySql\bin\signButton.jpg

?????文件???????3190??2017-06-20?16:38??ATM_MySql\src\com\shao\DAO\ExecuteSQL.java

?????文件???????2985??2017-06-19?21:09??ATM_MySql\src\com\shao\iframe\atmframe.java

?????文件???????3542??2017-06-20?15:35??ATM_MySql\src\com\shao\iframe\depositframe.java

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