newaccount.java~85~

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

package chuxu;
import javax.swing.*;
import javax.swing.DebugGraphics;
import java.awt.Rectangle;
import java.awt.Color;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.Dimension;
import javax.swing.border.TitledBorder;
import java.awt.BorderLayout;
import java.awt.Font;
import javax.swing.border.TitledBorder;
import java.awt.Point;
import java.awt.SystemColor;
import Error.*;
import Database.*;
import java.sql.ResultSet;
/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class NewAccount 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 NewAccount() {
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        //this.setDebugGraphicsOptions(DebugGraphics.NONE_OPTION);
        setSize(new Dimension(500, 400));
        setTitle("SE 银行--储蓄--开户");
        this.setLayout(null);
        contentPane = (JPanel) getContentPane();
      jMenuFileExit.setText("离开");
      jMenuFileExit.addActionListener(new NewAccount_jMenuFileExit_ActionAdapter(this));
      jMenuHelp.setText("Help");
      jMenuHelpAbout.setText("About");
      jMenuHelpAbout.addActionListener(new NewAccount_jMenuHelpAbout_ActionAdapter(this));
        jMenuFile.setText("选项");
      jMenuItem1.setText("注销");
        jButton1.setBounds(new Rectangle(18, 291, 94, 29));
        jButton1.setText("确定");
        jButton1.addActionListener(new NewAccount_jButton1_actionAdapter(this));
        jLabel6.setText("注意： 请注意输入身份证的位数");
        contentPane.setLayout(null);
        jButton2.setBounds(new Rectangle(282, 289, 95, 30));
        jButton2.setText("取消");
        jButton2.addActionListener(new NewAccount_jButton2_actionAdapter(this));
        jMenuBar1.add(jMenuFile);
      jMenuBar1.add(jMenuHelp);
      jMenuHelp.add(jMenuHelpAbout);
      setJMenuBar(jMenuBar1);
      contentPane.add(jToolBar, null);
        contentPane.add(jLabel6);
        contentPane.add(jButton1);
        contentPane.add(jButton2);
        jMenuFile.add(jMenuItem1);
      jMenuFile.add(jMenuFileExit);

        jLabel1.setText("身份证号");
        jLabel1.setBounds(new Rectangle(20, 21, 84, 33));
        jLabel2.setText("姓名");
        jLabel2.setBounds(new Rectangle(20, 71, 79, 33));
        jLabel3.setText("出生年月");
        jLabel3.setBounds(new Rectangle(18, 120, 73, 35));
        jLabel4.setText("电话");
        jLabel4.setBounds(new Rectangle(23, 179, 81, 35));
        jLabel5.setText("地址");
        jLabel5.setBounds(new Rectangle(20, 238, 74, 38));
        jTextField1.setText("");
        jTextField1.setBounds(new Rectangle(86, 25, 187, 24));
        jTextField1.addActionListener(new NewAccount_jTextField1_actionAdapter(this));
        jTextField2.setText("");
        jTextField2.setBounds(new Rectangle(86, 75, 189, 24));
        jTextField3.setText("");
        jTextField3.setBounds(new Rectangle(85, 126, 190, 26));
        jTextField4.setText("");
        jTextField4.setBounds(new Rectangle(84, 180, 191, 26));
        jTextField5.setText("");
        jTextField5.setBounds(new Rectangle(83, 242, 190, 29));
        this.add(jLabel1);
        this.add(jLabel2);
        this.add(jLabel5);
        this.add(jLabel4);
        this.add(jLabel3);
        this.add(jTextField2);
        this.add(jTextField1);
        this.add(jTextField3);
        this.add(jTextField4);
        this.add(jTextField5);
    }
    static int haonum=1223;
    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();
    JTextField jTextField5 = new JTextField();
    JButton jButton1 = new JButton();
    public void jTextField1_actionPerformed(ActionEvent e) {


    }
    void jMenuFileExit_actionPerformed(ActionEvent actionEvent) {
       System.exit(0);
   }

   void jMenuHelpAbout_actionPerformed(ActionEvent actionEvent) {

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

}
    ErrorDlg dig;
    JLabel jLabel6 = new JLabel();
    JButton jButton2 = new JButton();
    public void jButton1_actionPerformed(ActionEvent e) {
     String a = jTextField1.getText();
      String b = jTextField2.getText();
      String c = jTextField3.getText();
      String d = jTextField4.getText();
      String f = jTextField5.getText();
      int m = a.length();
      int n = d.length();
      int x = b.length();
      int y = c.length();
      int z = f.length();
      if(m == 0)
      {
          dig = new ErrorDlg();
          dig.setMessage("身份证号不能为空");
          dig.setVisible(true);
      }
      else if (m!=15&&m!=18){
         dig = new ErrorDlg();
         dig.setMessage("你输入的身份证的位数有误！");
         dig.setVisible(true);
     }

      else if (x==0){
          dig = new ErrorDlg();
          dig.setMessage("姓名不能为空！");
          dig.setVisible(true);
      }

      else if (y==0){
       dig = new ErrorDlg();
       dig.setMessage("日期不能为空！");
       dig.setVisible(true);
   }
   else if (n==0){
        dig = new ErrorDlg();
        dig.setMessage("电话不能为空！");
        dig.setVisible(true);
    }

     else if (n!=11){
         dig = new ErrorDlg();
         dig.setMessage("你输入电话的位数有误！");
         dig.setVisible(true);
     }
     else if (z==0){
         dig = new ErrorDlg();
         dig.setMessage("地址不能为空！");
         dig.setVisible(true);
     }


      String update1 = "update 储蓄帐户表 set 身份证号='"+a+"',姓名='"+b+"',出生年月='"+c+"',电话 = '"+d+"',地址 = '"+f+"'where 帐户号="+haonum;
                 DbConnector conn = DbConnector.getInstance();
                SqlController sql = new SqlController(conn.getConnection());
                     sql.UpdateStmt(update1);
                     haonum++;
                try {

                         //   String update1 = "update 储蓄帐户表 set 身份证号="+a+"where 帐户号=1222";
                           // ResultSet rs=sql.SelectStmt("insert into 储蓄帐户表 values('dsds',+a,'b','2005-1-1','wewewew','sdsdsd') ");

                              //  rs.next();
                               // System.out.print(rs.getString("帐户号"));
                              //  System.out.print(rs.getString("余额"));

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

    }

    public void jButton2_actionPerformed(ActionEvent e) {
       dispose();
    }

}


class NewAccount_jButton2_actionAdapter implements ActionListener {
    private NewAccount adaptee;
    NewAccount_jButton2_actionAdapter(NewAccount adaptee) {
        this.adaptee = adaptee;
    }

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


class NewAccount_jButton1_actionAdapter implements ActionListener {
    private NewAccount adaptee;
    NewAccount_jButton1_actionAdapter(NewAccount adaptee) {
        this.adaptee = adaptee;
    }

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


class NewAccount_jTextField1_actionAdapter implements ActionListener {
    private NewAccount adaptee;
    NewAccount_jTextField1_actionAdapter(NewAccount adaptee) {
        this.adaptee = adaptee;
    }

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

class NewAccount_jMenuFileExit_ActionAdapter implements ActionListener {
    NewAccount adaptee;

    NewAccount_jMenuFileExit_ActionAdapter(NewAccount adaptee) {
        this.adaptee = adaptee;
    }

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


class NewAccount_jMenuHelpAbout_ActionAdapter implements ActionListener {
    NewAccount adaptee;

    NewAccount_jMenuHelpAbout_ActionAdapter(NewAccount adaptee) {
        this.adaptee = adaptee;
    }

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