delectdepartview.java

很好的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;
        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;
                 db.executeUpdate(sql1);//num +=
                //后删除部门信息
                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 1:
            JOptionPane.showMessageDialog(this, "部门删除成功", "成功",
                                          JOptionPane.INFORMATION_MESSAGE);
            db.executeUpdate("update employee_table set dep_id = 1, position_id = 1 where dep_id =" + depart_id);
            this.closeCom();
            this.delproCheckBox.setSelected(false);
            this.departTextField.setText("");
            break;
        default:
            JOptionPane.showMessageDialog(this, "失败，删除不成功", "失败",
                                          JOptionPane.ERROR_MESSAGE);
            break;
        }

    }


}


class DelectDepartView_delproCheckBox_mouseAdapter extends MouseAdapter {
    private DelectDepartView adaptee;
    DelectDepartView_delproCheckBox_mouseAdapter(DelectDepartView adaptee) {
        this.adaptee = adaptee;
    }

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


class DelectDepartView_delproCheckBox_changeAdapter implements ChangeListener {
    private DelectDepartView adaptee;
    DelectDepartView_delproCheckBox_changeAdapter(DelectDepartView adaptee) {
        this.adaptee = adaptee;
    }

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


class DelectDepartView_subButton_actionAdapter implements ActionListener {
    private DelectDepartView adaptee;
    DelectDepartView_subButton_actionAdapter(DelectDepartView adaptee) {
        this.adaptee = adaptee;
    }

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


class DelectDepartView_departList_mouseAdapter extends MouseAdapter {
    private DelectDepartView adaptee;
    DelectDepartView_departList_mouseAdapter(DelectDepartView adaptee) {
        this.adaptee = adaptee;
    }

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


class DelectDepartView_resetButton_actionAdapter implements ActionListener {
    private DelectDepartView adaptee;
    DelectDepartView_resetButton_actionAdapter(DelectDepartView adaptee) {
        this.adaptee = adaptee;
    }

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


class DelectDepartView_cancelButton_actionAdapter implements ActionListener {
    private DelectDepartView adaptee;
    DelectDepartView_cancelButton_actionAdapter(DelectDepartView adaptee) {
        this.adaptee = adaptee;
    }

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