package?com.zds.atm.db;

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

import?javax.swing.JOptionPane;

public?class?DatabaseManager
{
	Connection?conn?=?null;//?連接對象，當null時失敗
	Statement?st?=?null;//?執行SQL語句的對象
	ResultSet?rs?=?null;//?存放查詢對象的對象

	/*
	?*?實際應用調用該方法
	?*/
	public?DatabaseManager（）
	{
		getConnection（）;
		try
		{
			st?=?conn.createStatement（）;//?連接獲得一個Statement對象
		}?catch?（SQLException?e）
		{
			System.out.println（“創建Statement對象時出錯！“）;
			e.printStackTrace（）;
		}
	}

	/*
	?*?連接數據庫
	?*/
	private?void?getConnection（）
	{
		final?String?DRIVER_NAME?=?“com.mysql.jdbc.Driver“;
		final?String?URL?=?“jdbc:mysql://localhost:3306/atm?characterEncoding=utf-8“;
		final?String?USER_NAME?=?“root“;
		final?String?USER_PASSWORD?=?“admin“;
		try
		{
			Class.forName（DRIVER_NAME）;//?加載驅動
			conn?=?DriverManager.getConnection（URL?USER_NAME?USER_PASSWORD）;
		}?catch?（ClassNotFoundException?e）
		{
			System.out.println（“com.mysql.jdbc.Driver類沒有找到！“）;
			e.printStackTrace（）;
		}?catch?（SQLException?e）
		{
			System.out.println（“創建Connection連接對象時出錯！“）;
			e.printStackTrace（）;
		}
	}

	//?查詢
	public?ResultSet?executeQuery（String?sql）
	{
		try
		{
			rs?=?st.executeQuery（sql）;
		}?catch?（SQLException?e）
		{
			System.out.println（“查詢數據時出錯！“）;
			e.printStackTrace（）;
		}
		return?rs;
	}

	//?增加、刪除、修改
	public?int?executeUpdate（String?sql）
	{
		int?ret?=?-1;
		try
		{
			ret?=?st.executeUpdate（sql）;
		}?catch?（SQLException?e）
		{
			System.out.println（“更新失敗：“?+?sql）;
			e.printStackTrace（）;
		}
		return?ret;
	}

	//?注冊
	public?int?insertAccount（String?accounts?String?name?String?password?String?balance）
	{
		String?sql?=?““;
		int?ret?=?0;
		sql?=?“insert?into?account（accountsnamepasswordbalance）?values（‘“?+?accounts?+?“‘‘“?+?name?+?“‘‘“?+?password?+?“‘‘“?+?balance?+?“‘）“;
		try
		{
			ret?=?executeUpdate（sql）;
		}?catch?（Exception?e）
		{
			e.printStackTrace（）;
		}?finally
		{
			close（）;
		}
		return?ret;
	}

	//?登錄
	public?String[]?doLogin（String?accounts?String?password）
	{
		String[]?end?=?new?String[2];
		DatabaseManager?dbm?=?new?DatabaseManager（）;
		String?sql?=?“select?*?from?account?where?accounts=‘“?+?accounts?+?“‘?and?password=‘“?+?password?+?“‘“;
		System.out.println（sql）;//?sql是否正確
		dbm.executeQuery（sql）;//?查詢數據庫
		ResultSet?res?=?dbm.rs;//?獲取結果集
		try
		{
			if?（res.next（））
			{
				end[0]?=?res.getString（“accounts“）;
				end[1]?=?res.getString（“password“）;
			}
		}?catch?（SQLException?e）
		{
			e.printStackTrace（）;
		}?finally
		{
			dbm.close（）;
		}
		return?end;
	}

	//?余額查詢
	public?double?doBalanceQuery（String?inputAccounts）
	{
		double?end?=?-1;
		DatabaseManager?db?=?new?DatabaseManager（）;
		String?sql?=?“select?balance?from?account?where?accounts=‘“?+?inputAccounts?+?“‘“;
		System.out.println（sql）

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

?????文件????????526??2012-04-19?09:15??ATMjava\.classpath

?????文件????????383??2012-04-16?08:47??ATMjava\.project

?????文件????????629??2012-04-16?08:48??ATMjava\.settings\org.eclipse.jdt.core.prefs

?????文件???????7714??2012-04-24?22:44??ATMjava\bin\com\zds\atm\db\DatabaseManager.class

?????文件????????797??2012-04-24?22:44??ATMjava\bin\com\zds\atm\ervice\AlanceQuery$1.class

?????文件????????743??2012-04-24?22:44??ATMjava\bin\com\zds\atm\ervice\AlanceQuery$2.class

?????文件???????2044??2012-04-24?22:44??ATMjava\bin\com\zds\atm\ervice\AlanceQuery$3.class

?????文件???????2807??2012-04-24?22:44??ATMjava\bin\com\zds\atm\ervice\AlanceQuery.class

?????文件????????721??2012-04-24?22:44??ATMjava\bin\com\zds\atm\ervice\Register$1.class

?????文件????????725??2012-04-24?22:44??ATMjava\bin\com\zds\atm\ervice\Register$2.class

?????文件???????3283??2012-04-24?22:44??ATMjava\bin\com\zds\atm\ervice\Register.class

?????文件????????776??2012-04-24?22:44??ATMjava\bin\com\zds\atm\ervice\Welcome$1.class

?????文件????????737??2012-04-24?22:44??ATMjava\bin\com\zds\atm\ervice\Welcome$2.class

?????文件???????1904??2012-04-24?22:44??ATMjava\bin\com\zds\atm\ervice\Welcome.class

?????文件????????696??2012-04-24?22:44??ATMjava\bin\com\zds\atm\ui\ATMMain$1.class

?????文件????????703??2012-04-24?22:44??ATMjava\bin\com\zds\atm\ui\ATMMain$10.class

?????文件????????698??2012-04-24?22:44??ATMjava\bin\com\zds\atm\ui\ATMMain$2.class

?????文件????????696??2012-04-24?22:44??ATMjava\bin\com\zds\atm\ui\ATMMain$3.class

?????文件????????697??2012-04-24?22:44??ATMjava\bin\com\zds\atm\ui\ATMMain$4.class

?????文件???????1095??2012-04-24?22:44??ATMjava\bin\com\zds\atm\ui\ATMMain$5.class

?????文件???????1169??2012-04-24?22:44??ATMjava\bin\com\zds\atm\ui\ATMMain$6.class

?????文件???????1012??2012-04-24?22:44??ATMjava\bin\com\zds\atm\ui\ATMMain$7.class

?????文件???????1134??2012-04-24?22:44??ATMjava\bin\com\zds\atm\ui\ATMMain$8.class

?????文件???????1098??2012-04-24?22:44??ATMjava\bin\com\zds\atm\ui\ATMMain$9.class

?????文件???????8045??2012-04-24?22:44??ATMjava\bin\com\zds\atm\ui\ATMMain.class

?????文件????????903??2012-04-24?22:44??ATMjava\bin\com\zds\atm\ui\Time1.class

?????文件???????1492??2012-04-22?00:44??ATMjava\db\atm_db.sql

?????文件?????659161??2012-04-20?14:52??ATMjava\img\main.jpg

?????文件?????156229??2012-04-18?12:34??ATMjava\img\main_bg.jpg

?????文件????????516??2012-04-24?23:10??ATMjava\meta-INF\Explain

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