deleteinformation.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 deleteinformation {

	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;

	/**
	 * Launch the application
	 * @param args
	 */
	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;			
    }		
	public static void main(String args[]) {
		try {
			deleteinformation window = new deleteinformation();
			window.frame.setVisible(true);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	/**
	 * Create the application
	 */
	public deleteinformation() {
		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(212, 29, 121, 23);
		frame.getContentPane().add(label);

		final JLabel label_1 = new JLabel();
		label_1.setText("机器号：");
		label_1.setBounds(50, 157, 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(50, 105, 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, 154, 110, 21);
		frame.getContentPane().add(textField);

		textField_1 = new JTextField();
		textField_1.setBounds(120, 102, 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();
				try{
				Connection con=getConnection();
				Statement stmt=con.createStatement();
					String sql = "delete from employinformation  where employeeid='"+employeeid+"' ";
					textField.setText(null);
					textField_1.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);				
					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]);
					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.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)){
								String values = rs.getString("name");
								String values_1 = rs.getString("birth");
								String values_2 = rs.getString("sex");
								String values_3 = rs.getString("nation");
								String values_4 = rs.getString("nativeplace");
								String values_5 = rs.getString("familyplace");
								String values_6 = rs.getString("phone");
								String values_7 = rs.getString("party");
								String values_8 = rs.getString("marriagestate");
								String values_9 = rs.getString("degree");
								String values_10 = rs.getString("profissionalposition");
								String values_11 = rs.getString("position");
								String values_12 = rs.getString("department");
								String values_13 = rs.getString("remark");
								textField_2.setText(values);
								textField_3.setText(values_1);
								textField_4.setText(values_2);
								textField_5.setText(values_3);
								textField_6.setText(values_4);
								textField_7.setText(values_5);
								textField_8.setText(values_6);
								textField_9.setText(values_7);
								textField_10.setText(values_8);
								textField_11.setText(values_9);
								textField_12.setText(values_10);
								textField_13.setText(values_11);
								textField_14.setText(values_12);
								textArea.setText(values_13);
								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]);
							}
						}
						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_1.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(265, 101, 85, 23);
		frame.getContentPane().add(button_2);
	}

}