deptmanagerdialog.java

java+sql2000企业人力管理系统

package managersystem.Dept;

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.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import managersystem.CustomTableModule;
import managersystem.user.UserAdd;
import managersystem.user.UsersAction;

/**
 * <p>Title: 企业人力资源管理系统</p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2008</p>
 *
 * <p>Company: </p>
 *
 * @author 腾龙工作组
 * @version 1.0
 */
public class DeptManagerDialog 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 tblDept = new JTable();
    JButton btnAdd = new JButton();
    JButton btnDel = new JButton();
    JButton btnUpdate = new JButton();
    JButton btnEsc = new JButton();
    JLabel lblDepId = new JLabel();
    JTextField txtDepId = new JTextField();
    JLabel lblDepName = new JLabel();
    JTextField txtDepName = new JTextField();
    JButton btnSearch = new JButton();
    JButton jButton1 = new JButton();
    public DeptManagerDialog(Frame owner, String title, boolean modal) {
        super(owner, title, modal);
        try {
            setDefaultCloseOperation(DISPOSE_ON_CLOSE);
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

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

    private void jbInit() throws Exception {
        this.setSize(370, 350);
        panel1.setLayout(null);
        jPanel1.setBackground(new Color(214, 228, 255));
        jPanel1.setBorder(border2);
        jPanel1.setBounds(new Rectangle(8, 0, 342, 105));
        jPanel1.setLayout(null);
        jScrollPane1.setBorder(BorderFactory.createLoweredBevelBorder());
        jScrollPane1.setBounds(new Rectangle(10, 112, 340, 124));
        btnAdd.setBounds(new Rectangle(17, 262, 71, 25));
        btnAdd.setText("");
        btnAdd.addActionListener(new DeptManagerDialog_btnAdd_actionAdapter(this));
        btnAdd.setIcon(new ImageIcon("image/btninsert.gif"));
        btnDel.setBounds(new Rectangle(103, 262, 71, 25));
        btnDel.setText("");
        btnDel.addActionListener(new DeptManagerDialog_btnDel_actionAdapter(this));
        btnDel.setIcon(new ImageIcon("image/btndel.gif"));
        btnUpdate.setBounds(new Rectangle(187, 262, 71, 25));
        btnUpdate.setText("");
        btnUpdate.addActionListener(new
                                    DeptManagerDialog_btnUpdate_actionAdapter(this));
        btnUpdate.setIcon(new ImageIcon("image/btnchange.gif"));
        btnEsc.setBounds(new Rectangle(276, 262, 71, 25));
        btnEsc.setText("");
        btnEsc.addActionListener(new DeptManagerDialog_btnEsc_actionAdapter(this));
        btnEsc.setIcon(new ImageIcon("image/btnback.gif"));
        panel1.setBorder(BorderFactory.createLineBorder(Color.black));
        lblDepId.setText("部门编号：");
        lblDepId.setBounds(new Rectangle(16, 31, 91, 26));
        txtDepId.setText("");
        txtDepId.setBounds(new Rectangle(106, 33, 117, 21));
        lblDepName.setText("部门名称：");
        lblDepName.setBounds(new Rectangle(18, 67, 88, 16));
        txtDepName.setText("");
        txtDepName.setBounds(new Rectangle(106, 66, 117, 21));
        btnSearch.setBounds(new Rectangle(251, 24, 71, 25));
        btnSearch.setText("");
        btnSearch.addActionListener(new
                                    DeptManagerDialog_btnSearch_actionAdapter(this));
        btnSearch.setIcon(new ImageIcon("image/btnselect.gif"));
        jButton1.setBounds(new Rectangle(251, 66, 71, 25));
        jButton1.setIcon(new ImageIcon("image/btnback.gif"));
        jButton1.setText("");
        jButton1.addActionListener(new DeptManagerDialog_jButton1_actionAdapter(this));
        getContentPane().add(panel1);
        jPanel1.add(lblDepId);
        jPanel1.add(lblDepName);
        jPanel1.add(txtDepId);
        jPanel1.add(txtDepName);
        jPanel1.add(btnSearch);
        jPanel1.add(jButton1);
        panel1.add(btnEsc);
        panel1.add(btnAdd);
        panel1.add(btnDel);
        panel1.add(btnUpdate);
        panel1.add(jScrollPane1);
        panel1.add(jPanel1);
        DepartmentAction objAction = new DepartmentAction();
        CustomTableModule MyTableModule = objAction.getAllDept();
        tblDept = new JTable(MyTableModule);
        jScrollPane1.getViewport().add(tblDept);
        tblDept.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
        tblDept.getColumnModel().getColumn(0).setPreferredWidth(108);
        tblDept.getColumnModel().getColumn(1).setPreferredWidth(108);
        tblDept.getColumnModel().getColumn(2).setPreferredWidth(120);

    }

//添加操作
    public void btnAdd_actionPerformed(ActionEvent e) {
        DeptAdd objAdd = new DeptAdd();
        objAdd.setTitle("部门编辑");
        Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
        Dimension frameSize = objAdd.getSize();
        if (frameSize.height > screenSize.height) {
            frameSize.height = screenSize.height;
        }
        if (frameSize.width > screenSize.width) {
            frameSize.width = screenSize.width;
        }
        objAdd.setLocation((screenSize.width - frameSize.width) / 2,
                           (screenSize.height - frameSize.height) / 2);
        objAdd.setModal(true);
        objAdd.setVisible(true);

//        DepartmentAction objAction = new DepartmentAction();
//        CustomTableModule myTableModel = objAction.getAllDept();
//        tblDept.setModel(myTableModel);
        DepartmentAction objAction = new DepartmentAction();
        CustomTableModule MyTableModule = objAction.getAllDept();
        tblDept = new JTable(MyTableModule);
        jScrollPane1.getViewport().add(tblDept);
        tblDept.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
        tblDept.getColumnModel().getColumn(0).setPreferredWidth(108);
        tblDept.getColumnModel().getColumn(1).setPreferredWidth(108);
        tblDept.getColumnModel().getColumn(2).setPreferredWidth(120);

    }

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

//删除操作
    public void btnDel_actionPerformed(ActionEvent e) {
        // 弹出确认删除的对话框
        if (this.tblDept.getSelectedRow() < 0) {
            JOptionPane.showMessageDialog(this, "请选择你要删除的部门！");
            return;
        }
        if (JOptionPane.showConfirmDialog(this, "请选择删除当前员工信息吗?", "信息",
                                          JOptionPane.YES_NO_OPTION,
                                          JOptionPane.QUESTION_MESSAGE) ==
            JOptionPane.YES_OPTION) {
            // 执行删除逻辑
            // 获得用户选中的员工编号
            // 获得当前选中的表格的行号
            int rowIndex = tblDept.getSelectedRow();
            int id = Integer.parseInt((String) tblDept.getValueAt(rowIndex, 0));
            // 调用业务类的删除方法
            DepartmentAction objAction = new DepartmentAction();
            // 如果删除成功
            if (objAction.deleteDep_ID(id)) {
//                CustomTableModule myTableModel = objAction.getAllDept();
//                tblDept.setModel(myTableModel);

                CustomTableModule MyTableModule = objAction.getAllDept();
                tblDept = new JTable(MyTableModule);
                jScrollPane1.getViewport().add(tblDept);