package com.source;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;}