employeesdialog.java

java+sql2000企业人力管理系统

                    rowIndex, 0))); //员工编号

            String name = (String) tabEmp.getValueAt(rowIndex, 1); //获取姓名
            String sex = (String) tabEmp.getValueAt(rowIndex, 2); //性别
            String Nationality = (String) tabEmp.getValueAt(rowIndex, 3); //民族
            String Birthday = (String) tabEmp.getValueAt(rowIndex, 4); //出生日期
            String Political = (String) tabEmp.getValueAt(rowIndex, 5); //政治面貌
            String Culture = (String) tabEmp.getValueAt(rowIndex, 6); //文化程度

            String Marriage = (String) tabEmp.getValueAt(rowIndex, 7); //婚姻状况
            String Place = (String) tabEmp.getValueAt(rowIndex, 8); //籍贯

            String IDCard = (String) tabEmp.getValueAt(rowIndex, 9); //身份证号
            String PcId = (String) tabEmp.getValueAt(rowIndex, 10); //电脑档案号

            String WordCard = (String) tabEmp.getValueAt(rowIndex, 11); //工作证号
            String Officephone = (String) tabEmp.getValueAt(rowIndex, 12); //办公电话

            String home = (String) tabEmp.getValueAt(rowIndex, 13); //家庭电话
            String Telephone = (String) tabEmp.getValueAt(rowIndex, 14); //移动电话

            String FilesOrg = (String) tabEmp.getValueAt(rowIndex, 15); //档案所在地
            String Residence = (String) tabEmp.getValueAt(rowIndex, 16); //居住地址

            String hukou = (String) tabEmp.getValueAt(rowIndex, 17); //户口所在地
            String Postcode = (String) tabEmp.getValueAt(rowIndex, 18); //邮政编码

            String Police = (String) tabEmp.getValueAt(rowIndex, 19); //户口所在地派出所
            String Street = (String) tabEmp.getValueAt(rowIndex, 20); //户口所在街道
            String HireDate = (String) tabEmp.getValueAt(rowIndex, 21); //本企业工龄起始日
            int WorkingAge = Integer.parseInt(String.valueOf(tabEmp.
                    getValueAt(
                            rowIndex, 22))); //工龄
            int division = Integer.parseInt(String.valueOf(tabEmp.
                    getValueAt(
                            rowIndex, 23))); //所在部门编号

            String Position = (String) tabEmp.getValueAt(rowIndex, 24); //工作岗位
            String Title = (String) tabEmp.getValueAt(rowIndex, 25); //职务
            String State = (String) tabEmp.getValueAt(rowIndex, 26); //状态
            String Contract = (String) tabEmp.getValueAt(rowIndex, 27); //签定劳动合同时间

            double Salary = Double.parseDouble(String.valueOf(tabEmp.
                    getValueAt(
                            rowIndex, 28))); //基本工资
            double BasePrice = Double.parseDouble(String.valueOf(tabEmp.
                    getValueAt(
                            rowIndex, 29))); //奖金基数
            String memo = (String) tabEmp.getValueAt(rowIndex, 30); //备注

            String FillinPerson = (String) tabEmp.getValueAt(rowIndex, 31); //填表人
            String Fillin_Time=(String)tabEmp.getValueAt(rowIndex,32);//填表时间
            EmployeeBean objE = new EmployeeBean(emp_id, name, sex, Nationality,
                                                 Birthday,
                                                 Political, Culture, Marriage,
                                                 Place,
                                                 IDCard, PcId, WordCard,
                                                 Officephone,
                                                 home, Telephone, FilesOrg,
                                                 Residence,
                                                 hukou, Postcode, Police,
                                                 Street,
                                                 HireDate, WorkingAge,division, Position,
                                                 Title,
                                                 State, Contract, Salary,
                                                 BasePrice,
                                                 memo, FillinPerson,Fillin_Time);

            AddEmploDialog dialog = new AddEmploDialog();
            dialog.setUpdate(objE);
            dialog.setTitle("修改员工信息");
            // Center the window
            Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
            Dimension frameSize = dialog.getSize();
            if (frameSize.height > screenSize.height) {
                frameSize.height = screenSize.height;
            }
            if (frameSize.width > screenSize.width) {
                frameSize.width = screenSize.width;
            }
            dialog.setLocation((screenSize.width - frameSize.width) / 2,
                               (screenSize.height - frameSize.height) / 2);
            dialog.setModal(true);
            dialog.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(120);

        }
    }

//查询按纽
    public void btnSearch_actionPerformed(ActionEvent e) {
        int emp_id;
        String name;
        String position;
        String title;
        if (txtEmp_id.getText().equals("") && txtName.getText().equals("") &&
            txtPosition.getText().equals("") && txtTitle.getText().equals("")) {
            JOptionPane.showMessageDialog(this, "请输入你要查找的内容");
            txtEmp_id.requestFocusInWindow();
            return;
        }

        try {
            //如果员工编号为空,另它等于0
            if (txtEmp_id.getText().equals("")) {
                emp_id = 0;
            } else {
                emp_id = Integer.parseInt(txtEmp_id.getText());
            }
            if (emp_id < 0) {
                JOptionPane.showMessageDialog(this, "员工编号书写不规范！");
                return;
            }
        } catch (Exception ex) {
            JOptionPane.showMessageDialog(null, "没有该员工编号!");
            txtEmp_id.requestFocusInWindow();
            return;
        }
        name = txtName.getText();
        position = txtPosition.getText();
        title = txtTitle.getText();

        SearchBean objB = new SearchBean();
        objB.setEmp_id(emp_id);
        objB.setName(name);
        objB.setPosition(position);
        objB.setTitle(title);
        EmpAction objAction = new EmpAction();
        CustomTableModule MyTableModule = objAction.getEmployeesByCondition(
                objB);
        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);
        txtEmp_id.setText("");
        txtName.setText("");
        txtPosition.setText("");
        txtTitle.setText("");
    }

//返回按钮
    public void btnBack_actionPerformed(ActionEvent e) {
        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(120);


    }


    class EmployeesDialog_btnUpdate_actionAdapter implements ActionListener {
        private EmployeesDialog adaptee;
        EmployeesDialog_btnUpdate_actionAdapter(EmployeesDialog adaptee) {
            this.adaptee = adaptee;
        }

        public void actionPerformed(ActionEvent e) {
            adaptee.btnUpdate_actionPerformed(e);
        }
    }


    class EmployeesDialog_btnDel_actionAdapter implements ActionListener {
        private EmployeesDialog adaptee;
        EmployeesDialog_btnDel_actionAdapter(EmployeesDialog adaptee) {
            this.adaptee = adaptee;
        }

        public void actionPerformed(ActionEvent e) {
            adaptee.btnDel_actionPerformed(e);
        }
    }


    class EmployeesDialog_btnAdd_actionAdapter implements ActionListener {
        private EmployeesDialog adaptee;
        EmployeesDialog_btnAdd_actionAdapter(EmployeesDialog adaptee) {
            this.adaptee = adaptee;
        }

        public void actionPerformed(ActionEvent e) {
            adaptee.btnAdd_actionPerformed(e);
        }
    }


    class EmployeesDialog_btnEsc_actionAdapter implements ActionListener {
        private EmployeesDialog adaptee;
        EmployeesDialog_btnEsc_actionAdapter(EmployeesDialog adaptee) {
            this.adaptee = adaptee;
        }

        public void actionPerformed(ActionEvent e) {
            adaptee.btnEsc_actionPerformed(e);
        }
    }
}


class EmployeesDialog_btnBack_actionAdapter implements ActionListener {
    private EmployeesDialog adaptee;
    EmployeesDialog_btnBack_actionAdapter(EmployeesDialog adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnBack_actionPerformed(e);
    }
}


class EmployeesDialog_btnSearch_actionAdapter implements ActionListener {
    private EmployeesDialog adaptee;
    EmployeesDialog_btnSearch_actionAdapter(EmployeesDialog adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnSearch_actionPerformed(e);
    }
}