adddeleteuser.java~1~

Java+MySQL开发员工管理系统

package classPackage;

import java.awt.event.*;
import java.awt.*;
import javax.swing.*;

public class AddDeleteUser extends javax.swing.JInternalFrame {
 
    public AddDeleteUser() {
        initComponents();
        this.setVisible(true);
        this.setClosable(true);
        this.setSize(268,350);
    }
    
    private void initComponents() {
        jLabel1 = new javax.swing.JLabel();
        jLabel2 = new javax.swing.JLabel();
        jLabel3 = new javax.swing.JLabel();
        txtname = new javax.swing.JTextField();
        pas1 = new javax.swing.JPasswordField();
        pas2 = new javax.swing.JPasswordField();
        butOk = new javax.swing.JButton();
        butACancel = new javax.swing.JButton();
        jLabel4 = new javax.swing.JLabel();
        cbUserName = new javax.swing.JComboBox();
        jLabel5 = new javax.swing.JLabel();
        pas3 = new javax.swing.JPasswordField();
        butDelete = new javax.swing.JButton();
        butDCancel = new javax.swing.JButton();

        getContentPane().setLayout(null);

        jLabel1.setText("\u65b0\u7528\u6237\u540d:");
        getContentPane().add(jLabel1);
        jLabel1.setBounds(30, 30, 70, 20);

        jLabel2.setText("\u8f93\u5165\u5bc6\u7801:");
        getContentPane().add(jLabel2);
        jLabel2.setBounds(30, 60, 70, 18);

        jLabel3.setText("\u786e\u8ba4\u5bc6\u7801:");
        getContentPane().add(jLabel3);
        jLabel3.setBounds(30, 90, 60, 18);

        getContentPane().add(txtname);
        txtname.setBounds(100, 30, 130, 24);

        getContentPane().add(pas1);
        pas1.setBounds(100, 60, 130, 24);

        getContentPane().add(pas2);
        pas2.setBounds(100, 90, 130, 24);

        butOk.setText("\u6dfb\u52a0");

        getContentPane().add(butOk);
        butOk.setBounds(80, 130, 70, 27);

        butACancel.setText("\u53d6\u6d88");
        getContentPane().add(butACancel);
        butACancel.setBounds(160, 130, 70, 27);

        jLabel4.setText("\u5df2\u6709\u7528\u6237\u540d:");
        getContentPane().add(jLabel4);
        jLabel4.setBounds(30, 180, 80, 18);

        getContentPane().add(cbUserName);
        cbUserName.setBounds(100, 180, 130, 24);

        jLabel5.setText("\u5bc6\u7801:");
        getContentPane().add(jLabel5);
        jLabel5.setBounds(30, 210, 60, 18);

        getContentPane().add(pas3);
        pas3.setBounds(100, 216, 130, 24);

        butDelete.setText("\u5220\u9664");
        getContentPane().add(butDelete);
        butDelete.setBounds(79, 260, 70, 27);

        butDCancel.setText("\u53d6\u6d88");
        getContentPane().add(butDCancel);
        butDCancel.setBounds(160, 260, 70, 27);
        
//将所有用用户名读出来
         Database.joinDB();
         String sql="select * from UserInformation";
         try{
         	if(Database.query(sql)){
         		while(Database.rs.next()){
         			String name=Database.rs.getString("User_Name");
         			cbUserName.addItem(name);
         			}
         		}
         	}
         catch(Exception e){}  
         
//为添加和取消按钮加事件-----------------------------------------
        butOk.addActionListener(new ActionListener(){
        	public void actionPerformed(ActionEvent e){
				if(txtname.getText().equals("")){
					new JOptionPane().showMessageDialog(null,"用户名不能为空!");
					}
				else if(pas1.getText().equals("")){
					new JOptionPane().showMessageDialog(null,"密码不能为空!");				
					}
				else if(pas1.getText().equals(pas2.getText())){
					String sql="insert UserInformation values('"+ txtname.getText() +"','"+ pas1.getText() +"','B')";
					try{
						if(Database.executeSQL(sql)){
					    	new JOptionPane().showMessageDialog(null,"添加成功！");
         			        cbUserName.addItem(txtname.getText());
         		         }
						}
					catch(Exception ea){}
					}        		
        		}
        	});
        
        butACancel.addActionListener(new ActionListener(){
        	public void actionPerformed(ActionEvent e){
        		txtname.setText("");
        		pas1.setText("");
        		pas2.setText("");
        		}
        	});
//--------------------------------------------------------------

//为删除和取消按钮加事件---------------------------------------
        butDelete.addActionListener(new ActionListener(){
        	public void actionPerformed(ActionEvent e){
         		String name="" + cbUserName.getSelectedItem();
         		String sql="select * from UserInformation where User_Name='"+ name +"'";
         		try{
         		   if(Database.query(sql)){
         		   	    Database.rs.next();
	         			String pas=pas3.getText();
	         			String password=Database.rs.getString("Password");
	         			System.out.println(password);
	         			if(pas.equals(password)){
	         					String sdelete="delete from UserInformation where User_Name='"+ name +"'";
	         					if(Database.executeSQL(sdelete)){
	         						new JOptionPane().showMessageDialog(null,"删除成功！");
                                    pas3.setText("");
                                    cbUserName.removeAllItems();
                                    String sql1="select * from UserInformation";
						         	if(Database.query(sql1)){
						         		while(Database.rs.next()){
						         			String name1=Database.rs.getString("User_Name");
						         			cbUserName.addItem(name1);
						         			}
						         		}
	         						}
	         				}
	         			else{
	         				new JOptionPane().showMessageDialog(null,"密码不正确！");
	         				}
	         			}
	         	    }
	         	 catch(Exception el){
	         	 	System.out.println(el);
	         	 	}        		
        		}
        	});

        butACancel.addActionListener(new ActionListener(){
        	public void actionPerformed(ActionEvent e){
        		pas3.setText("");
        		}
        	});
//--------------------------------------------------------------
    }
    private javax.swing.JButton butACancel;
    private javax.swing.JButton butDCancel;
    private javax.swing.JButton butDelete;
    private javax.swing.JButton butOk;
    private javax.swing.JComboBox cbUserName;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel2;
    private javax.swing.JLabel jLabel3;
    private javax.swing.JLabel jLabel4;
    private javax.swing.JLabel jLabel5;
    private javax.swing.JPasswordField pas1;
    private javax.swing.JPasswordField pas2;
    private javax.swing.JPasswordField pas3;
    private javax.swing.JTextField txtname;
    
}