employeesdialog.java

java+sql2000企业人力管理系统

package managersystem.Emp;

import java.awt.BorderLayout;
import java.awt.Frame;

import javax.swing.JDialog;
import javax.swing.JPanel;
import java.awt.*;
import javax.swing.border.TitledBorder;
import javax.swing.BorderFactory;
import javax.swing.border.Border;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JButton;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import managersystem.CustomTableModule;
import javax.swing.JOptionPane;
import javax.swing.JTextField;
import javax.swing.JLabel;
import javax.swing.ImageIcon;
import javax.swing.UIManager;

/**
 * <p>Title: 企业人力资源管理系统</p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2008</p>
 *
 * <p>Company: </p>
 *
 * @author 腾龙工作室
 * @version 1.0
 */
public class EmployeesDialog extends JDialog {
    JPanel panel1 = new JPanel();
    JPanel jPanel1 = new JPanel();
    TitledBorder titledBorder1 = new TitledBorder("");
    Border border1 = BorderFactory.createEtchedBorder(Color.white,
            new Color(165, 163, 151));
    Border border2 = new TitledBorder(border1, "查询条件");
    JScrollPane jScrollPane1 = new JScrollPane();
    JTable tabEmp = new JTable();
    JButton btnAdd = new JButton();
    JButton btnDel = new JButton();
    JButton btnUpdate = new JButton();
    JButton btnEsc = new JButton();
    JTextField txtEmp_id = new JTextField();
    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    JLabel jLabel3 = new JLabel();
    JLabel jLabel4 = new JLabel();
    JTextField txtName = new JTextField();
    JTextField txtTitle = new JTextField();
    JTextField txtPosition = new JTextField();
    JButton btnSearch = new JButton();
    JButton btnBack = new JButton();
    public EmployeesDialog(Frame owner, String title, boolean modal) {
        super(owner, title, modal);
        try {
            setDefaultCloseOperation(DISPOSE_ON_CLOSE);
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    public EmployeesDialog() {
        this(new Frame(), "EmployeesDialog", false);
    }

    private void jbInit() throws Exception {
        this.setSize(560, 500);
        panel1.setLayout(null);
        jPanel1.setBackground(new Color(214, 228, 255));
        jPanel1.setBorder(border2);
        jPanel1.setBounds(new Rectangle(4, 10, 543, 189));
        jPanel1.setLayout(null);
        jScrollPane1.getViewport().setBackground(UIManager.getColor(
                "ToolBar.light"));
        jScrollPane1.setBounds(new Rectangle(6, 199, 539, 195));
        btnAdd.setBounds(new Rectangle(75, 418, 71, 25));
        btnAdd.setText("");
        btnAdd.addActionListener(new EmployeesDialog_btnAdd_actionAdapter(this));
        btnAdd.setIcon(new ImageIcon("image/btninsert.gif"));
        btnDel.setBounds(new Rectangle(178, 418, 71, 25));
        btnDel.setText("");
        btnDel.addActionListener(new EmployeesDialog_btnDel_actionAdapter(this));
        btnDel.setIcon(new ImageIcon("image/btndel.gif"));
        btnUpdate.setBounds(new Rectangle(281, 418, 71, 25));
        btnUpdate.setText("");
        btnUpdate.addActionListener(new EmployeesDialog_btnUpdate_actionAdapter(this));
        btnUpdate.setIcon(new ImageIcon("image/btnchange.gif"));
        btnEsc.setBounds(new Rectangle(384, 418, 71, 25));
        btnEsc.setText("");
        btnEsc.addActionListener(new EmployeesDialog_btnEsc_actionAdapter(this));
        btnEsc.setIcon(new ImageIcon(
                "image/btnback.gif"));
        txtEmp_id.setText("");
        txtEmp_id.setBounds(new Rectangle(144, 29, 110, 26));
        jLabel1.setText("员工编号：");
        jLabel1.setBounds(new Rectangle(33, 34, 91, 20));
        jLabel2.setText("工作岗位：");
        jLabel2.setBounds(new Rectangle(33, 100, 90, 20));
        jLabel3.setText("姓名：");
        jLabel3.setBounds(new Rectangle(312, 32, 61, 20));
        jLabel4.setToolTipText("");
        jLabel4.setText("职务：");
        jLabel4.setBounds(new Rectangle(312, 103, 61, 20));
        txtName.setText("");
        txtName.setBounds(new Rectangle(383, 29, 110, 26));
        txtTitle.setText("");
        txtTitle.setBounds(new Rectangle(382, 97, 110, 26));
        txtPosition.setText("");
        txtPosition.setBounds(new Rectangle(144, 97, 110, 26));
        btnSearch.setBounds(new Rectangle(189, 154, 71, 25));
        btnSearch.setIcon(new ImageIcon(
                "image/Logo1.jpg"));
        btnSearch.setText("");
        btnSearch.setIcon(new ImageIcon(
                "image/btnselect.gif"));
        btnSearch.addActionListener(new EmployeesDialog_btnSearch_actionAdapter(this));
        this.getContentPane().setBackground(Color.white);
        btnBack.setBounds(new Rectangle(306, 154, 71, 25));
        btnBack.setIcon(new ImageIcon(
                "image/btnback.gif"));
        btnBack.setText("");
        btnBack.addActionListener(new EmployeesDialog_btnBack_actionAdapter(this));
        getContentPane().add(panel1);
        panel1.add(jPanel1);
        jPanel1.add(jLabel1);
        jPanel1.add(jLabel2);
        jPanel1.add(txtName);
        jPanel1.add(txtTitle);
        jPanel1.add(jLabel3);
        jPanel1.add(jLabel4);
        jPanel1.add(txtEmp_id);
        jPanel1.add(txtPosition);
        jPanel1.add(btnSearch);
        jPanel1.add(btnBack);
        panel1.add(jScrollPane1);
        panel1.add(btnDel);
        panel1.add(btnEsc);
        panel1.add(btnAdd);
        panel1.add(btnUpdate);
        EmpAction objAction = new EmpAction();
        CustomTableModule MyTableModule = objAction.getAllEmployee();
        tabEmp = new JTable(MyTableModule);
        jScrollPane1.getViewport().add(tabEmp);
        tabEmp.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
        for (int i = 0; i < 9; i++) {
            tabEmp.getColumnModel().getColumn(i).setPreferredWidth(100);
        }
        tabEmp.getColumnModel().getColumn(9).setPreferredWidth(200);
        tabEmp.getColumnModel().getColumn(10).setPreferredWidth(100);
        tabEmp.getColumnModel().getColumn(11).setPreferredWidth(100);
        tabEmp.getColumnModel().getColumn(12).setPreferredWidth(100);
        tabEmp.getColumnModel().getColumn(13).setPreferredWidth(100);
        tabEmp.getColumnModel().getColumn(14).setPreferredWidth(170);
        tabEmp.getColumnModel().getColumn(15).setPreferredWidth(170);
        tabEmp.getColumnModel().getColumn(16).setPreferredWidth(170);
        tabEmp.getColumnModel().getColumn(17).setPreferredWidth(170);
        tabEmp.getColumnModel().getColumn(18).setPreferredWidth(100);

        tabEmp.getColumnModel().getColumn(19).setPreferredWidth(170);
        tabEmp.getColumnModel().getColumn(20).setPreferredWidth(200);
        tabEmp.getColumnModel().getColumn(21).setPreferredWidth(170);
        tabEmp.getColumnModel().getColumn(22).setPreferredWidth(100);
        tabEmp.getColumnModel().getColumn(23).setPreferredWidth(120);
        tabEmp.getColumnModel().getColumn(24).setPreferredWidth(100);
        tabEmp.getColumnModel().getColumn(25).setPreferredWidth(100);
        tabEmp.getColumnModel().getColumn(26).setPreferredWidth(150);
        tabEmp.getColumnModel().getColumn(27).setPreferredWidth(170);
        tabEmp.getColumnModel().getColumn(28).setPreferredWidth(100);
        tabEmp.getColumnModel().getColumn(29).setPreferredWidth(100);
        tabEmp.getColumnModel().getColumn(30).setPreferredWidth(100);
        tabEmp.getColumnModel().getColumn(31).setPreferredWidth(100);
        tabEmp.getColumnModel().getColumn(32).setPreferredWidth(100);

    }

    public void btnEsc_actionPerformed(ActionEvent e) {
        this.dispose();
    }

//添加员工
    public void btnAdd_actionPerformed(ActionEvent e) {
        AddEmploDialog objE = new AddEmploDialog();
        Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
        Dimension frameSize = objE.getSize();
        if (frameSize.height > screenSize.height) {
            frameSize.height = screenSize.height;
        }
        if (frameSize.width > screenSize.width) {
            frameSize.width = screenSize.width;
        }
        objE.setLocation((screenSize.width - frameSize.width) / 2,
                         (screenSize.height - frameSize.height) / 2);

        objE.setModal(true);
        objE.setVisible(true);
        // 调用业务类方法刷新表模型,重新设置表格的模型
        EmpAction objAction = new EmpAction();
        CustomTableModule MyTableModule = objAction.getAllEmployee();
        tabEmp = new JTable(MyTableModule);
        jScrollPane1.getViewport().add(tabEmp);
        tabEmp.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
        for (int i = 0; i < 9; i++) {
            tabEmp.getColumnModel().getColumn(i).setPreferredWidth(100);
        }
        tabEmp.getColumnModel().getColumn(9).setPreferredWidth(200);
        tabEmp.getColumnModel().getColumn(10).setPreferredWidth(100);
        tabEmp.getColumnModel().getColumn(11).setPreferredWidth(100);
        tabEmp.getColumnModel().getColumn(12).setPreferredWidth(100);
        tabEmp.getColumnModel().getColumn(13).setPreferredWidth(100);
        tabEmp.getColumnModel().getColumn(14).setPreferredWidth(170);
        tabEmp.getColumnModel().getColumn(15).setPreferredWidth(170);
        tabEmp.getColumnModel().getColumn(16).setPreferredWidth(170);
        tabEmp.getColumnModel().getColumn(17).setPreferredWidth(170);
        tabEmp.getColumnModel().getColumn(18).setPreferredWidth(100);

        tabEmp.getColumnModel().getColumn(19).setPreferredWidth(170);
        tabEmp.getColumnModel().getColumn(20).setPreferredWidth(200);
        tabEmp.getColumnModel().getColumn(21).setPreferredWidth(170);
        tabEmp.getColumnModel().getColumn(22).setPreferredWidth(100);
        tabEmp.getColumnModel().getColumn(23).setPreferredWidth(120);
        tabEmp.getColumnModel().getColumn(24).setPreferredWidth(100);
        tabEmp.getColumnModel().getColumn(25).setPreferredWidth(100);
        tabEmp.getColumnModel().getColumn(26).setPreferredWidth(150);
        tabEmp.getColumnModel().getColumn(27).setPreferredWidth(170);
        tabEmp.getColumnModel().getColumn(28).setPreferredWidth(100);
        tabEmp.getColumnModel().getColumn(29).setPreferredWidth(100);
        tabEmp.getColumnModel().getColumn(30).setPreferredWidth(100);
        tabEmp.getColumnModel().getColumn(31).setPreferredWidth(100);
        tabEmp.getColumnModel().getColumn(32).setPreferredWidth(100);

    }

    //删除员工
    public void btnDel_actionPerformed(ActionEvent e) {
        if (tabEmp.getSelectedRow() < 0) {
            JOptionPane.showMessageDialog(this, "请选择你要删除的员工");
            return;
        }

        if (JOptionPane.showConfirmDialog(this, "确认删除当前员工信息吗?", "确认",
                                          JOptionPane.YES_NO_OPTION,
                                          JOptionPane.QUESTION_MESSAGE) ==
            JOptionPane.YES_OPTION) {

            int rowIndex = tabEmp.getSelectedRow();
            int emp_id = Integer.parseInt(String.valueOf(tabEmp.getValueAt(
                    rowIndex, 0))); //员工编号
            EmployeeBean objE = new EmployeeBean();
            objE.setEmp_Id(emp_id);
            EmpAction objD = new EmpAction();
            if (objD.deleteEmployee(objE)) {

                // 调用业务类方法刷新表模型,重新设置表格的模型
                EmpAction objAction = new EmpAction();
                CustomTableModule MyTableModule = objAction.getAllEmployee();
                tabEmp = new JTable(MyTableModule);
                jScrollPane1.getViewport().add(tabEmp);
                tabEmp.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
                for (int i = 0; i < 9; i++) {
                    tabEmp.getColumnModel().getColumn(i).setPreferredWidth(100);
                }
                tabEmp.getColumnModel().getColumn(9).setPreferredWidth(200);
                tabEmp.getColumnModel().getColumn(10).setPreferredWidth(100);
                tabEmp.getColumnModel().getColumn(11).setPreferredWidth(100);
                tabEmp.getColumnModel().getColumn(12).setPreferredWidth(100);
                tabEmp.getColumnModel().getColumn(13).setPreferredWidth(100);
                tabEmp.getColumnModel().getColumn(14).setPreferredWidth(170);
                tabEmp.getColumnModel().getColumn(15).setPreferredWidth(170);
                tabEmp.getColumnModel().getColumn(16).setPreferredWidth(170);
                tabEmp.getColumnModel().getColumn(17).setPreferredWidth(170);
                tabEmp.getColumnModel().getColumn(18).setPreferredWidth(100);

                tabEmp.getColumnModel().getColumn(19).setPreferredWidth(170);
                tabEmp.getColumnModel().getColumn(20).setPreferredWidth(200);
                tabEmp.getColumnModel().getColumn(21).setPreferredWidth(170);
                tabEmp.getColumnModel().getColumn(22).setPreferredWidth(100);
                tabEmp.getColumnModel().getColumn(23).setPreferredWidth(120);
                tabEmp.getColumnModel().getColumn(24).setPreferredWidth(100);
                tabEmp.getColumnModel().getColumn(25).setPreferredWidth(100);
                tabEmp.getColumnModel().getColumn(26).setPreferredWidth(150);
                tabEmp.getColumnModel().getColumn(27).setPreferredWidth(170);
                tabEmp.getColumnModel().getColumn(28).setPreferredWidth(100);
                tabEmp.getColumnModel().getColumn(29).setPreferredWidth(100);
                tabEmp.getColumnModel().getColumn(30).setPreferredWidth(100);
                tabEmp.getColumnModel().getColumn(31).setPreferredWidth(100);
                tabEmp.getColumnModel().getColumn(32).setPreferredWidth(100);

            }
        }
    }

//修改员工资料
    public void btnUpdate_actionPerformed(ActionEvent e) {
        if (this.tabEmp.getSelectedRow() < 0) {
            JOptionPane.showMessageDialog(this, "请选择你要修改的员工");
            return;
        }
        if (JOptionPane.showConfirmDialog(this, "确认修改当前员工信息吗?", "确认",
                                          JOptionPane.YES_NO_OPTION,
                                          JOptionPane.QUESTION_MESSAGE) ==
            JOptionPane.YES_OPTION) {

            int rowIndex = tabEmp.getSelectedRow();
            int emp_id = Integer.parseInt(String.valueOf(tabEmp.getValueAt(