//添加刪除用戶類package classsource;import java.awt.event.*;import java.awt.*;import javax.swing.*;import java.sql.*;public class AddDeleteUser extends javax.swing.JInternalFrame {		private JButton butACancel,butDCancel,butDelete,butOk;    private JComboBox cbUserName;    private JLabel jLabel1,jLabel2,jLabel3,jLabel4,jLabel5;    private JPasswordField pas1,pas2,pas3;    private JTextField txtname;    public AddDeleteUser() {//空構造        initComponents();        this.setVisible(true);        this.setClosable(true);        this.setSize(268,350);           }    private void initComponents() {    	    	//實例化并添加控件        jLabel1 = new JLabel();        jLabel2 = new JLabel();        jLabel3 = new JLabel();        txtname = new JTextField();        pas1 = new JPasswordField();        pas2 = new JPasswordField();        butOk = new JButton();        butACancel = new JButton();        jLabel4 = new JLabel();        cbUserName = new JComboBox();        jLabel5 = new JLabel();        pas3 = new JPasswordField();        butDelete = new JButton();        butDCancel = new JButton();        //實例化并添加控件完成        getContentPane().setLayout(null);//設置布局                        //為空間放置具體位置        jLabel1.setText("新用戶名:");        getContentPane().add(jLabel1);        jLabel1.setBounds(30, 30, 70, 20);        jLabel2.setText("輸入密碼:");        getContentPane().add(jLabel2);        jLabel2.setBounds(30, 60, 70, 18);        jLabel3.setText("確認密碼:");        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("添加");        getContentPane().add(butOk);        butOk.setBounds(80, 130, 70, 27);        butACancel.setText("清空");        getContentPane().add(butACancel);        butACancel.setBounds(160, 130, 70, 27);        jLabel4.setText("已有用戶名:");        getContentPane().add(jLabel4);        jLabel4.setBounds(30, 180, 80, 18);        getContentPane().add(cbUserName);        cbUserName.setBounds(100, 180, 130, 24);        jLabel5.setText("密碼:");        getContentPane().add(jLabel5);        jLabel5.setBounds(30, 210, 60, 18);        getContentPane().add(pas3);        pas3.setBounds(100, 216, 130, 24);        butDelete.setText("刪除");        getContentPane().add(butDelete);        butDelete.setBounds(79, 260, 70, 27);        butDCancel.setText("清空");        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);	         	 	}        		}        	});        butDCancel.addActionListener(new ActionListener(){        	public void actionPerformed(ActionEvent e){        		pas3.setText("");        		}        	});//--------------------------------------------------------------    }}