account.java

利用简单的数据库实现ATM柜员机的基本功能（包括存取款

import java.sql.*;

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 guest set pwd='"+newPwd+"' where gid='"+gid+"'");
	return 1;//密码修改成功
	}
	else
	  return -2;//两次输入不同
	}
	else
	  return -1;//旧密码输入错误			 		 		 	
    }
   public boolean checkAccount(String tid) //该方法用于 验证用户ID
   {
     String ssql;     
     ssql="select * from guest 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 guest where pwd='"+tpwd+"' and gid='"+tid+"'";
     if(das.getRowcount(ssql)>0)//合法密码
     {
     	 return true;
     }
     else//非法pwd
     {
     	 return false;
     }
   }


   public float queryBalance(String gid)//该方法用于查询余额
	 {
	 	 ResultSet rs;
	 	 String ssql="select * from guest 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());
	 	 }
	 	 return balance;	 	 
	 }
   public boolean pdcard(String tgid)//判断锁卡情况
   {
	   String ssql;
	   ResultSet rs;
	   ssql="select * from guest where gid='"+tgid+"'";
	   int tp=0;
	   try
	 	 {
	 	 	 rs=das.getData(ssql);
	 	 	 rs.next();
	 	 	 tp=rs.getInt("pd");
	 	 }
	 	 catch(Exception e)
	 	 {
	 	 	 System.out.println(e.toString());
	 	 	 return false;
	 	 }
	 	 if(tp==0)
	 		 return true;
	 	 else
	 		 return false;
   }
   public boolean dealgid(String tgid,int tp)//处理帐户是否锁卡
   {
	   String ssql;
	   if(this.checkAccount(tgid))
	   {
		   if(tp==0)
		   {
			   ssql="update guest set pd='0' where gid='"+tgid+"'";//开卡
			   if(das.exeSql(ssql)) 
			   	 	return true; 			
			  	 else 
			  		 return false; 	   
		   }
		   else if(tp==1)
		   {
			   ssql="update guest set pd='1' where gid='"+tgid+"'";//锁卡
			   if(das.exeSql(ssql)) 
			   	 	return true; 			
			  	 else 
			  		 return false; 
		   }	
	   }	   
	return false;
   }
   public boolean deletegid(String tgid)//删除用户帐户
   {
	   String ssql;
		if(this.checkAccount(tgid))
		{
			ssql="delete from guest where gid='"+tgid+"'";
			if(das.exeSql(ssql)) 
		   	 	return true; 			
		  	 else 
		  		 return false; 
		}
		else return false; 
   }
	public boolean insertmsg(String tgid) //该方法用语添加新帐户
	{
		String ssql;
		if(!this.checkAccount(tgid))
		{
			ssql="insert into guest (gid,pwd,pd,gmoney) values('"+tgid+"','123456','0','0')";
			if(das.exeSql(ssql)) 
		   	 	return true; 			
		  	 else 
		  		 return false; 
		}
		else return false; 
	}
   public boolean saveMoney(String tgid,float money)//该方法用于帐户存款的款数
	{
	String ssql;
	ssql="update guest set gmoney=gmoney+"+money+" where gid='"+tgid+"'";
	if(das.exeSql(ssql)) 
   	 	return true; //存款成功			
  	 else 
  		 return false; //存款未成功 
	}
   public boolean reduceMoney(String tgid,float money)该方法用于帐户扣除取款的款数
   {
     String ssql;
     if(this.queryBalance(tgid)<money) 
    	 return false;     
     ssql="update guest set gmoney=gmoney-"+money+" where gid='"+tgid+"'";
     if(das.exeSql(ssql)) 
    	 return true; //扣款成功			
   	 else 
   		 return false; //扣款未成功    
   }
   
  protected void finalize()
	{
		das.finalize();
	}   
   
}