checkmoney.java~70~

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

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 Error.*;
import Database.*;
import java.sql.ResultSet;
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 CheckMoney 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 CheckMoney() {
        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 CheckMoney_jMenuFileExit_ActionAdapter(this));
     jMenuHelp.setText("Help");
     jMenuHelpAbout.setText("About");
     jMenuHelpAbout.addActionListener(new CheckMoney_jMenuHelpAbout_ActionAdapter(this));
     jToolBar.setBounds(new Rectangle(0, 0, 13, 2));

     jMenuFile.setText("选项");
     jMenuItem1.setText("注销");
        jButton1.setBounds(new Rectangle(41, 147, 92, 34));
        jButton1.setText("查询");
        jButton1.addActionListener(new CheckMoney_jButton1_actionAdapter(this));
     //   String a="sd";
        jTextField1.setText("");
        jTextField1.setBounds(new Rectangle(175, 149, 154, 34));
        jTextField1.addActionListener(new CheckMoney_jTextField1_actionAdapter(this));
        jButton2.setBounds(new Rectangle(45, 257, 87, 31));
        jButton2.setText("取消");
        jButton2.addActionListener(new CheckMoney_jButton2_actionAdapter(this));
        jLabel2.setText("帐户号");
        jLabel2.setBounds(new Rectangle(47, 87, 97, 26));
        jTextField2.setText("");
        jTextField2.setBounds(new Rectangle(177, 90, 152, 34));
        jMenuBar1.add(jMenuFile);
     jMenuBar1.add(jMenuHelp);
     jMenuHelp.add(jMenuHelpAbout);
     setJMenuBar(jMenuBar1);
     contentPane.add(jToolBar, null);
        contentPane.add(jButton2);
        contentPane.add(jButton1);
        contentPane.add(jTextField2);
        contentPane.add(jLabel2);
        contentPane.add(jTextField1);
        jMenuFile.add(jMenuItem1);
     jMenuFile.add(jMenuFileExit);

        jLabel1.setText("帐户查询余额");
        jLabel1.setBounds(new Rectangle(38, 28, 134, 57));
        this.getContentPane().add(jLabel1);
    }
    void jMenuFileExit_actionPerformed(ActionEvent actionEvent) {
       System.exit(0);
   }

   void jMenuHelpAbout_actionPerformed(ActionEvent actionEvent) {

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

  }
        ErrorDlg dig;
    JLabel jLabel1 = new JLabel();
    JButton jButton1 = new JButton();
    JTextField jTextField1 = new JTextField();
    JButton jButton2 = new JButton(); //    JFrame checkInf1 = new CheckInfor();

    JLabel jLabel2 = new JLabel();
    JTextField jTextField2 = new JTextField();

    public void jButton1_actionPerformed(ActionEvent e) {

       String getA = jTextField2.getText();
       int LenA = getA.length();
       if(LenA  == 0)
{
     dig = new ErrorDlg();
     dig.setMessage("帐户号不能为空");
     dig.setVisible(true);
}
else if(LenA != 4)
{
   dig = new ErrorDlg();
   dig.setMessage("帐户不存在或输入有误");
   dig.setVisible(true);
}


        int i=4;
        DbConnector conn = DbConnector.getInstance();
               SqlController sql = new SqlController(conn.getConnection());

                String b1 = jTextField2.getText();
               try {
                    ResultSet rs=sql.SelectStmt("select * from 活期储蓄表 where  卡号='1234' and 帐户号="+b1);
                    rs.next();
                    ResultSet rs1=sql.SelectStmt("select * from 脚本表");
                    rs1.next();
                    String a = rs.getString("金额");
                   String atime = rs.getString("开始时间");
                   String time[] = new String[4];

                    String b = rs1.getString("值");
                    float k = Float.parseFloat(a);
                    float j = Float.parseFloat(b);
                    for(;i>=1;i--)
                    {
                        k=k*j+k;
                    }

                   String s = String.valueOf(k);
                     jTextField1.setText(s);

                     } catch (Exception exception) {
                         exception.printStackTrace();
                     }


    }

    public void jTextField1_actionPerformed(ActionEvent e) {

    }

    public void jButton2_actionPerformed(ActionEvent e) {

        try {
                dispose();
              //  checkInf.setVisible(true);
                  } catch (Exception exception) {
                      exception.printStackTrace();
                  }




    }

}


class CheckMoney_jButton2_actionAdapter implements ActionListener {
    private CheckMoney adaptee;
    CheckMoney_jButton2_actionAdapter(CheckMoney adaptee) {
        this.adaptee = adaptee;
    }

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


class CheckMoney_jTextField1_actionAdapter implements ActionListener {
    private CheckMoney adaptee;
    CheckMoney_jTextField1_actionAdapter(CheckMoney adaptee) {
        this.adaptee = adaptee;
    }

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


class CheckMoney_jButton1_actionAdapter implements ActionListener {
    private CheckMoney adaptee;
    CheckMoney_jButton1_actionAdapter(CheckMoney adaptee) {
        this.adaptee = adaptee;
    }

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


class CheckMoney_jMenuFileExit_ActionAdapter implements ActionListener {
    CheckMoney adaptee;

    CheckMoney_jMenuFileExit_ActionAdapter(CheckMoney adaptee) {
        this.adaptee = adaptee;
    }

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


class CheckMoney_jMenuHelpAbout_ActionAdapter implements ActionListener {
    CheckMoney adaptee;

    CheckMoney_jMenuHelpAbout_ActionAdapter(CheckMoney adaptee) {
        this.adaptee = adaptee;
    }

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