inframe.java

网上虚拟社区

import java.awt.BorderLayout;

import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JFrame;
import java.awt.Dimension;
import javax.swing.JLabel;
import java.awt.Rectangle;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

import javax.swing.JTextField;
import javax.swing.JButton;

import java.sql.*;
import java.util.*;

/**
 * This code was edited or generated using CloudGarden's Jigloo SWT/Swing GUI
 * Builder, which is free for non-commercial use. If Jigloo is being used
 * commercially (ie, by a corporation, company or business for any purpose
 * whatever) then you should purchase a license for each developer using Jigloo.
 * Please visit www.cloudgarden.com for details. Use of Jigloo implies
 * acceptance of these licensing terms. A COMMERCIAL LICENSE HAS NOT BEEN
 * PURCHASED FOR THIS MACHINE, SO JIGLOO OR THIS CODE CANNOT BE USED LEGALLY FOR
 * ANY CORPORATE OR COMMERCIAL PURPOSE.
 */
public class InFrame extends JFrame {

	private static final long serialVersionUID = 1L;

	private JPanel jContentPane = null;

	private JLabel jLabel = null;

	private JLabel jLabel1 = null;

	private JTextField jTextField = null;

	private JLabel jLabel2 = null;

	private JTextField jTextField1 = null;

	private JLabel jLabel3 = null;

	private JTextField jTextField2 = null;

	private JLabel jLabel4 = null;

	private JTextField jTextField3 = null;

	private JLabel jLabel5 = null;

	private JTextField jTextField4 = null;

	private JButton jButton = null;

	private JButton jButton1 = null;

	private String[] string = null;

	private String Driver = null;

	private String url = null;

	private String table = null;

	private Connection connection; // @jve:decl-index=0:

	private PreparedStatement statement;

	/**
	 * This is the default constructor
	 */
	public InFrame() {
		super();
		string = null;
		initialize();
	}

	public InFrame(String driver, String Url, String Table) {
		super();
		string = null;
		Driver = driver;
		url = Url;
		table = Table;
		initialize();
	}

	/**
	 * This method initializes this
	 * 
	 * @return void
	 */
	private void initialize() {
		this.setSize(339, 382);
		this.setContentPane(getJContentPane());
		this.setTitle("BankServer");
		this.setVisible(true);
	}

	/**
	 * This method initializes jContentPane
	 * 
	 * @return javax.swing.JPanel
	 */
	private JPanel getJContentPane() {
		if (jContentPane == null) {
			jLabel5 = new JLabel();
			jLabel5.setBounds(new Rectangle(30, 226, 76, 18));
			jLabel5.setText("家庭地址：");
			jLabel4 = new JLabel();
			jLabel4.setBounds(new Rectangle(30, 180, 78, 18));
			jLabel4.setText("名字：");
			jLabel3 = new JLabel();
			jLabel3.setBounds(new Rectangle(30, 135, 78, 18));
			jLabel3.setText("确认密码：");
			jLabel2 = new JLabel();
			jLabel2.setBounds(new Rectangle(31, 89, 78, 18));
			jLabel2.setText("密码：");
			jLabel1 = new JLabel();
			jLabel1.setBounds(new Rectangle(6, 8, 293, 29));
			jLabel1.setText("请输入要建立的：");
			jLabel = new JLabel();
			jLabel.setBounds(new Rectangle(32, 43, 76, 25));
			jLabel.setText("帐户：");
			jContentPane = new JPanel();
			jContentPane.setLayout(null);
			jContentPane.add(jLabel, null);
			jContentPane.add(jLabel1, null);
			jContentPane.add(getJTextField(), null);
			jContentPane.add(jLabel2, null);
			jContentPane.add(getJTextField1(), null);
			jContentPane.add(jLabel3, null);
			jContentPane.add(getJTextField2(), null);
			jContentPane.add(jLabel4, null);
			jContentPane.add(getJTextField3(), null);
			jContentPane.add(jLabel5, null);
			jContentPane.add(getJTextField4(), null);
			jContentPane.add(getJButton(), null);
			jContentPane.add(getJButton1(), null);
			jContentPane.setVisible(true);
		}
		return jContentPane;
	}

	/**
	 * This method initializes jTextField
	 * 
	 * @return javax.swing.JTextField
	 */
	private JTextField getJTextField() {
		if (jTextField == null) {
			jTextField = new JTextField();
			jTextField.setBounds(new Rectangle(119, 45, 166, 22));
		}
		return jTextField;
	}

	/**
	 * This method initializes jTextField1
	 * 
	 * @return javax.swing.JTextField
	 */
	private JTextField getJTextField1() {
		if (jTextField1 == null) {
			jTextField1 = new JTextField();
			jTextField1.setBounds(new Rectangle(120, 91, 164, 22));
		}
		return jTextField1;
	}

	/**
	 * This method initializes jTextField2
	 * 
	 * @return javax.swing.JTextField
	 */
	private JTextField getJTextField2() {
		if (jTextField2 == null) {
			jTextField2 = new JTextField();
			jTextField2.setBounds(new Rectangle(121, 135, 160, 22));
		}
		return jTextField2;
	}

	/**
	 * This method initializes jTextField3
	 * 
	 * @return javax.swing.JTextField
	 */
	private JTextField getJTextField3() {
		if (jTextField3 == null) {
			jTextField3 = new JTextField();
			jTextField3.setBounds(new Rectangle(121, 181, 160, 22));
		}
		return jTextField3;
	}

	/**
	 * This method initializes jTextField4
	 * 
	 * @return javax.swing.JTextField
	 */
	private JTextField getJTextField4() {
		if (jTextField4 == null) {
			jTextField4 = new JTextField();
			jTextField4.setBounds(new Rectangle(121, 226, 162, 22));
		}
		return jTextField4;
	}

	/**
	 * This method initializes jButton
	 * 
	 * @return javax.swing.JButton
	 */
	private JButton getJButton() {
		if (jButton == null) {
			jButton = new JButton();
			jButton.setBounds(new Rectangle(44, 285, 78, 31));
			jButton.setText("建立");
			jButton.addActionListener(new ActionListener() {
				public void actionPerformed(ActionEvent evt) {
					jButtonActionPerformed(evt);
				}
			});
		}
		return jButton;
	}

	/**
	 * This method initializes jButton1
	 * 
	 * @return javax.swing.JButton
	 */
	private JButton getJButton1() {
		if (jButton1 == null) {
			jButton1 = new JButton();
			jButton1.setBounds(new Rectangle(190, 286, 80, 31));
			jButton1.setText("取消");
			jButton1.addActionListener(new ActionListener() {
				public void actionPerformed(ActionEvent evt) {
					jButton1ActionPerformed(evt);
				}
			});
		}
		return jButton1;
	}

	private void jButton1ActionPerformed(ActionEvent evt) {
		// System.out.println("jButton1.actionPerformed, event=" + evt);
		this.setVisible(false);
		// TODO add your code for jButton1.actionPerformed
	}

	private void jButtonActionPerformed(ActionEvent evt) {
		// System.out.println("jButton.actionPerformed, event=" + evt);
		if (jTextField1.getText().equals(jTextField2.getText())) {
			string = new String[5];
			string[0] = " \'" + jTextField.getText() + "\', ";
			string[1] = " 0, ";
			string[2] = " \'" + jTextField3.getText() + "\', ";
			string[3] = " \'" + jTextField4.getText() + "\', ";
			string[4] = " \'" + jTextField1.getText() + "\' ";
			try {
				Class.forName(Driver);
				connection = DriverManager.getConnection(url, null, null);
				
				statement = connection.prepareStatement("SELECT Num FROM Accounts WHERE Num = ?");
		        statement.setString(1, jTextField.getText());

		        ResultSet result = statement.executeQuery();
		       if (result.next()){
					JOptionPane.showMessageDialog(null,
							"The Account is already exsit!", "Message error",
							JOptionPane.ERROR_MESSAGE);
		       }
		       else{
				statement = connection.prepareStatement("insert into Accounts values ( "
						+ string[0] + string[1] + string[2] + string[3]
						+ string[4] + " )");
				statement.executeUpdate();
				connection.close();
				JOptionPane.showMessageDialog(null, "SQL command executed",
						"Operator succeed", JOptionPane.OK_OPTION);
			   }
			} catch (Exception ex) {
				System.out.println(ex);
			}

			this.setVisible(false);
		} else
			JOptionPane.showMessageDialog(null,
					"Please ensure your password is right!", "Message error",
					JOptionPane.ERROR_MESSAGE);
		// TODO add your code for jButton.actionPerformed
	}
} // @jve:decl-index=0:visual-constraint="81,7"