delectdepartpanel.java~5~

很好的Java绘图程序源代码

                        depart_name + "'";
                ResultSet rs = db.executeQuery(sql);

                try {
                    while (rs.next()) {
                        depart_id = rs.getInt(1);
                    }
                } catch (SQLException ex) {
                    ex.printStackTrace();
                }

                String sql2 = "select * from position_table where depart_id = " +
                              depart_id;
                ResultSet rs2 = db.executeQuery(sql2);

                try {
                    while (rs2.next()) {
                        prolist.add(rs2.getString(2));
                    }
                    this.proList.setListData(prolist.toArray());
                } catch (SQLException ex1) {
                    ex1.printStackTrace();
                }
            }
            //开启组件
            this.openCom();
        } else {
            //关闭组件
            this.closeCom();
        }
    }

    private void openCom() {
        this.proList.setEnabled(true);
        this.proScrollPane.setEnabled(true);
        this.delAllCheckBox.setEnabled(true);
    }

    private void closeCom() {
        this.proList.setEnabled(false);
        this.proScrollPane.setEnabled(false);
        this.delAllCheckBox.setEnabled(false);
    }

    public void delproCheckBox_stateChanged(ChangeEvent e) {
        if (!this.delproCheckBox.isSelected()) {
            this.closeCom();
        }
    }

    public void subButton_actionPerformed(ActionEvent e) {
        String depart_name = this.departTextField.getText();
        int num = 0;
        int depart_id = 0;
        if (!depart_name.equals("")) {

            //判断是否在list中存在信息
            for (int i = 0; i < deplist.size(); i++) {
                if (depart_name.equals(deplist.get(i).toString())) {
                    num = 0;
                    break;
                } else {
                    num = -2;
                }
            }
            //判断结束

            if (num == 0) {
                //num = 0,表示信息存在
                String sql =
                        "select * from depart_table where depart_name like '" +
                        depart_name + "'";
                deprs = db.executeQuery(sql);

                try {
                    while(deprs.next()){
                        depart_id = deprs.getInt(1);
                    }
                } catch (SQLException ex) {
                    ex.printStackTrace();
                }

                //先删除职位表中的信息
                String sql1 = "delete position_table where depart_id = " +
                              depart_id;
                num += db.executeUpdate(sql1);
                //后删除部门信息
                String sql2 = "delete depart_table where depart_name like '" +
                              depart_name + "'";
                num += db.executeUpdate(sql2);

                //判断
                this.switchcase(num);

                //刷新List
                this.setList();
                this.departList.repaint();
                this.closeCom();

            } else {
             //判断
             this.switchcase(num);
            }
        } else {
            num = -1;
            this.switchcase(num);
        }

    }

    private void switchcase(int num) {
        switch (num) {
        case -2:
            JOptionPane.showMessageDialog(this, "失败：\n原因：没有此部门", "信息缺失！",
                                          JOptionPane.ERROR_MESSAGE);
            this.departTextField.setText("");
            break;
        case -1:
            JOptionPane.showMessageDialog(this, "失败：\n原因：输入框为空", "信息缺失！",
                                          JOptionPane.ERROR_MESSAGE);
            this.departTextField.setText("");
            break;
        case 1:
            JOptionPane.showMessageDialog(this, "职位删除成功", "成功",
                                          JOptionPane.INFORMATION_MESSAGE);
            this.closeCom();
            this.delproCheckBox.setSelected(false);
            this.departTextField.setText("");
            break;
        case 2:
            JOptionPane.showMessageDialog(this, "部门删除成功", "成功",
                                          JOptionPane.INFORMATION_MESSAGE);
            this.closeCom();
            this.delproCheckBox.setSelected(false);
            this.departTextField.setText("");
            break;
        default:
            JOptionPane.showMessageDialog(this, "失败，删除不成功", "失败",
                                          JOptionPane.ERROR_MESSAGE);
            break;
        }

    }


}


class DelectDepartPanel_delproCheckBox_mouseAdapter extends MouseAdapter {
    private DelectDepartPanel adaptee;
    DelectDepartPanel_delproCheckBox_mouseAdapter(DelectDepartPanel adaptee) {
        this.adaptee = adaptee;
    }

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


class DelectDepartPanel_delproCheckBox_changeAdapter implements ChangeListener {
    private DelectDepartPanel adaptee;
    DelectDepartPanel_delproCheckBox_changeAdapter(DelectDepartPanel adaptee) {
        this.adaptee = adaptee;
    }

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


class DelectDepartPanel_subButton_actionAdapter implements ActionListener {
    private DelectDepartPanel adaptee;
    DelectDepartPanel_subButton_actionAdapter(DelectDepartPanel adaptee) {
        this.adaptee = adaptee;
    }

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


class DelectDepartPanel_departList_mouseAdapter extends MouseAdapter {
    private DelectDepartPanel adaptee;
    DelectDepartPanel_departList_mouseAdapter(DelectDepartPanel adaptee) {
        this.adaptee = adaptee;
    }

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


class DelectDepartPanel_resetButton_actionAdapter implements ActionListener {
    private DelectDepartPanel adaptee;
    DelectDepartPanel_resetButton_actionAdapter(DelectDepartPanel adaptee) {
        this.adaptee = adaptee;
    }

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


class DelectDepartPanel_cancelButton_actionAdapter implements ActionListener {
    private DelectDepartPanel adaptee;
    DelectDepartPanel_cancelButton_actionAdapter(DelectDepartPanel adaptee) {
        this.adaptee = adaptee;
    }

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