updatadepartview.java

很好的Java绘图程序源代码

    }

    public void proList_mouseClicked(MouseEvent e) {
        String old_name = String.valueOf(this.proList.getSelectedValue());
        this.proTextField.setText(old_name);
    }

    public void subButton_actionPerformed(ActionEvent e) {
        String depart_name = this.departTextField.getText();
        String new_depart_name = this.nDepTextField.getText();
        String pro_name = this.proTextField.getText();
        String new_pro_name = this.nProTextField.getText();
        String sql = "update depart_table set depart_name = '" + new_depart_name +
                     "' where depart_name like '" + depart_name +
                     "'";
        String pro_id = this.selPro + " where position_name like '" + pro_name +
                        "'";
        int depart_id = 0;
        int prof_id = 0;
        int num = 0;

        if (this.onlynum == 1) {
            //只修改职位名称
            if (!depart_name.equals("") && new_depart_name.equals("")) {
                //先得到职位Id
                ResultSet rs = db.executeQuery(pro_id);

                try {
                    while (rs.next()) {
                        prof_id = rs.getInt(1);
                        depart_id = rs.getInt(3);
                    }
                } catch (SQLException ex) {
                    ex.printStackTrace();
                }
                //直接修改职位
                String str = "update position_table set position_name = '" +
                             new_pro_name + "' where position_id = " + prof_id;
                num += db.executeUpdate(str);
            } else {
                num = -5;
            }

            this.setProList(depart_id);
        } else {
            //全部修改
            //先判断两个输入框是否有信息
            if (!depart_name.equals("") && !new_depart_name.equals("")) {
                //再判断2个输入框所输入的内容是否一样
                if (!depart_name.equals(new_depart_name)) {
                    //先得到该部门的Id
                    String depart = this.selDep + " where depart_name like '" +
                                    depart_name + "'";
                    ResultSet rs = db.executeQuery(depart);

                    try {
                        while (rs.next()) {
                            depart_id = rs.getInt(1);
                        }
                    } catch (SQLException ex) {
                    }
                    if (this.udproCheckBox.isSelected()) {
                        //判断职位框是否有信息
                        if (!pro_name.equals("") || !new_pro_name.equals("")) {
                            //判断职位框信息是否重复
                            if (!pro_name.equals(new_pro_name)) {
                                //需要修改职位

                                //得到prof_id
                                ResultSet rers = db.executeQuery(pro_id);

                                try {
                                    while (rers.next()) {
                                        prof_id = rers.getInt(1);
                                        depart_id = rers.getInt(3);
                                    }
                                } catch (SQLException ex1) {
                                }


                                String restr =
                                        "update position_table set position_name = '" +
                                        new_pro_name + "' where position_id = " +
                                        prof_id;
                                num += db.executeUpdate(restr);
                                //然后修改部门
                                num += db.executeUpdate(sql);
                                //判断num
                                this.switchcase(num);

                                this.setProList(depart_id);
                            } else {
                                num = -4;
                                //判断num
                                this.switchcase(num);
                            }
                        } else {
                            num = -3;
                            //判断num
                            this.switchcase(num);
                        }
                    } else {

                        //只修改部门
                        num += db.executeUpdate(sql);
                        //判断num
                        this.switchcase(num);
                    }
               } else {
                   num= -1;
                 //判断num
                    this.switchcase(num);
                }
            } else {
                num = -2;
                //判断num
                this.switchcase(num);
            }

        }
        this.setList();
        this.departList.repaint();
    }

    private void switchcase(int num) {
        switch (num) {
        case 1:
            JOptionPane.showMessageDialog(this, "部门修改成功", "修改成功",
                                          JOptionPane.INFORMATION_MESSAGE);
            this.departTextField.setText("");
            this.nDepTextField.setText("");
            break;
        case 2:
            JOptionPane.showMessageDialog(this, "部门修改成功\n职位成功修改： 1 个", "修改成功",
                                          JOptionPane.INFORMATION_MESSAGE);
            this.cleanall();
            break;
        case -1:
            JOptionPane.showMessageDialog(this, "原部门和新部门信息重复", "信息重复",
                                          JOptionPane.ERROR_MESSAGE);
            this.departTextField.setText("");
            this.nDepTextField.setText("");
            break;
        case -2:
            JOptionPane.showMessageDialog(this, "原部门和新部门输入框为空", "信息缺失",
                                          JOptionPane.ERROR_MESSAGE);
            this.departTextField.setFocusable(true);
            break;
        case -3:
            JOptionPane.showMessageDialog(this, "原职位名称或新职位名称输入框为空", "信息缺失",
                                          JOptionPane.ERROR_MESSAGE);
            this.proTextField.setFocusable(true);
            this.nProTextField.setText("");
            break;
        case -4:
            JOptionPane.showMessageDialog(this, "原职位名称或新职位名称重复输入", "信息重复",
                                          JOptionPane.ERROR_MESSAGE);
            this.proTextField.setText("");
            this.nProTextField.setText("");
            break;
        case -5:
            JOptionPane.showMessageDialog(this, "没有选择部门！", "修改失败",
                                          JOptionPane.ERROR_MESSAGE);
            this.departTextField.setFocusable(true);
            this.proTextField.setText("");
            this.nProTextField.setText("");
            break;
        default:
            JOptionPane.showMessageDialog(this, "部门或职位修改失败", "修改失败",
                                          JOptionPane.ERROR_MESSAGE);
            this.cleanall();
            break;
        }

    }

    private void setProList(int depart_id) {
        prolist = new ArrayList();
        String sql = this.selPro + " where depart_id = " + depart_id;
        ResultSet rs = db.executeQuery(sql);

        try {
            while (rs.next()) {
                prolist.add(rs.getString(2));
            }
            this.proList.setListData(prolist.toArray());
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
    }


    class UpdataDepartView_departList_mouseAdapter extends MouseAdapter {
        private UpdataDepartView adaptee;
        UpdataDepartView_departList_mouseAdapter(UpdataDepartView adaptee) {
            this.adaptee = adaptee;
        }

        public void mouseClicked(MouseEvent e) {
            adaptee.departList_mouseClicked(e);
        }
    }


    class UpdataDepartView_proList_mouseAdapter extends MouseAdapter {
        private UpdataDepartView adaptee;
        UpdataDepartView_proList_mouseAdapter(UpdataDepartView adaptee) {
            this.adaptee = adaptee;
        }

        public void mouseClicked(MouseEvent e) {
            adaptee.proList_mouseClicked(e);
        }
    }


    class UpdataDepartView_resetButton_actionAdapter implements ActionListener {
        private UpdataDepartView adaptee;
        UpdataDepartView_resetButton_actionAdapter(UpdataDepartView adaptee) {
            this.adaptee = adaptee;
        }

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


    class UpdataDepartView_addproCheckBox_mouseAdapter extends MouseAdapter {
        private UpdataDepartView adaptee;
        UpdataDepartView_addproCheckBox_mouseAdapter(UpdataDepartView adaptee) {
            this.adaptee = adaptee;
        }

        public void mouseClicked(MouseEvent e) {
            adaptee.addproCheckBox_mouseClicked(e);
        }
    }


    public void addproCheckBox_stateChanged(ChangeEvent e) {
        if (!this.udproCheckBox.isSelected()) {
            this.proTextField.setText("");
            this.nProTextField.setText("");
            this.closeCom();
        }
    }

    public void onlyCheckBox_mouseClicked(MouseEvent e) {
        if (this.onlyCheckBox.isSelected()) {
            this.onlynum = 1;
            this.nDepTextField.setEditable(false);
        } else {
            this.onlynum = 0;
            this.nDepTextField.setEditable(true);
        }
    }
}


class UpdataDepartView_onlyCheckBox_mouseAdapter extends MouseAdapter {
    private UpdataDepartView adaptee;
    UpdataDepartView_onlyCheckBox_mouseAdapter(UpdataDepartView adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseClicked(MouseEvent e) {
        adaptee.onlyCheckBox_mouseClicked(e);
    }
}


class UpdataDepartView_canButton_actionAdapter implements ActionListener {
    private UpdataDepartView adaptee;
    UpdataDepartView_canButton_actionAdapter(UpdataDepartView adaptee) {
        this.adaptee = adaptee;
    }

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


class UpdataDepartView_addproCheckBox_changeAdapter implements ChangeListener {
    private UpdataDepartView adaptee;
    UpdataDepartView_addproCheckBox_changeAdapter(UpdataDepartView adaptee) {
        this.adaptee = adaptee;
    }

    public void stateChanged(ChangeEvent e) {
        adaptee.addproCheckBox_stateChanged(e);
    }
}


class UpdataDepartView_subButton_actionAdapter implements ActionListener {
    private UpdataDepartView adaptee;
    UpdataDepartView_subButton_actionAdapter(UpdataDepartView adaptee) {
        this.adaptee = adaptee;
    }

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