empdialog.java

大型数据库课程设计源码

package com.vbank.admin.component;

import com.vbank.db.*;
import javax.swing.JPanel;
import java.awt.Frame;
import java.awt.BorderLayout;
import javax.swing.JDialog;
import java.awt.Dimension;
import java.awt.Rectangle;
import java.awt.GridBagLayout;
import javax.swing.JLabel;
import javax.swing.JTextField;
import java.awt.Point;
import java.util.Vector;

import javax.swing.JButton;

public class EmpDialog extends JDialog {

	private static final long serialVersionUID = 1L;

	private JPanel jContentPane = null;

	private JPanel jPanel = 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 JLabel jLabel6 = null;

	private JTextField jTextField5 = null;

	private JLabel jLabel7 = null;

	private JTextField jTextField6 = null;

	private JLabel jLabel8 = null;

	private JTextField jTextField7 = null;

	private JLabel jLabel9 = null;

	private JTextField jTextField8 = null;

	private JTextField jTextField9 = null;

	private JButton jButton = null;

	private JButton jButton1 = null;

	private JButton jButton2 = null;
	
	private Vector v;

	/**
	 * @param owner
	 */
	public EmpDialog(Frame owner) {
		super(owner);
		initialize();
	}

	/**
	 * This method initializes this
	 * 
	 * @return void
	 */
	private void initialize() {
		this.setSize(410, 404);
		this.setBounds(200, 100, 450, 460);
		this.setContentPane(getJContentPane());
	}

	/**
	 * This method initializes jContentPane
	 * 
	 * @return javax.swing.JPanel
	 */
	private JPanel getJContentPane() {
		if (jContentPane == null) {
			jLabel9 = new JLabel();
			jLabel9.setText("工资：");
			jLabel9.setSize(new Dimension(60, 28));
			jLabel9.setLocation(new Point(68, 290));
			jLabel8 = new JLabel();
			jLabel8.setText("电话：");
			jLabel8.setSize(new Dimension(60, 28));
			jLabel8.setLocation(new Point(68, 260));
			jLabel7 = new JLabel();
			jLabel7.setText("住址：");
			jLabel7.setLocation(new Point(68, 230));
			jLabel7.setSize(new Dimension(60, 28));
			jLabel6 = new JLabel();
			jLabel6.setText("雇佣日期：");
			jLabel6.setSize(new Dimension(60, 28));
			jLabel6.setLocation(new Point(68, 200));
			jLabel5 = new JLabel();
			jLabel5.setText("身份证：");
			jLabel5.setLocation(new Point(68, 170));
			jLabel5.setSize(new Dimension(60, 28));
			jLabel4 = new JLabel();
			jLabel4.setText("年龄：");
			jLabel4.setLocation(new Point(68, 140));
			jLabel4.setSize(new Dimension(60, 28));
			jLabel3 = new JLabel();
			jLabel3.setText("性别：");
			jLabel3.setSize(new Dimension(60, 28));
			jLabel3.setLocation(new Point(68, 110));
			jLabel2 = new JLabel();
			jLabel2.setText("姓名：");
			jLabel2.setLocation(new Point(68, 80));
			jLabel2.setSize(new Dimension(60, 28));
			jLabel1 = new JLabel();
			jLabel1.setText("编号：");
			jLabel1.setSize(new Dimension(60, 28));
			jLabel1.setLocation(new Point(68, 50));
			jContentPane = new JPanel();
			jContentPane.setLayout(null);
			jContentPane.add(getJPanel(), 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(jLabel6, null);
			jContentPane.add(getJTextField5(), null);
			jContentPane.add(jLabel7, null);
			jContentPane.add(getJTextField6(), null);
			jContentPane.add(jLabel8, null);
			jContentPane.add(getJTextField7(), null);
			jContentPane.add(jLabel9, null);
			//jContentPane.add(getJTextField8(), null);
			jContentPane.add(getJTextField9(), null);
			jContentPane.add(getJButton(), null);
			jContentPane.add(getJButton1(), null);
			jContentPane.add(getJButton2(), null);
		}
		return jContentPane;
	}

	/**
	 * This method initializes jPanel	
	 * 	
	 * @return javax.swing.JPanel	
	 */
	private JPanel getJPanel() {
		if (jPanel == null) {
			jLabel = new JLabel();
			jLabel.setBounds(new Rectangle(110, 5, 123, 28));
			jLabel.setText("新员工注册");
			jPanel = new JPanel();
			jPanel.setLayout(null);
			jPanel.setBounds(new Rectangle(3, 5, 381, 34));
			jPanel.add(jLabel, null);
		}
		return jPanel;
	}

	/**
	 * This method initializes jTextField	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextField() {
		if (jTextField == null) {
			jTextField = new JTextField();
			jTextField.setSize(new Dimension(120, 23));
			jTextField.setLocation(new Point(145, 50));
		}
		return jTextField;
	}

	/**
	 * This method initializes jTextField1	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextField1() {
		if (jTextField1 == null) {
			jTextField1 = new JTextField();
			jTextField1.setSize(new Dimension(120, 23));
			jTextField1.setLocation(new Point(145, 80));
		}
		return jTextField1;
	}

	/**
	 * This method initializes jTextField2	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextField2() {
		if (jTextField2 == null) {
			jTextField2 = new JTextField();
			jTextField2.setLocation(new Point(145, 110));
			jTextField2.setSize(new Dimension(120, 23));
		}
		return jTextField2;
	}

	/**
	 * This method initializes jTextField3	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextField3() {
		if (jTextField3 == null) {
			jTextField3 = new JTextField();
			jTextField3.setSize(new Dimension(120, 23));
			jTextField3.setLocation(new Point(145, 140));
		}
		return jTextField3;
	}

	/**
	 * This method initializes jTextField4	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextField4() {
		if (jTextField4 == null) {
			jTextField4 = new JTextField();
			jTextField4.setLocation(new Point(145, 170));
			jTextField4.setSize(new Dimension(189, 23));
		}
		return jTextField4;
	}

	/**
	 * This method initializes jTextField5	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextField5() {
		if (jTextField5 == null) {
			jTextField5 = new JTextField();
			jTextField5.setSize(new Dimension(120, 23));
			jTextField5.setLocation(new Point(145, 200));
		}
		return jTextField5;
	}

	/**
	 * This method initializes jTextField6	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextField6() {
		if (jTextField6 == null) {
			jTextField6 = new JTextField();
			jTextField6.setSize(new Dimension(186, 23));
			jTextField6.setLocation(new Point(145, 230));
		}
		return jTextField6;
	}

	/**
	 * This method initializes jTextField7	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextField7() {
		if (jTextField7 == null) {
			jTextField7 = new JTextField();
			jTextField7.setLocation(new Point(145, 260));
			jTextField7.setSize(new Dimension(120, 23));
		}
		return jTextField7;
	}

	/**
	 * This method initializes jTextField8	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextField8() {
		if (jTextField8 == null) {
			jTextField8 = new JTextField();
			jTextField8.setSize(new Dimension(120, 23));
			jTextField8.setLocation(new Point(145, 260));
		}
		return jTextField8;
	}

	/**
	 * This method initializes jTextField9	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextField9() {
		if (jTextField9 == null) {
			jTextField9 = new JTextField();
			jTextField9.setSize(new Dimension(120, 23));
			jTextField9.setLocation(new Point(145, 290));
		}
		return jTextField9;
	}

	/**
	 * This method initializes jButton	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getJButton() {
		if (jButton == null) {
			jButton = new JButton();
			jButton.setBounds(new Rectangle(54, 330, 78, 34));
			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()
					commitData();
					
				}
			});
		}
		return jButton;
	}
	protected Vector commitData() {
		  v=new Vector();
		v.add(jTextField.getText().trim() );
		v.add( jTextField1.getText().trim());
		v.add(jTextField2.getText().trim() );
		v.add(jTextField3.getText().trim() );
		v.add(jTextField4.getText().trim() );
		v.add(jTextField5.getText().trim() );
		v.add(jTextField6.getText().trim() );
		v.add(jTextField7.getText().trim() );
		v.add(jTextField9.getText().trim() );
		
		String sql="insert into employee values('"+
		jTextField.getText().trim()+"','"+
		jTextField1.getText().trim()+"','"+
		jTextField2.getText().trim()+"',"+
		new Integer(jTextField3.getText().trim()).intValue()+",'"+
		jTextField4.getText().trim()+"','"+
		jTextField5.getText().trim()+"','"+
		jTextField6.getText().trim()+"','"+
		jTextField7.getText().trim()+"',"+
		//jTextField8.getText().trim()+","+
		new Float(jTextField9.getText().trim()).floatValue()
		+")";
		this.dispose();
		System.out.println(sql);
		DBManager.getConnection();
		DBManager.execInsert(sql);
		DBManager.releaseCon();
		
		return v;
	}
	private void showDialog() {
		this.setVisible(true);
	}
	/**
	 * This method initializes jButton1	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getJButton1() {
		if (jButton1 == null) {
			jButton1 = new JButton();
			jButton1.setText("下一个");
			jButton1.setLocation(new Point(150, 330));
			jButton1.setSize(new Dimension(78, 34));
			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()
					commitData();
					jTextField.setText("");
					jTextField1.setText("");
					jTextField2.setText("");
					jTextField3.setText("");
					jTextField4.setText("");
					jTextField5.setText("");
					jTextField6.setText("");
					jTextField7.setText("");
					jTextField9.setText("");
					showDialog();
				}
			});
		}
		return jButton1;
	}

	/**
	 * This method initializes jButton2	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getJButton2() {
		if (jButton2 == null) {
			jButton2 = new JButton();
			jButton2.setLocation(new Point(243, 330));
			jButton2.setText("取消");
			jButton2.setSize(new Dimension(78, 34));
			jButton2.addActionListener(new java.awt.event.ActionListener() {
				public void actionPerformed(java.awt.event.ActionEvent e) {
					cancel() ; // TODO Auto-generated Event stub actionPerformed()
				}
			});
		}
		return jButton2;
	}
	private void cancel() {
		this.dispose();
	}

	/**
	 * @return v
	 */
	public Vector getV() {
		return v;
	}

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