changeaccount.java~39~

银行系统中储蓄模块的实现

package chuxu;
import javax.swing.*;
import java.awt.BorderLayout;
import java.awt.Rectangle;
import java.awt.Dimension;
import java.awt.Font;
import javax.swing.border.TitledBorder;
import java.awt.event.ActionEvent;
import java.awt.Point;
import java.awt.event.ActionListener;
import java.awt.SystemColor;
import java.sql.ResultSet;
import Database.DbConnector;
import Database.SqlController;
import Error.ErrorDlg;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class ChangeAccount extends JFrame{

    JPanel contentPane;
 JPanel chuxumenu;
 JMenuBar jMenuBar1 = new JMenuBar();
 JMenu jMenuFile = new JMenu();
 JMenuItem jMenuFileExit = new JMenuItem();
 JMenu jMenuHelp = new JMenu();
 JMenuItem jMenuHelpAbout = new JMenuItem();
 JToolBar jToolBar = new JToolBar();
 JMenuItem jMenuItem1 = new JMenuItem();
 TitledBorder titledBorder1 = new TitledBorder("");

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

    private void jbInit() throws Exception {
        this.getContentPane().setLayout(null);
        setSize(new Dimension(500, 400));
        setTitle("SE 银行--储蓄--转帐");

        contentPane = (JPanel) getContentPane();
     jMenuFileExit.setText("离开");
     jMenuFileExit.addActionListener(new ChangeAccount_jMenuFileExit_ActionAdapter(this));
     jMenuHelp.setText("Help");
     jMenuHelpAbout.setText("About");
     jMenuHelpAbout.addActionListener(new ChangeAccount_jMenuHelpAbout_ActionAdapter(this));
     jToolBar.setBounds(new Rectangle(0, 0, 13, 2));

     jMenuFile.setText("选项");
     jMenuItem1.setText("注销");
        jButton1.setBounds(new Rectangle(28, 288, 85, 29));
        jButton1.setText("确定");
        jButton1.addActionListener(new ChangeAccount_jButton1_actionAdapter(this));
        jMenuBar1.add(jMenuFile);
     jMenuBar1.add(jMenuHelp);
     jMenuHelp.add(jMenuHelpAbout);
     setJMenuBar(jMenuBar1);
     contentPane.add(jToolBar, null);
        contentPane.add(jButton1);
        jMenuFile.add(jMenuItem1);
     jMenuFile.add(jMenuFileExit);

        jLabel1.setText("帐户号: ");
        jLabel1.setBounds(new Rectangle(32, 59, 96, 37));
        jTextField1.setText("");
        jTextField1.setBounds(new Rectangle(143, 60, 200, 29));
        jTextField2.setText("");
        jTextField2.setBounds(new Rectangle(141, 121, 201, 29));
        jTextField3.setText("");
        jTextField3.setBounds(new Rectangle(141, 184, 200, 29));
        jTextField4.setText("");
        jTextField4.setBounds(new Rectangle(141, 241, 201, 29));
        this.getContentPane().add(jLabel1);
        jLabel5.setText("注意： 转帐类型 1 ：活期储蓄  2：信用卡");
        jLabel5.setBounds(new Rectangle(30, 20, 298, 37));
        jLabel4.setText("日标帐户号或卡号：");
        jLabel4.setBounds(new Rectangle(28, 240, 108, 34));
        jLabel3.setText("转帐类型：");
        jLabel3.setBounds(new Rectangle(34, 177, 86, 38));
        this.getContentPane().add(jLabel2);
        this.getContentPane().add(jLabel3);
        this.getContentPane().add(jLabel5);
        this.getContentPane().add(jLabel4);
        this.getContentPane().add(jTextField1);
        this.getContentPane().add(jTextField2);
        this.getContentPane().add(jTextField3);
        this.getContentPane().add(jTextField4);
        jLabel2.setText("输入金额：");
        jLabel2.setBounds(new Rectangle(31, 123, 80, 27));
    }

    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    JLabel jLabel3 = new JLabel();
    JLabel jLabel4 = new JLabel();
    JLabel jLabel5 = new JLabel();
    JTextField jTextField1 = new JTextField();
    JTextField jTextField2 = new JTextField();
    JTextField jTextField3 = new JTextField();
    JTextField jTextField4 = new JTextField();
    JButton jButton1 = new JButton();
    ErrorDlg dig;
    void jMenuFileExit_actionPerformed(ActionEvent actionEvent) {
       System.exit(0);
   }

   void jMenuHelpAbout_actionPerformed(ActionEvent actionEvent) {

      Dimension frmSize = getSize();
      Point loc = getLocation();

  }

    public void jButton1_actionPerformed(ActionEvent e) {

        String a = jTextField1.getText();
        String b = jTextField2.getText();
        String c = jTextField3.getText();
        String d = jTextField4.getText();

        int LenA = a.length();
     int LenB = d.length();
     int LenC = b.length();
     int LenD = c.length();

        if( LenA== 0)
     {
     dig = new ErrorDlg();
     dig.setMessage("帐户号不能为空");
     dig.setVisible(true);
    }
   else if(LenA != 4)
   {
    dig = new ErrorDlg();
    dig.setMessage("帐户不存在或输入有误");
    dig.setVisible(true);
    }
   else if(LenB == 0)
    {
   dig = new ErrorDlg();
   dig.setMessage("金额不能为空");
   dig.setVisible(true);
   }
   else if(LenC == 0)
   {
   dig = new ErrorDlg();
   dig.setMessage("转帐类型不能为空");
   dig.setVisible(true);
   }

   else if(LenD == 0)
  {
  dig = new ErrorDlg();
  dig.setMessage("转帐类型不能为空");
  dig.setVisible(true);
  }
  else if(LenD!= 4)
   {
    dig = new ErrorDlg();
    dig.setMessage("目标帐户不存在或输入有误");
    dig.setVisible(true);
   }


        DbConnector conn = DbConnector.getInstance();
                SqlController sql = new SqlController(conn.getConnection());
                try {
                     ResultSet rs=sql.SelectStmt("select 余额 from 帐户余额表 where 帐户号='1222'");
                     ResultSet rs1=sql.SelectStmt("select 余额 from 帐户余额表 where 帐户号="+d);
                     rs.next();
                     String m = rs.getString("余额");
                        rs1.next();
                    String n = rs1.getString("余额");
                     float k = Float.parseFloat(m);
                     float l = Float.parseFloat(b);
                     float o = Float.parseFloat(n);
                     k = k-l;
                     o = o-l;
                  //   String s = String.valueOf(k);
                      String update1 = "update 帐户余额表 set 余额='"+k+"'where 帐户号 =" +a;
                      sql.UpdateStmt(update1);

                    //  String r = String.valueOf(o);
                      String update2 = "update 帐户余额表 set 余额='"+o+"'where 帐户号 =" +d;
                      sql.UpdateStmt(update2);

                     System.out.print(k);
                     System.out.print(o);
                      } catch (Exception exception) {
                          exception.printStackTrace();
                      }


    }

}


class ChangeAccount_jButton1_actionAdapter implements ActionListener {
    private ChangeAccount adaptee;
    ChangeAccount_jButton1_actionAdapter(ChangeAccount adaptee) {
        this.adaptee = adaptee;
    }

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


class ChangeAccount_jMenuFileExit_ActionAdapter implements ActionListener {
    ChangeAccount adaptee;

    ChangeAccount_jMenuFileExit_ActionAdapter(ChangeAccount adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent actionEvent) {
        adaptee.jMenuFileExit_actionPerformed(actionEvent);
    }
}


class ChangeAccount_jMenuHelpAbout_ActionAdapter implements ActionListener {
    ChangeAccount adaptee;

    ChangeAccount_jMenuHelpAbout_ActionAdapter(ChangeAccount adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent actionEvent) {
        adaptee.jMenuHelpAbout_actionPerformed(actionEvent);
    }
}