keep.java

ATM机具有存款、取款、查询结余、打印凭条、修改密码功能。

package atm;
import javax.swing.*;
import java.awt.*;
import com.borland.jbcl.layout.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.Font;
import java.awt.BorderLayout;
import java.sql.*;
/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2008</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class Keep extends JFrame{
    String strSql1="";
  String database_username="";
  String database_password="";
    int ab;
    int bb;
    int s1;
    int m;
    String yy;



    public Keep() {
        super();
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    public static void main(String[] args) {
        Keep keep = new Keep();
    }

    private void jbInit() throws Exception {
        jPanel1.setLayout(xYLayout1);
        jLabel2.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        jLabel2.setForeground(Color.white);
        jLabel2.setText("请输入所要存入的钱数：");
        jPanel1.setBackground(new Color(49, 106, 183));
        jTextField1.addActionListener(new Keep_jTextField1_actionAdapter(this));
        jButton1.setText("确定");
        jButton1.addActionListener(new Keep_jButton1_actionAdapter(this));
        jButton2.setText("取消");
        jButton2.addActionListener(new Keep_jButton2_actionAdapter(this));
        jPanel1.add(jLabel2, new XYConstraints(85, 133, -1, -1));
        jPanel1.add(jTextField1, new XYConstraints(102, 197, 164, 26));
        jPanel1.add(jButton2, new XYConstraints(235, 326, -1, -1));
        jPanel1.add(jButton1, new XYConstraints(86, 326, -1, -1));
        this.getContentPane().add(jPanel1, java.awt.BorderLayout.CENTER);
        setSize(450,550);
        setVisible(true);


    }

    JPanel jPanel1 = new JPanel();
    XYLayout xYLayout1 = new XYLayout();
    JLabel jLabel2 = new JLabel();
    JTextField jTextField1 = new JTextField();
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();

    public void jTextField1_actionPerformed(ActionEvent e) {

    }

    public void jButton1_actionPerformed(ActionEvent e) {
               ResultSet rs = null;
               String url = "jdbc:odbc:atm";
               Tbalance tt=new Tbalance();
               String er=(new java.util.Date()).toLocaleString();
         try {
              String s = jTextField1.getText();
              if(s.equals("")){
           JOptionPane.showMessageDialog(this,"输入为空,请重新输入！");
   }

              userlogin u=new userlogin();
              yy=u.s;

              s1=Integer.parseInt(s);
              bb=tt.aa;
              ab=bb+s1;
              Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
              Connection dbConn = DriverManager.getConnection(url,database_username, database_password);
              Statement stmt = dbConn.createStatement();
              strSql1 = "insert into transinfo(transdate,cardid,transtype,transmoney)"+"values('"+er+"','"+yy+"','存款','"+s+"')";



         if(s1%100!=0){
              JOptionPane.showMessageDialog(this,"本机只可存入100元的整数倍！");
              jTextField1.setText("") ;
         }
          else{
              JOptionPane.showMessageDialog(this,"存款成功，交易金额为'"+s+"'元");
              int ee= stmt.executeUpdate(strSql1);
              jTextField1.setText("") ;
              balance2();
              moneySelect2();
              moneyUpdate2();
            }
          }catch(Exception ee){
              System.out.println(ee.getMessage());
             }


          }
  //存款后刷新银行卡内的钱数
    public void balance2(){
        try{
             String url = "jdbc:odbc:atm";
             Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
             ResultSet rs = null;
             Connection dbConn = DriverManager.getConnection(url,database_username, database_password);
             Statement stmt = dbConn.createStatement();
             strSql1="update cardinfo set balance='"+ab+"' where cardid='"+yy+"'";
             int ee= stmt.executeUpdate(strSql1);
           }catch(Exception ex){
                ex.getMessage();
        }
    }
    //提取提款机内的总钱数
  public void moneySelect2(){
      try{
      String url = "jdbc:odbc:atm";
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      ResultSet rs = null;
      Connection dbConn = DriverManager.getConnection(url,database_username, database_password);
      Statement stmt = dbConn.createStatement();
      strSql1="select * from atmMoney where id='1'";
      rs= stmt.executeQuery(strSql1);
      while(rs.next()){
          m = Integer.parseInt(rs.getString(2));
      }
     }catch(Exception ex){
         ex.getMessage();
     }
  }
//刷新存款后提款机内的钱数
   public void moneyUpdate2(){
       try{
             String url = "jdbc:odbc:atm";
             Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
             ResultSet rs = null;
             Connection dbConn = DriverManager.getConnection(url,database_username, database_password);
             Statement stmt = dbConn.createStatement();
             int m1=m+s1;
             strSql1="update atmMoney set money='"+m1+"' where id='1'";
             int ee= stmt.executeUpdate(strSql1);
             rs.close();
             stmt.close();
             dbConn.close();
         }catch(Exception ex){
           ex.getMessage();
       }
  }
    public void jButton2_actionPerformed(ActionEvent e) {
             setVisible(false);
           Function f=new Function();
    }
}
class Keep_jButton2_actionAdapter implements ActionListener {
    private Keep adaptee;
    Keep_jButton2_actionAdapter(Keep adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.jButton2_actionPerformed(e);
    }
}
class Keep_jButton1_actionAdapter implements ActionListener {
    private Keep adaptee;
    Keep_jButton1_actionAdapter(Keep adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.jButton1_actionPerformed(e);
    }
}
class Keep_jTextField1_actionAdapter implements ActionListener {
    private Keep adaptee;
    Keep_jTextField1_actionAdapter(Keep adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.jTextField1_actionPerformed(e);
    }
}