openaccount.java

大型数据库课程设计源码

			jLabel8.setText("身份证号码：");
			jLabel7 = new JLabel();
			jLabel7.setBounds(new Rectangle(336, 23, 50, 22));
			jLabel7.setText("性别：");
			jLabel6 = new JLabel();
			jLabel6.setBounds(new Rectangle(10, 23, 47, 26));
			jLabel6.setText("姓名：");
			jPanel1 = new JPanel();
			jPanel1.setLayout(null);
			jPanel1.setBounds(new Rectangle(6, 248, 551, 151));
			jPanel1.setBorder(BorderFactory.createTitledBorder(BorderFactory.createBevelBorder(BevelBorder.RAISED), "\u5ba2\u6237\u8d44\u6599", TitledBorder.CENTER, TitledBorder.DEFAULT_POSITION, new Font("\u5b8b\u4f53", Font.PLAIN, 14), Color.red));
			jPanel1.add(jLabel6, null);
			jPanel1.add(getJTextField2(), null);
			jPanel1.add(jLabel7, null);
			jPanel1.add(getJComboBox1(), null);
			jPanel1.add(jLabel8, null);
			jPanel1.add(getJTextField3(), null);
			jPanel1.add(jLabel9, null);
			jPanel1.add(getJTextField4(), null);
			jPanel1.add(jLabel10, null);
			jPanel1.add(getJTextField5(), null);
		}
		return jPanel1;
	}

	/**
	 * This method initializes jTextField2	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextField2() {
		if (jTextField2 == null) {
			jTextField2 = new JTextField();
			jTextField2.setBounds(new Rectangle(62, 24, 145, 24));
		}
		return jTextField2;
	}

	/**
	 * This method initializes jComboBox1	
	 * 	
	 * @return javax.swing.JComboBox	
	 */
	private JComboBox getJComboBox1() {
		if (jComboBox1 == null) {
			jComboBox1 = new JComboBox();
			jComboBox1.setBounds(new Rectangle(391, 23, 62, 26));
			jComboBox1.addItem("男");
			jComboBox1.addItem("女");
		}
		return jComboBox1;
	}

	/**
	 * This method initializes jTextField3	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextField3() {
		if (jTextField3 == null) {
			jTextField3 = new JTextField();
			jTextField3.setBounds(new Rectangle(98, 55, 195, 26));
		}
		return jTextField3;
	}

	/**
	 * This method initializes jTextField4	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextField4() {
		if (jTextField4 == null) {
			jTextField4 = new JTextField();
			jTextField4.setBounds(new Rectangle(61, 87, 331, 25));
		}
		return jTextField4;
	}

	/**
	 * This method initializes jTextField5	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextField5() {
		if (jTextField5 == null) {
			jTextField5 = new JTextField();
			jTextField5.setBounds(new Rectangle(66, 116, 120, 28));
		}
		return jTextField5;
	}

	/**
	 * This method initializes jPanel2	
	 * 	
	 * @return javax.swing.JPanel	
	 */
	private JPanel getJPanel2() {
		if (jPanel2 == null) {
			jPanel2 = new JPanel();
			jPanel2.setLayout(null);
			jPanel2.setBounds(new Rectangle(6, 400, 446, 34));
			jPanel2.add(getJButton(), null);
			jPanel2.add(getJButton1(), null);
		}
		return jPanel2;
	}

	/**
	 * This method initializes jButton	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getJButton() {
		if (jButton == null) {
			jButton = new JButton();
			jButton.setBounds(new Rectangle(112, 3, 79, 30));
			jButton.setText("确认");
			jButton.addActionListener(new java.awt.event.ActionListener() {
				public void actionPerformed(java.awt.event.ActionEvent e) {
					openAccount(); // TODO Auto-generated Event stub actionPerformed()
					
				}
			});
		}
		return jButton;
	}
	private int openAccount() {
		String acc=jTextField.getText().trim();
		String akind=(String)jComboBox.getSelectedItem();
		String money=jTextField1.getText().trim();
		float gold=new Float(money).floatValue();
		String apwd=CharToString.charToString(jPasswordField.getPassword());
		String akpwd=CharToString.charToString(jPasswordField2.getPassword());
		/*for(int i = 0; i < jPasswordField.getPassword().length; i++ ) { 
		apwd += jPasswordField.getPassword()[i]; 
		} */
		System.out.println(apwd+","+akpwd);
		String cpwd="";
		String ckpwd="";
		if(jCheckBox.isSelected()) {
			  cpwd=CharToString.charToString(jPasswordField1.getPassword());
			  ckpwd=CharToString.charToString(jPasswordField3.getPassword());
		}
			
		String name=jTextField2.getText().trim();
		String se=(String)jComboBox.getSelectedItem();
		String sex;
		if(se.equals("男"))
			sex="m";
		else sex="f";
		String idcard=jTextField3.getText().trim();
		String addr=jTextField4.getText().trim();
		String phone=jTextField5.getText().trim();
		
		if(!apwd.equals(akpwd)) {
			JOptionPane.showMessageDialog(this, "您两次输入的帐号密码不同", "alert", JOptionPane.ERROR_MESSAGE);
			return 1;
		}
		if(!cpwd.equals(ckpwd)) {
			JOptionPane.showMessageDialog(this, "您两次输入的借记卡密码不同", "alert", JOptionPane.ERROR_MESSAGE);
			return 1;
		}
		if(gold<10&&akind!="信用卡"){
			JOptionPane.showMessageDialog(this, "储蓄帐号最低存款额为10元", "alert", JOptionPane.ERROR_MESSAGE);
			return 1;
		}
		String id="";
		String sql1="insert into customer(customerName,sex,idcard,address,phone) values('"+
		name+"','"+sex+"','"+idcard+"','"+addr+"','"+phone+"')";
		DBManager.getConnection();
		DBManager.execInsert(sql1);
		java.sql.ResultSet rs=DBManager.executeSelect("select customerID from customer where customername='"+name+"'");
		try {
			if(rs.next()) {
				id=rs.getString("customerid");System.out.println(id);
			}
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		 String sql="insert into account(accountNum,accountKind,customerid";
		 if(akind=="信用卡")sql +=",maxload,accountpwd";
		 else
			 sql +=",balance,accountpwd";
		if(jCheckBox.isSelected())
			sql+=",BANKCARDPWD";
			sql+=")";
		sql+= "values('"+acc+"','"+
			akind+"','"+id+"',"+gold+",'"+apwd+"'";
		if(jCheckBox.isSelected())
			sql+=",'"+cpwd+"'";
		sql+=")";
		
		
		
		System.out.println(sql);
		System.out.println(sql1);
		
		//DBManager.getConnection();
		int t=DBManager.execInsert(sql);
		DBManager.releaseCon();
		if(t!=0) {
		JOptionPane.showConfirmDialog(this, 
				"帐户已经开通", "ok", JOptionPane.OK_OPTION );
		clear();
		return 0;
		}else return 1;
	}
	private void clear() {
		jTextField.setText("");

		jTextField1.setText("");
		jTextField2.setText("");
		jTextField3.setText("");
		jTextField4.setText("");
		jTextField5.setText("");
		
		jPasswordField.setText("");
		jPasswordField1.setText("");
		jPasswordField2.setText("");
		jPasswordField3.setText("");
		if(jCheckBox.isSelected())
			jCheckBox.setSelected(false);
	}
	/**
	 * This method initializes jButton1	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getJButton1() {
		if (jButton1 == null) {
			jButton1 = new JButton();
			jButton1.setBounds(new Rectangle(226, 4, 97, 28));
			jButton1.setText("取消");
			jButton1.addActionListener(new java.awt.event.ActionListener() {
				public void actionPerformed(java.awt.event.ActionEvent e) {
					clear(); // TODO Auto-generated Event stub actionPerformed()
				}
			});
		}
		return jButton1;
	}

	/**
	 * This method initializes jPasswordField2	
	 * 	
	 * @return javax.swing.JPasswordField	
	 */
	private JPasswordField getJPasswordField2() {
		if (jPasswordField2 == null) {
			jPasswordField2 = new JPasswordField();
			jPasswordField2.setBounds(new Rectangle(359, 72, 163, 31));
		}
		return jPasswordField2;
	}

	/**
	 * This method initializes jPasswordField3	
	 * 	
	 * @return javax.swing.JPasswordField	
	 */
	private JPasswordField getJPasswordField3() {
		if (jPasswordField3 == null) {
			jPasswordField3 = new JPasswordField();
			jPasswordField3.setBounds(new Rectangle(258, 186, 146, 25));
			jPasswordField3.setEditable(false);
		}
		return jPasswordField3;
	}

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