kaihu.java

the function of the system is simulated ATM machine landing, balance inquiries, withdrawals, change

		if (jTextField1 == null) {
			jTextField1 = new JTextField();
			jTextField1.setColumns(8);
		}
		return jTextField1;
	}

	/**
	 * This method initializes jTextField2	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextField2() {
		if (jTextField2 == null) {
			jTextField2 = new JTextField();
			jTextField2.setColumns(18);
		}
		return jTextField2;
	}

	/**
	 * This method initializes jTextField4	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextField4() {
		if (jTextField4 == null) {
			jTextField4 = new JTextField();
			jTextField4.setColumns(13);
		}
		return jTextField4;
	}

	/**
	 * This method initializes jButton	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getJButton() {
		if (jButton == null) {
			jButton = new JButton();
			jButton.setText("确定");
			jButton.addActionListener(new java.awt.event.ActionListener() {
				public void actionPerformed(java.awt.event.ActionEvent e) {
					System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
					if (jTextField.getText().equals("") || jTextField1.getText().equals("") ||jTextField2.getText().equals("")|| jTextField3.getText().equals("") || jTextField4.getText().equals("") ) {
					            javax.swing.JOptionPane.showMessageDialog(null, "各栏不能为空,请重填!");
					        } else {
					            try {
					                Integer.parseInt(jTextField.getText());
					            } catch (NumberFormatException ex) {
					                javax.swing.JOptionPane.showMessageDialog(null,"请确保数量栏及单价栏为数字！");
					                return;
					            }
					            if(Integer.parseInt(jTextField.getText()) < 0 ){
					                    javax.swing.JOptionPane.showMessageDialog(null,"不能有负数！");
					                    return;
					            }
								
					            //如果以上验证均通过则开始添加新数据
					            Sql dbc = new Sql();
					            dbc.getConn();
					            if((dbc.executeUpdateSQL("INSERT into userInfo VALUES (" + jTextField.getText() +",'" + jTextField1.getText() + "','" +jTextField2.getText() + "','" +jTextField3.getText()+ "','" +	jTextField4.getText()+ "')"))
					            		//&& (dbc.executeUpdateSQL("INSERT into cardInfo VALUES (" + Integer.parseInt(jTextField5.getText()) +",'" + jComboBox.getSelectedItem() + "','" +jComboBox1.getSelectedItem() + "','" +jTextField8.getText()+ "','" +	jTextField9.getText()+ "')"))){
					            		&&(dbc.executeUpdateSQL("INSERT into cardInfo(cardID,customerID,savingType,curType,openDate,openMoney,pass,balance) VALUES ('" + jTextField5.getText() +"'," + jTextField.getText()+",'"+ jComboBox1.getSelectedItem() +"','"+ jComboBox.getSelectedItem() +"','" + jTextField8.getText()+"','"+Integer.valueOf(jTextField9.getText())+"','"+String.valueOf(jPasswordField.getPassword())+"','"+Integer.valueOf(jTextField6.getText())+"')"))){
					            		javax.swing.JOptionPane.showMessageDialog(null, "记录插入成功！");
					                jTextField.setText("");
					                jTextField1.setText("");
					                jTextField2.setText("");
					                jTextField3.setText("");
					                jTextField4.setText("");
					                jTextField5.setText("");
					                jTextField8.setText("");
					                jTextField9.setText("");
					                jTextField6.setText("");
					                jPasswordField.setText("");

					            } else {
					                javax.swing.JOptionPane.showMessageDialog(null, "该记录插入失败！请您重试。");
					            } 
				}
				}
			});
		}
		return jButton;
	}

	/**
	 * This method initializes jButton1	
	 * 	
	 * @return javax.swing.JButton	
	 */
	public void close(){
		this.setVisible(false);
	}
	private JButton getJButton1() {
		if (jButton1 == null) {
			jButton1 = new JButton();
			jButton1.setText("取消");
			jButton1.addActionListener(new java.awt.event.ActionListener() {
				public void actionPerformed(java.awt.event.ActionEvent e) {
					System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
					close();
				}
			});
		}
		return jButton1;
	}

	/**
	 * This method initializes jTextField8	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextField8() {
		if (jTextField8 == null) {
			jTextField8 = new JTextField();
			jTextField8.setColumns(8);
		}
		return jTextField8;
	}

	/**
	 * This method initializes jTextField9	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextField9() {
		if (jTextField9 == null) {
			jTextField9 = new JTextField();
			jTextField9.setColumns(8);
		}
		return jTextField9;
	}

	/**
	 * This method initializes jComboBox	
	 * 	
	 * @return javax.swing.JComboBox	
	 */
	private JComboBox getJComboBox() {
		if (jComboBox == null) {
			jComboBox = new JComboBox();
		}
		return jComboBox;
	}

	/**
	 * This method initializes jComboBox1	
	 * 	
	 * @return javax.swing.JComboBox	
	 */
	private JComboBox getJComboBox1() {
		if (jComboBox1 == null) {
			jComboBox1 = new JComboBox();
		}
		return jComboBox1;
	}

	/**
	 * This method initializes jTextField5	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextField5() {
		if (jTextField5 == null) {
			jTextField5 = new JTextField();
			jTextField5.setColumns(13);
		}
		return jTextField5;
	}

	/**
	 * This method initializes jTextField3	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextField3() {
		if (jTextField3 == null) {
			jTextField3 = new JTextField();
			jTextField3.setColumns(18);
		}
		return jTextField3;
	}

	/**
	 * @param args
	 */
	/*public static void main(String[] args) {
		// TODO 自动生成方法存根
		SwingUtilities.invokeLater(new Runnable() {
			public void run() {
				Kaihu thisClass = new Kaihu();
				thisClass.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
				thisClass.setVisible(true);
			}
		});
	}

	/**
	 * This is the default constructor
	 */
	public Kaihu() {
		super();
		initialize();
	}

	/**
	 * This method initializes this
	 * 
	 * @return void
	 */
	private void initialize() {
		this.setSize(614, 281);
		this.setContentPane(getJContentPane());
		this.setTitle("开户");
		jComboBox1.addItem("活期");
		jComboBox1.addItem("定期");
		jComboBox1.addItem("定活两期");
		jComboBox.addItem("RMB");
		jComboBox.addItem("美元");
	}

	/**
	 * This method initializes jContentPane
	 * 
	 * @return javax.swing.JPanel
	 */
	private JPanel getJContentPane() {
		if (jContentPane == null) {
			jContentPane = new JPanel();
			jContentPane.setLayout(new BorderLayout());
			jContentPane.add(getJPanel(), BorderLayout.CENTER);
		}
		return jContentPane;
	}

	/**
	 * This method initializes jTextField6	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextField6() {
		if (jTextField6 == null) {
			jTextField6 = new JTextField();
			jTextField6.setColumns(8);
		}
		return jTextField6;
	}

	/**
	 * This method initializes jPasswordField	
	 * 	
	 * @return javax.swing.JPasswordField	
	 */
	private JPasswordField getJPasswordField() {
		if (jPasswordField == null) {
			jPasswordField = new JPasswordField();
			jPasswordField.setColumns(6);
		}
		return jPasswordField;
	}

}  //  @jve:decl-index=0:visual-constraint="10,10"