empondutyrec.java~23~

酒店信息管理系统包括客户的信息

            jTAProceeding.setEnabled(false);
            jTARemark.setEnabled(false);

            jBEdit.setEnabled(false);
            jBEditFinish.setEnabled(false);
            jBOnDutySet.setEnabled(false);
            jCBSuAm.setEnabled(false);
            jCBSuPm.setEnabled(false);
            jCBMoAm.setEnabled(false);
            jCBMoPm.setEnabled(false);
            jCBTuAm.setEnabled(false);
            jCBTuPm.setEnabled(false);
            jCBWeAm.setEnabled(false);
            jCBWePm.setEnabled(false);
            jCBThAm.setEnabled(false);
            jCBThPm.setEnabled(false);
            jCBFrAm.setEnabled(false);
            jCBFrPm.setEnabled(false);
            jCBSaAm.setEnabled(false);
            jCBSaPm.setEnabled(false);

        } catch (SQLException ex) {
            ex.printStackTrace();
        } finally {
            try {
                if (Connect1.con1 != null && Connect2.con2 != null) {
                    Connect1.con1.close(); //关闭数据库
                    Connect2.con2.close(); //关闭数据库
                    Connect1.stmt1.close();
                    Connect2.stmt2.close();
                } //if
            } catch (SQLException ex) {
                System.out.println(ex);
            } //catch
        } //finally

    }

    public void jBEmpQuery_actionPerformed(ActionEvent e) {//查找
        strEmpuserID = jTFEmpQuery.getText();
        try {
            //-----------------------------------------------------------------------------------------------------
            Connect1.Connnect(); //装入驱动
            Connect1.con1 = DriverManager.getConnection(Connect1.url); //建立连接
            Connect1.stmt1 = Connect1.con1.createStatement(); //创建语句
            Connect1.sql1 = "SELECT HIMS_OnDuty.*,HIMS_Employee.Name,HIMS_Employee.Department,HIMS_Employee.Duty,HIMS_OnDuty_Date.Sun,HIMS_OnDuty_Date.Mon,HIMS_OnDuty_Date.Tues,HIMS_OnDuty_Date.Wed,HIMS_OnDuty_Date.Thurs,HIMS_OnDuty_Date.Fri,HIMS_OnDuty_Date.Sat FROM HIMS_OnDuty,HIMS_Employee,HIMS_OnDuty_Date Where HIMS_OnDuty.EmpID = HIMS_Employee.EmpID AND HIMS_OnDuty.EmpID = HIMS_OnDuty_Date.EmpID";
            rs1l = Connect1.stmt1.executeQuery(Connect1.sql1);

            //-----------------------------------------------------------------------------------------------------
            while (rs1l.next()) {
                String strUserID = rs1l.getString("EmpID");
                String strFloorNo = rs1l.getString("FloorNo");
                String strProceeding = rs1l.getString("Proceeding");
                String strEmpPhone = rs1l.getString("EmpPhone");
                String strEmpRemark = rs1l.getString("EmpRemark");

                String strEmpName = rs1l.getString("Name");
                String strDepartment = rs1l.getString("Department");
                String strDuty = rs1l.getString("Duty");

                String strSun = rs1l.getString("Sun");
                String strMon = rs1l.getString("Mon");
                String strTues = rs1l.getString("Tues");
                String strWed = rs1l.getString("Wed");
                String strThurs = rs1l.getString("Thurs");
                String strFri = rs1l.getString("Fri");
                String strSat = rs1l.getString("Sat");

                if (strUserID.equals(strEmpuserID)) {

                    jTFName.setText(strEmpName);
                    jTFDepartment.setText(strDepartment);
                    jTFDuty.setText(strDuty);
                    jTFEmpID.setText(strUserID);

                    jTFFloorNo.setText(strFloorNo);
                    jTFPhone.setText(strEmpPhone);
                    jTAProceeding.setText(strProceeding);
                    jTARemark.setText(strEmpRemark);

                    if (strSun.equals("0")) {
                        jCBSuAm.setSelected(false);
                        jCBSuPm.setSelected(false);
                    } else if (strSun.equals("1")) {
                        jCBSuAm.setSelected(true);
                        jCBSuPm.setSelected(false);
                    } else if (strSun.equals("8")) {
                        jCBSuAm.setSelected(false);
                        jCBSuPm.setSelected(true);
                    }

                    if (strMon.equals("0")) {
                        jCBMoAm.setSelected(false);
                        jCBMoPm.setSelected(false);
                    } else if (strMon.equals("2")) {
                        jCBMoAm.setSelected(true);
                        jCBMoPm.setSelected(false);
                    } else if (strMon.equals("9")) {
                        jCBMoAm.setSelected(false);
                        jCBMoPm.setSelected(true);
                    }

                    if (strTues.equals("0")) {
                        jCBTuAm.setSelected(false);
                        jCBTuPm.setSelected(false);
                    } else if (strTues.equals("3")) {
                        jCBTuAm.setSelected(true);
                        jCBTuPm.setSelected(false);
                    } else if (strTues.equals("10")) {
                        jCBTuAm.setSelected(false);
                        jCBTuPm.setSelected(true);
                    }

                    if (strWed.equals("0")) {
                        jCBWeAm.setSelected(false);
                        jCBWePm.setSelected(false);
                    } else if (strWed.equals("4")) {
                        jCBWeAm.setSelected(true);
                        jCBWePm.setSelected(false);
                    } else if (strWed.equals("11")) {
                        jCBWeAm.setSelected(false);
                        jCBWePm.setSelected(true);
                    }

                    if (strThurs.equals("0")) {
                        jCBThAm.setSelected(false);
                        jCBThPm.setSelected(false);
                    } else if (strThurs.equals("5")) {
                        jCBThAm.setSelected(true);
                        jCBThPm.setSelected(false);
                    } else if (strThurs.equals("12")) {
                        jCBThAm.setSelected(false);
                        jCBThPm.setSelected(true);
                    }

                    if (strFri.equals("0")) {
                        jCBFrAm.setSelected(false);
                        jCBFrPm.setSelected(false);
                    } else if (strFri.equals("6")) {
                        jCBFrAm.setSelected(true);
                        jCBFrPm.setSelected(false);
                    } else if (strFri.equals("13")) {
                        jCBFrAm.setSelected(false);
                        jCBFrPm.setSelected(true);
                    }

                    if (strSat.equals("0")) {
                        jCBSaAm.setSelected(false);
                        jCBSaPm.setSelected(false);
                    } else if (strSat.equals("7")) {
                        jCBSaAm.setSelected(true);
                        jCBSaPm.setSelected(false);
                    } else if (strSat.equals("14")) {
                        jCBSaAm.setSelected(false);
                        jCBSaPm.setSelected(true);
                    }

                    jBEdit.setEnabled(true);
                    return;
                }
            } //while
            JOptionPane.showMessageDialog(null, "您所查找的内容不在库中！", "系统警告",
                                          JOptionPane.WARNING_MESSAGE);

            //-----------------------------------------------------------------------------------------------------------

        } catch (SQLException ex) {
            ex.printStackTrace();
        } finally {
            try {
                if (Connect1.con1 != null) {
                    Connect1.con1.close(); //关闭数据库admin
                    Connect1.stmt1.close();
                    jTFEmpQuery.setText("");
                } //if
            } catch (SQLException ex) {
                System.out.println(ex);
            } //catch
        } //finally
    }
}


class EmpOnDutyRec_jBEmpQuery_actionAdapter implements ActionListener {
    private EmpOnDutyRec adaptee;
    EmpOnDutyRec_jBEmpQuery_actionAdapter(EmpOnDutyRec adaptee) {
        this.adaptee = adaptee;
    }

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


class EmpOnDutyRec_jBEditFinish_actionAdapter implements ActionListener {
    private EmpOnDutyRec adaptee;
    EmpOnDutyRec_jBEditFinish_actionAdapter(EmpOnDutyRec adaptee) {
        this.adaptee = adaptee;
    }

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


class EmpOnDutyRec_jBEdit_actionAdapter implements ActionListener {
    private EmpOnDutyRec adaptee;
    EmpOnDutyRec_jBEdit_actionAdapter(EmpOnDutyRec adaptee) {
        this.adaptee = adaptee;
    }

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


class EmpOnDutyRec_jBOnDutySet_actionAdapter implements ActionListener {
    private EmpOnDutyRec adaptee;
    EmpOnDutyRec_jBOnDutySet_actionAdapter(EmpOnDutyRec adaptee) {
        this.adaptee = adaptee;
    }

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


class EmpOnDutyRec_jBQuit_actionAdapter implements ActionListener {
    private EmpOnDutyRec adaptee;
    EmpOnDutyRec_jBQuit_actionAdapter(EmpOnDutyRec adaptee) {
        this.adaptee = adaptee;
    }

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