insertaccount.java

一个简单的银行管理系统

    private void cancelButtonActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cancelButtonActionPerformed
// TODO 将在此处添加您的处理代码：
        this.dispose();
        try
        {
            insertAccount.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
    }//GEN-LAST:event_cancelButtonActionPerformed

    //重置响应代码
    private void resetButtonActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_resetButtonActionPerformed
// TODO 将在此处添加您的处理代码：
        nameField.setText("");
        sexComboBox.setSelectedIndex(0);
        accountTypeComboBox.setSelectedIndex(0);
        IDField.setText("");
        addressField.setText("");
        phoneField.setText("");
        accountPasswordField.setText("");
        reAccountPasswordField.setText("");
        sumField.setText("");
    }//GEN-LAST:event_resetButtonActionPerformed

    //确认提交响应代码
    private void confirmButtonActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_confirmButtonActionPerformed
// TODO 将在此处添加您的处理代码：
        String name = nameField.getText();
        String sex = (sexComboBox.getSelectedItem()).toString();
        String accountType = "";
        String ID = IDField.getText();
        String address = addressField.getText();
        String phone = phoneField.getText();
        String accountPassword = accountPasswordField.getText();
        String reAccountPassword = reAccountPasswordField.getText();
        String sumString = sumField.getText();
        int sum = 0;

        switch(accountTypeComboBox.getSelectedIndex())
        {
            case 0:
            {
                accountType = "CU";
                break;
            }
            case 1:
            {
                accountType = "TE";
                break;
            }
        }
        if(!check(ID,phone,accountPassword,reAccountPassword,sumString))
        {
            //
        }

        else
        {
            sum = Integer.parseInt(sumString);
            CallableStatement proc = null;
            try
            {
                String sql = "select * from Depositor where IDcard = '"+ID+"'";
                Statement stat = insertAccount.createStatement();
                ResultSet result = stat.executeQuery(sql);
                if(!result.next())
                {   
                    proc = insertAccount.prepareCall("{ call InsertDepositor(?,?,?,?,?) }");
                    proc.setString(1, ID);
                    proc.setString(2, name); 
                    proc.setString(3,sex);
                    proc.setString(4,address);
                    proc.setString(5,phone);
                    proc.execute();            
                }
                
                if(accountType.equals("CU"))
                {
                    proc = insertAccount.prepareCall("{ call InsertCurrentAccount(?,?,?,?,?,?) }");
                    proc.setString(1, accountPassword);
                    proc.setString(2, ID); 
                    proc.setInt(3,sum);
                    proc.setString(4,accountType);
                    proc.setString(5,staffID);
                    proc.setString(6,name);
                    proc.execute(); 
                    proc.close();
                    insertAccount.close();
                    dispose();
                }
                else
                {
                    int limitTime = Integer.parseInt(limitTimeField.getText());
                    String auto = (String)autoComboBox.getSelectedItem();
                    proc = insertAccount.prepareCall("{ call InsertFixedAccount(?,?,?,?,?,?,?,?) }");
                    proc.setString(1, accountPassword);
                    proc.setString(2, ID); 
                    proc.setInt(3,sum);
                    proc.setString(4,accountType);
                    proc.setString(5,staffID);
                    proc.setString(6,name);
                    proc.setInt(7,limitTime);
                    proc.setString(8,auto);
                    proc.execute(); 
                    proc.close();
                    insertAccount.close();
                    dispose();
                } 
            }
            catch(Exception insertAccountException)
            {
                System.out.println(insertAccountException);
                insertAccountException.printStackTrace();
            }
        }
    }//GEN-LAST:event_confirmButtonActionPerformed
    
    private boolean check(String s1,String s2,String s3,String s4,String a)
    {
        String ID = s1;
        String phone = s2;
        String accountPassword = s3;
        String reAccountPassword = s4;
        String sumString = a;
        boolean flag = true;
        
        if(!accountPassword.equals(reAccountPassword))
        {
            JOptionPane.showMessageDialog(null,"您输入的两次密码不一致，请确认后重新输入！","出错",JOptionPane.ERROR_MESSAGE);
            accountPasswordField.setText("");
            reAccountPasswordField.setText("");
            flag = false;
        }
        else if(!checkSum(sumString))
        {
            JOptionPane.showMessageDialog(null,"存款必须输入数字！请重新输入","出错",JOptionPane.ERROR_MESSAGE);
            sumField.setText("");
            flag = false;
        }
        else if(Integer.parseInt(sumString)<10)
        {
            JOptionPane.showMessageDialog(null,"开户存款必须大于10元！请重新输入","出错",JOptionPane.ERROR_MESSAGE);
            sumField.setText("");
            flag = false;
        }
        else
        {
            if(checkData(phone,ID).equals("checktelephoneError"))
            {
                JOptionPane.showMessageDialog(null,"您输入的电话号码格式不对，请重新输入！","出错",JOptionPane.ERROR_MESSAGE);
                phoneField.setText("");
                flag =false;
            }
            if(checkData(phone,ID).equals("checktIDError"))
            {
                JOptionPane.showMessageDialog(null,"您输入的电话证件号不对，请重新输入！","出错",JOptionPane.ERROR_MESSAGE);
                IDField.setText("");
                flag = false;
            }
            if(checkData(phone,ID).equals("checktelephoneErrorIDError"))
            {
                JOptionPane.showMessageDialog(null,"您输入的电话号码格式和身份证格式都不对，请重新输入！","出错",JOptionPane.ERROR_MESSAGE);
                phoneField.setText("");
                IDField.setText("");
                flag = false;
            }
        }
        return flag;
            
    }
    
    private String checkData(String telephone,String ID) 
    {    
        Pattern p = Pattern.compile("13[0-9]{9}$");
        Matcher m = p.matcher(telephone);
        String msg = "check";
        boolean b = m.matches();
        if(!b) 
        {
            System.out.println(telephone);
            msg=msg+"telephoneError";    
        }
     
        Pattern p1 = Pattern.compile("^[1-9][0-9]{17}$");
        Matcher m1 = p1.matcher(ID);
        boolean b1 = m1.matches();
        if(!b1) 
        {
            msg=msg+"IDError";    
        }
        return msg;
    }
    
    private boolean checkSum(String sum) 
    {    
        Pattern p = Pattern.compile("^[1-9][0-9]*$");
        Matcher m = p.matcher(sum);
        boolean b = m.matches();
        return b;
    }
    /**
     * @param args the command line arguments
     */
    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new InsertAccount(" 00001").setVisible(true);
            }
        });
    }
        

    //连接数据库操作－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－
    public void connectDB()
    {
        String dbUrl = "jdbc:odbc:afei";
        String user = "scott";
        String password = "tiger";
        try
        {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            insertAccount = DriverManager.getConnection(dbUrl,user,password);
        }
        catch(Exception connectException)
        {
            connectException.printStackTrace();
        }
    }
    // 变量声明 - 不进行修改//GEN-BEGIN:variables
    private javax.swing.JTextField IDField;
    private javax.swing.JPasswordField accountPasswordField;
    private javax.swing.JComboBox accountTypeComboBox;
    private javax.swing.JTextField addressField;
    private javax.swing.JComboBox autoComboBox;
    private javax.swing.JButton cancelButton;
    private javax.swing.JButton confirmButton;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel10;
    private javax.swing.JLabel jLabel11;
    private javax.swing.JLabel jLabel12;
    private javax.swing.JLabel jLabel13;
    private javax.swing.JLabel jLabel14;
    private javax.swing.JLabel jLabel2;
    private javax.swing.JLabel jLabel3;
    private javax.swing.JLabel jLabel4;
    private javax.swing.JLabel jLabel5;
    private javax.swing.JLabel jLabel6;
    private javax.swing.JLabel jLabel7;
    private javax.swing.JLabel jLabel8;
    private javax.swing.JLabel jLabel9;
    private javax.swing.JTextField limitTimeField;
    private javax.swing.JTextField nameField;
    private javax.swing.JTextField phoneField;
    private javax.swing.JPasswordField reAccountPasswordField;
    private javax.swing.JButton resetButton;
    private javax.swing.JComboBox sexComboBox;
    private javax.swing.JTextField sumField;
    // 变量声明结束//GEN-END:variables
    private Connection insertAccount;
}