atmaccount.java

课程设计：ATM Project源码

import java.util.Date;
import java.util.Locale;
import java.sql.*;
import java.text.*;
import java.awt.*;
import javax.swing.*;
import javax.swing.event.*;
import java.io.*;
public class AtmAccount {
	public String CardID;
	public String Name;
	public double Sum;
	public String Licence;
	public boolean State;
	public Date CreateDate;
	public Date OutDate;
	public boolean LostFlag;	
	public char[] Password;
	Component f;
    Locale CurLocale=new Locale("zh","CN");
	NumberFormat curformater=NumberFormat.getCurrencyInstance(CurLocale);
    SimpleDateFormat DateFormatter=new SimpleDateFormat("yyyy/MM/dd");
   
  public AtmAccount(Component F)
  {
  	  f=F;
  }
  public void UpdateNew() throws SQLException,ClassNotFoundException
  { 
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    Connection connect=DriverManager.getConnection("jdbc:odbc:accounts","","");
    Statement odbc=connect.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
  	String cmd;
  	cmd=new String("INSERT INTO Accounts"+"(CardID,Name,Sum,Licence,State,CreateDate,OutDate,LostFlag,Password)"+
  	"VALUES('"+CardID+"','"+Name+"',"+String.valueOf(Sum)+",'"+Licence+"',false,'"+DateFormatter.format(CreateDate)+"','"+DateFormatter.format(OutDate)+"',false,'"+String.valueOf(Password)+"')");
  	System.out.println(cmd);
  	odbc.executeUpdate(cmd);
   	odbc.close();
  	connect.close();
  	ReadAtmID CardWriter = new ReadAtmID(f);
  	CardWriter.WriteCardID(Long.parseLong((CardID)));
  	System.out.println("卡已写入磁盘，卡号:"+CardWriter.ReadCardID());
  }
  public String Desposit(String AtmID,double Cash,String Password) throws SQLException,ClassNotFoundException
  { 
    String tmp;
    System.out.println("Deposit");
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    Connection connect=DriverManager.getConnection("jdbc:odbc:accounts","","");
    Statement odbc=connect.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
    
  	
  	System.out.println("SELECT Password FROM Accounts WHERE CardID='"+AtmID+"'");
  	ResultSet r = odbc.executeQuery("SELECT Password FROM Accounts WHERE CardID='"+AtmID+"'");
  	System.out.println(r.getString("Password"));
  	tmp=new String(r.getString("Password"));
   	odbc.close();
  	connect.close();
  	return tmp;
  	
  }
  
  
  
}