package?com.sweet.homework.atm;

import?java.sql.*;

/**?
?*?@ClassName:?Account?
?*?@Description:封裝satm系統(tǒng)的數(shù)據(jù)操作
?*?@author?tianhao?
?*?@date?2016年4月1日?下午8:30:46?
?*??
?*/
public?class?Account?{

	Database?das?=?new?Database（）;

	/**
	?*?@Author?tianhao
	?*?@Time?2016年4月1日?下午8:28:46
	?*?@title:?changePwd
	?*?@Description:修改密碼
	?*?@param?@param
	?*????????????gid
	?*?@param?@param
	?*????????????pwd
	?*?@param?@param
	?*????????????oldPwd
	?*?@param?@param
	?*????????????newPwd
	?*?@param?@param
	?*????????????newPwd2
	?*?@param?@return
	?*?@return?int
	?*/
	public?int?changePwd（String?gid?String?pwd?String?oldPwd?String?newPwd?String?newPwd2）?{
		if?（newPwd.length（）?==?0?||?newPwd.trim（）.equals（““））
			return?-3;//?新密碼不能為空
		else?if?（oldPwd.equals（pwd））?{
			if?（newPwd.equals（newPwd2））?{
				das.exeSql（“update?card_t?set?password=‘“?+?newPwd?+?“‘?where?card_number=‘“?+?gid?+?“‘“）;
				return?1;//?密碼修改成功
			}?else?{
				return?-2;//?兩次輸入不同
			}

		}?else?{
			return?-1;//?舊密碼輸入錯(cuò)誤
		}
	}

	/**
	?*?@Author?tianhao
	?*?@Time?2016年4月1日?下午8:29:09
	?*?@title:?transfer
	?*?@Description:轉(zhuǎn)賬
	?*?@param?@param
	?*????????????gid
	?*?@param?@param
	?*????????????tran_account
	?*?@param?@param
	?*????????????tran_RMB
	?*?@param?@return
	?*?@return?float
	?*/
	public?float?transfer（String?gid?String?tran_account?String?tran_RMB）?{
		float?rs?rs1?backrs?=?1;
		String?accsql?=?“select?*?from?card_t?where?card_number=‘“?+?tran_account?+?“‘“;
		//?String?gidsql=“select?*?from?guest?where?gid=‘“+gid+“‘“;
		rs?=?das.getRowcount（accsql）;
		rs1?=?this.queryBalance（gid）;
		if?（tran_RMB.length（）?==?0?||?tran_RMB.trim（）.equals（““）?||?tran_account.length（）?==?0
				||?tran_account.trim（）.equals（““））
			backrs?=?-1;?//?輸入信息不能為空
		//?return?rs;
		else?if?（rs?==?0）
			backrs?=?-2;?//?系統(tǒng)里沒(méi)有該帳戶(hù)信息
		else?if?（rs1?			backrs?=?-3;
		return?backrs;
	}

	/**
	?*?@Author?tianhao
	?*?@Time?2016年4月1日?下午8:29:22
	?*?@title:?checkAccount
	?*?@Description:登錄驗(yàn)證
	?*?@param?@param
	?*????????????tid
	?*?@param?@return
	?*?@return?boolean
	?*/
	public?boolean?checkAccount（String?tid）?{
		String?ssql;
		ssql?=?“select?*?from?card_t?where?card_number=‘“?+?tid?+?“‘“;
		if?（das.getRowcount（ssql）?>?0）//?合法ID
		{
			return?true;
		}?else//?非法ID
		{
			return?false;
		}
	}

	/**
	?*?@Author?tianhao
	?*?@Time?2016年4月1日?下午8:29:36
	?*?@title:?checkPwd
	?*?@Description:登錄驗(yàn)證
	?*?@param?@param
	?*????????????tid
	?*?@param?@param
	?*????????????tpwd
	?*?@param?@return
	?*?@return?boolean
	?*/
	public?boolean?checkPwd（String?tid?String?tpwd）?{
		String?ssql;
		ssql?=?“select?*?from?card_t?where?password=‘“?+?tpwd?+?“‘?and?card_number=‘“?+?tid?+?“‘“;
		if?（das.getRowcount（ssql）?>?0）//?合法pwd
		{
			return?true;
		}?else//?非法pwd
		{
			return?false;
		}
	}

	/**
	?*?@Author?tianhao
	?*?@Time?2016年4月1日?下午8:29:46
	?*?@title:?queryBalance
	?*?@Descr

?屬性????????????大小?????日期????時(shí)間???名稱(chēng)
-----------?---------??----------?-----??----
?????文件?????????384??2016-04-10?16:13??SATM\.classpath
?????文件?????????380??2016-04-09?09:35??SATM\.project
?????目錄???????????0??2016-04-10?11:17??SATM\bin\
?????目錄???????????0??2016-04-10?11:17??SATM\bin\com\
?????目錄???????????0??2016-04-10?11:17??SATM\bin\com\sweet\
?????目錄???????????0??2016-04-10?11:17??SATM\bin\com\sweet\homework\
?????目錄???????????0??2016-04-11?00:02??SATM\bin\com\sweet\homework\atm\
?????文件????????3834??2016-04-10?23:50??SATM\bin\com\sweet\homework\atm\Account.class
?????文件?????????661??2016-04-10?23:10??SATM\bin\com\sweet\homework\atm\Atm.class
?????文件????????1369??2016-04-11?00:01??SATM\bin\com\sweet\homework\atm\atm.sql
?????文件????????2516??2016-04-10?23:10??SATM\bin\com\sweet\homework\atm\Database.class
?????文件?????????728??2016-04-10?23:51??SATM\bin\com\sweet\homework\atm\Screen$1.class
?????文件?????????825??2016-04-10?23:51??SATM\bin\com\sweet\homework\atm\Screen$2.class
?????文件?????????829??2016-04-10?23:51??SATM\bin\com\sweet\homework\atm\Screen$3.class
?????文件???????18501??2016-04-10?23:51??SATM\bin\com\sweet\homework\atm\Screen.class
?????目錄???????????0??2016-04-11?00:02??SATM\bin\com\sweet\homework\atm\test\
?????文件????????1704??2016-04-11?00:01??SATM\bin\com\sweet\homework\atm\test\TestAccount.class
?????目錄???????????0??2016-04-10?11:17??SATM\lib\
?????文件??????985600??2016-04-09?09:40??SATM\lib\mysql-connector-java-5.1.37.jar
?????目錄???????????0??2016-04-10?11:17??SATM\src\
?????目錄???????????0??2016-04-10?11:17??SATM\src\com\
?????目錄???????????0??2016-04-10?11:17??SATM\src\com\sweet\
?????目錄???????????0??2016-04-10?11:17??SATM\src\com\sweet\homework\
?????目錄???????????0??2016-04-11?00:02??SATM\src\com\sweet\homework\atm\
?????文件????????4873??2016-04-10?23:50??SATM\src\com\sweet\homework\atm\Account.java
?????文件?????????364??2016-04-10?11:16??SATM\src\com\sweet\homework\atm\Atm.java
?????文件????????1369??2016-04-11?00:01??SATM\src\com\sweet\homework\atm\atm.sql
?????文件????????2542??2016-04-10?11:17??SATM\src\com\sweet\homework\atm\Database.java
?????文件???????23214??2016-04-10?23:51??SATM\src\com\sweet\homework\atm\Screen.java
?????目錄???????????0??2016-04-11?00:02??SATM\src\com\sweet\homework\atm\test\
?????文件????????1329??2016-04-11?00:01??SATM\src\com\sweet\homework\atm\test\TestAccount.java
............此處省略0個(gè)文件信息