addinformation.java

添加员工信息的界面程序

import java.awt.Font;
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.SQLException;
import java.sql.Statement;

import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JTextArea;
import javax.swing.JTextField;


public class addinformation {

	private JTextArea textArea;
	private JTextField textField_14;
	private JTextField textField_13;
	private JTextField textField_12;
	private JTextField textField_11;
	private JTextField textField_10;
	private JTextField textField_9;
	private JTextField textField_8;
	private JTextField textField_7;
	private JTextField textField_6;
	private JTextField textField_5;
	private JTextField textField_4;
	private JTextField textField_3;
	private JTextField textField_2;
	private JTextField textField_1;
	private JTextField textField;
	public JFrame frame;
	public static Connection getConnection() throws SQLException,java.lang.ClassNotFoundException 
	{		                       
		String url="jdbc:mysql://localhost:3306/optimizesystem";
        Class.forName("com.mysql.jdbc.Driver");		        
        String userName="root";		
        String password="123";		
        Connection con=DriverManager.getConnection(url, userName, password);	
        return con;			
    }		

	/**
	 * Launch the application
	 * @param args
	 */
	public static void main(String args[]) {
		try {
			addinformation window = new addinformation();
			window.frame.setVisible(true);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	/**
	 * Create the application
	 */
	public addinformation() {
		initialize();
	}

	/**
	 * Initialize the contents of the frame
	 */
	private void initialize() {
		frame = new JFrame("添加职工基本信息");
		frame.getContentPane().setLayout(null);
		frame.setBounds(100, 100, 517, 649);
		frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

		final JLabel label = new JLabel();
		label.setFont(new Font("", Font.BOLD, 16));
		label.setText("添加职工基本信息");
		label.setBounds(207, 50, 151, 23);
		frame.getContentPane().add(label);

		final JLabel label_1 = new JLabel();
		label_1.setText("机器号：");
		label_1.setBounds(45, 160, 60, 15);
		frame.getContentPane().add(label_1);

		final JLabel label_2 = new JLabel();
		label_2.setText("党团关系：");
		label_2.setBounds(260, 190, 85, 15);
		frame.getContentPane().add(label_2);

		final JLabel label_3 = new JLabel();
		label_3.setText("员工号：");
		label_3.setBounds(45, 128, 60, 15);
		frame.getContentPane().add(label_3);

		final JLabel label_4 = new JLabel();
		label_4.setText("婚姻状况：");
		label_4.setBounds(260, 220, 85, 15);
		frame.getContentPane().add(label_4);

		final JLabel label_5 = new JLabel();
		label_5.setText("姓名：");
		label_5.setBounds(60, 190, 60, 15);
		frame.getContentPane().add(label_5);

		final JLabel label_6 = new JLabel();
		label_6.setText("学历：");
		label_6.setBounds(285, 250, 60, 15);
		frame.getContentPane().add(label_6);

		final JLabel label_7 = new JLabel();
		label_7.setText("生日：");
		label_7.setBounds(60, 220, 60, 15);
		frame.getContentPane().add(label_7);

		final JLabel label_8 = new JLabel();
		label_8.setText("专业职称：");
		label_8.setBounds(260, 280, 85, 15);
		frame.getContentPane().add(label_8);

		final JLabel label_9 = new JLabel();
		label_9.setText("性别：");
		label_9.setBounds(60, 250, 60, 15);
		frame.getContentPane().add(label_9);

		final JLabel label_10 = new JLabel();
		label_10.setText("职务：");
		label_10.setBounds(285, 310, 60, 15);
		frame.getContentPane().add(label_10);

		final JLabel label_11 = new JLabel();
		label_11.setText("民族：");
		label_11.setBounds(60, 280, 60, 15);
		frame.getContentPane().add(label_11);

		final JLabel label_12 = new JLabel();
		label_12.setText("部门：");
		label_12.setBounds(285, 340, 59, 15);
		frame.getContentPane().add(label_12);

		final JLabel label_13 = new JLabel();
		label_13.setText("籍贯：");
		label_13.setBounds(60, 310, 60, 15);
		frame.getContentPane().add(label_13);

		final JLabel label_14 = new JLabel();
		label_14.setText("备注：");
		label_14.setBounds(64, 388, 60, 15);
		frame.getContentPane().add(label_14);

		final JLabel label_15 = new JLabel();
		label_15.setText("家庭住址：");
		label_15.setBounds(40, 340, 78, 15);
		frame.getContentPane().add(label_15);

		final JLabel label_16 = new JLabel();
		label_16.setText("电话号码：");
		label_16.setBounds(260, 160, 85, 15);
		frame.getContentPane().add(label_16);

		textField = new JTextField();
		textField.setBounds(120, 157, 110, 21);
		frame.getContentPane().add(textField);

		textField_1 = new JTextField();
		textField_1.setBounds(120, 125, 110, 21);
		frame.getContentPane().add(textField_1);

		textField_2 = new JTextField();
		textField_2.setBounds(120, 190, 110, 21);
		frame.getContentPane().add(textField_2);

		textField_3 = new JTextField();
		textField_3.setBounds(120, 220, 110, 21);
		frame.getContentPane().add(textField_3);

		textField_4 = new JTextField();
		textField_4.setBounds(120, 250, 110, 21);
		frame.getContentPane().add(textField_4);

		textField_5 = new JTextField();
		textField_5.setBounds(120, 280, 110, 21);
		frame.getContentPane().add(textField_5);

		textField_6 = new JTextField();
		textField_6.setBounds(120, 310, 110, 21);
		frame.getContentPane().add(textField_6);

		textField_7 = new JTextField();
		textField_7.setBounds(120, 340, 110, 21);
		frame.getContentPane().add(textField_7);

		textField_8 = new JTextField();
		textField_8.setBounds(340, 160, 110, 21);
		frame.getContentPane().add(textField_8);

		textField_9 = new JTextField();
		textField_9.setBounds(340, 190, 110, 21);
		frame.getContentPane().add(textField_9);

		textField_10 = new JTextField();
		textField_10.setBounds(340, 220, 110, 21);
		frame.getContentPane().add(textField_10);

		textField_11 = new JTextField();
		textField_11.setBounds(340, 250, 110, 21);
		frame.getContentPane().add(textField_11);

		textField_12 = new JTextField();
		textField_12.setBounds(340, 280, 110, 21);
		frame.getContentPane().add(textField_12);

		textField_13 = new JTextField();
		textField_13.setBounds(340, 310, 110, 21);
		frame.getContentPane().add(textField_13);

		textField_14 = new JTextField();
		textField_14.setBounds(340, 340, 110, 21);
		frame.getContentPane().add(textField_14);

		textArea = new JTextArea();
		textArea.setBounds(120, 388, 320, 91);
		frame.getContentPane().add(textArea);

		final JButton button = new JButton();
		button.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent arg0) {
				String employeeid=textField_1.getText();
				String name=textField_2.getText();
				String birth=textField_3.getText();
				String sex=textField_4.getText();
				String nation=textField_5.getText();
				String nativeplace=textField_6.getText();
				String familyplace=textField_7.getText();
				String phone=textField_8.getText();
				String party=textField_9.getText();
				String marriagestate=textField_10.getText();
				String degree=textField_11.getText();
				String profissionalposition=textField_12.getText();
				String position=textField_13.getText();
				String department=textField_14.getText();
				String remark=textArea.getText();
				try{
					java.util.Random r = new java.util.Random();
			        String random = "";
			        for (int i=0;i<8;i++){
			            random += Integer.toString(r.nextInt(36) ,36);
			        }
			        textField.setText(random);
				    Connection con=getConnection();
				    Statement stmt=con.createStatement();
					String sql = "insert into employinformation(id,employeeid,name,birth,sex,nation,nativeplace," +
					"familyplace,phone,party,marriagestate,degree,profissionalposition,position,department,remark)" +
					" values('"+random+"','"+employeeid+"','"+name+"','"+birth+"','"+sex+"','"+nation+"','"+nativeplace+"'," +
							"'"+familyplace+"','"+phone+"','"+party+"','"+marriagestate+"','"+degree+"','"+profissionalposition+"'," +
									"'"+position+"','"+department+"','"+remark+"')";
					stmt.executeUpdate(sql);
					Object[] options={"是（y）","否（n）","取消",};
					String str1=new String("提示！数据已写入！");
					JOptionPane.showOptionDialog(null,str1,"提示窗口",JOptionPane.DEFAULT_OPTION,JOptionPane.WARNING_MESSAGE,null,options,options[0]);
				}
			      catch(java.lang.ClassNotFoundException e){			    
				     	 System.err.print(" ClassNotFoundException: ");			         
				     	 System.err.println(e.getMessage());
				      }		
				      catch(SQLException ex){			                 
				     	 System.err.println(" SQLException: "+ex.getMessage());	
				      }	
					catch(Exception e) {
						e.printStackTrace();
					}
		}});
		button.setText("确定");
		button.setBounds(172, 530, 95, 23);
		frame.getContentPane().add(button);

		final JButton button_1 = new JButton();
		button_1.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent arg0) {
				frame.dispose();
			}
		});
		button_1.setText("取消");
		button_1.setBounds(319, 530, 95, 23);
		frame.getContentPane().add(button_1);

		final JButton button_2 = new JButton();
		button_2.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent arg0) {
				String employeeid=textField_1.getText();
				try{
					Connection con=getConnection();
			        Statement stmt=con.createStatement();
			        String query="select * from employinformation where employeeid='"+employeeid+"' ";
			        ResultSet rs=stmt.executeQuery(query);
					if(employeeid.equals(""))
					{
						Object[] options={"是（y）","否（n）","取消",};
						String str1=new String("警告！员工号不能为空，请重新输入！");
						JOptionPane.showOptionDialog(null,str1,"警告窗口",JOptionPane.DEFAULT_OPTION,JOptionPane.WARNING_MESSAGE,null,options,options[0]);
						textField_1.setText(null);
					}
					else{
				        
				        if(rs.next()){
				        	String e=rs.getString("employeeid");
				        	if(e.equals(employeeid)){
				        		Object[] options={"是（y）","否（n）","取消",};
				        		String str1=new String("警告！员工号已存在，请重新安排员工号！");
				        		JOptionPane.showOptionDialog(null,str1,"警告窗口",JOptionPane.DEFAULT_OPTION,JOptionPane.WARNING_MESSAGE,null,options,options[0]);
				        		textField_1.setText(null);
				        	}
				        	else{
				        		Object[] options={"是（y）","否（n）","取消",};
				        		String str1=new String("连接数据库失败！");
				        		JOptionPane.showOptionDialog(null,str1,"警告窗口",JOptionPane.DEFAULT_OPTION,JOptionPane.WARNING_MESSAGE,null,options,options[0]);
				        	}
				        }
				        else{
				        	Object[] options={"是（y）","否（n）","取消",};
				        	String str1=new String("提示！员工号不存在，可以添加新信息！");
				        	JOptionPane.showOptionDialog(null,str1,"警告窗口",JOptionPane.DEFAULT_OPTION,JOptionPane.WARNING_MESSAGE,null,options,options[0]);
				        	textField.setText(null);
				        	textField_2.setText(null);
				        	textField_3.setText(null);
				        	textField_4.setText(null);
				        	textField_5.setText(null);
				        	textField_6.setText(null);
				        	textField_7.setText(null);
				        	textField_8.setText(null);
				        	textField_9.setText(null);
				        	textField_10.setText(null);
				        	textField_11.setText(null);
				        	textField_12.setText(null);
				        	textField_13.setText(null);
				        	textField_14.setText(null);
				        	textArea.setText(null);
				        }
				        rs.close();
				        stmt.close();
				        con.close();
						}
					}catch(java.lang.ClassNotFoundException e){			    
				     	 System.err.print(" ClassNotFoundException: ");			         
				     	 System.err.println(e.getMessage());
				      }		
					catch(SQLException ex){			                 
				     	 System.err.println(" SQLException: "+ex.getMessage());	
				      }	
					catch(Exception e) {
						e.printStackTrace();
					}
		}});
		button_2.setText("查询");
		button_2.setBounds(260, 124, 60, 23);
		frame.getContentPane().add(button_2);
	
	}

}