package frame;

import javax.swing.*;
import model.FrameInit;
import com.DAO;
import java.awt.event.*;
import java.sql.*;
import java.awt.*;
public class DeleteEmployee extends JFrame{
	JFrame de = new JFrame("刪除員工信息");
	JPanel p = new JPanel();
	JPanel ptop = new JPanel();
	JLabel lblename = new JLabel("請選擇要刪除的員工姓名:");
	JComboBox cboename = new JComboBox();
	JButton btndelete = new JButton("刪除");
	public DeleteEmployee(){
		init();
	}
	public void init(){
		FrameInit.InitFrame(de, p);
		p.setLayout(new BorderLayout());
		p.add(ptop, BorderLayout.CENTER);
		//打開窗口時的事件監(jiān)聽，初始化下拉列表ename
		de.addWindowListener(new WindowAdapter(){
			public void windowOpened(WindowEvent e){
				ResultSet rs = DAO.getEmployeeName();
				try{
					while(rs.next()){
						cboename.addItem(rs.getString("ename"));
					}
				}catch(Exception ex){
					System.out.println(ex.getMessage());
				}
			}
		});
	
		ptop.add(lblename);
		ptop.add(cboename);
		ptop.add(btndelete);
		//刪除按鈕的事件監(jiān)聽程序
		btndelete.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e){
				String name = cboename.getSelectedItem().toString().trim();
				boolean flag = DAO.deleteEmployee(name);
				if(flag){
					JOptionPane.showMessageDialog(null, "刪除信息成功！","友情提示",JOptionPane.INFORMATION_MESSAGE);
					return;
				}else{
					JOptionPane.showMessageDialog(null, "刪除失敗！請檢查！","發(fā)生錯誤",JOptionPane.ERROR_MESSAGE);
					return;
				}
			}
		});
		de.setSize(500,80);
		de.setVisible(true);
	}
}