changeaccount.java~47~

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

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;
import java.awt.Toolkit;

/**
 * <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("");
    String Cnum;
    public ChangeAccount(String cnum) {
        this.Cnum = cnum;
        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(128, 292, 85, 31));
        jButton1.setText("确定");
        jButton1.addActionListener(new ChangeAccount_jButton1_actionAdapter(this));
        jButton2.setBounds(new Rectangle(241, 292, 89, 31));
        jButton2.setText("取消");
        jButton2.addActionListener(new ChangeAccount_jButton2_actionAdapter(this));
        jMenuBar1.add(jMenuFile);
        jMenuBar1.add(jMenuHelp);
        jMenuHelp.add(jMenuHelpAbout);
        setJMenuBar(jMenuBar1);
        contentPane.add(jToolBar, null);
        contentPane.add(jButton1);
        contentPane.add(jButton2);
        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));

        Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
        Dimension frameSize = getSize();
        if (frameSize.height > screenSize.height) {
            frameSize.height = screenSize.height;
        }
        if (frameSize.width > screenSize.width) {
            frameSize.width = screenSize.width;
        }
        setLocation((screenSize.width - frameSize.width) / 2,
                    (screenSize.height - frameSize.height) / 2);
        setVisible(true);

    }

    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;
    JButton jButton2 = new JButton();
    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 = b.length();
        int LenC = c.length();
        int LenD = d.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  卡号='"+Cnum+"' and 帐户号=" + a;
            sql.UpdateStmt(update1);

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

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

    }

    public void jButton2_actionPerformed(ActionEvent e) {
        dispose();
        ChuxuMenu cm = new ChuxuMenu(Cnum);
        cm.setVisible(true);

    }

}


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

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


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);
    }
}