/*-------------------- ATM取款模擬Java實現-----------------
 *--------------------- write by 223小組-------------------
 *---------------------------2006.4------------------------
 *
 *------ Account(用戶帳戶)類：包含用戶信息的驗證、余額查詢和扣錢等方法
 */

import java.sql.*;
import java.io.*;


public class Account 
{
	
	dataAccess das=new dataAccess();
//----------------------------------------------
// 該方法用于 修改密碼
//----------------------------------------------

   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 atm set pwd='"+newPwd+"' where gid='"+gid+"'");
			 			return 1;//密碼修改成功
			 		}
			 		else
			 		{
			 			return -2;//兩次輸入不同
			 		} 		
			 		
			 }
			 else
			 {
			 		return -1;//舊密碼輸入錯誤
			 }			 		 	
	 }
   
//----------------------------------------------
//該方法用于 驗證用戶ID
//----------------------------------------------

   public boolean checkAccount(String tid) 
   {
     String ssql;     
     ssql="select * from atm where gid='"+tid+"'";     
     if(das.getRowcount(ssql)>0)//合法ID
     {
     	 return true;
     }
     else//非法ID
     {
     	 return false;
     }
   }
   
//----------------------------------------------
//該方法用于 驗證用戶密碼
//----------------------------------------------

   public boolean checkPwd(String tid,String tpwd) 
   {
     String ssql;
     ssql="select * from atm where pwd='"+tpwd+"' and gid='"+tid+"'";
     if(das.getRowcount(ssql)>0)//合法pwd
     {
     	 return true;
     }
     else//非法pwd
     {
     	 return false;
     }
   }
//----------------------------------------------
//該方法用于查詢余額
//----------------------------------------------

	 public float queryBalance(String gid)
	 {
	 	 ResultSet rs;
	 	 String ssql="select * from atm where gid='"+gid+"'";
	 	 float balance=0;
	 	 try
	 	 {
	 	 	 rs=das.getData(ssql);
	 	 	 rs.next();
	 	 	 balance=rs.getFloat("gmoney");
	 	 }
	 	 catch(Exception e)
	 	 {
	 	 	 System.out.println(e.toString());
	 	 }
	 	 finally
	 	 {
	 	 	 return balance;
	 	 }
	 	 
	 }
	 
//----------------------------------------------
//該方法用于帳戶扣除取款數
//----------------------------------------------

   public boolean reduceMoney(String tgid,float money) 
   {
     String ssql;
     if(this.queryBalance(tgid)<money) return false;     
     ssql="update atm set gmoney=gmoney-"+money+" where gid='"+tgid+"'";
     if(das.exeSql(ssql)) return true; //扣款成功			
   	 else return false; //扣款未成功    
   }
   
  protected void finalize()//析構函數
	{
		das.finalize();
	}   
   
}