selectedlessoninfocheck.java~53~

Tt s a good book ,if you want to learn java good

        strLessonName = jComboBox_HaveSelected.getSelectedItem().toString();
        int deleteOrNot = JOptionPane.showConfirmDialog(this, "确定要删除该门已选课程？",
                "删除已选课程？", 1);
        if (deleteOrNot == 0) {
            haveSelectedCount--;
            deleteOneSubject();
        }
        strLessonNumber = strLessonName = strLessonNature = "";
    }

    public void getLessonInfo() { //显示课程详细信息的方法其中0为已选课程1为建议选的课程,响应
        String temp1, temp2, temp3, temp4, temp5, temp6, temp7, temp8,
                temp9, tempLessonName, tempLesson = "";
        try {
            if (jComboBox_HaveSelected.getItemCount() == 0) {
                JOptionPane.showMessageDialog(this, "尚未选定任何课程！", "注意！", 2);
                throw new Exception();
            }
            tempLesson = jComboBox_HaveSelected.getSelectedItem().
                         toString().trim();
            Statement stmt;
            ResultSet rs;
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection con = DriverManager.getConnection("jdbc:odbc:db_STU",
                    "",
                    "");
            stmt = con.createStatement();
            rs = stmt.executeQuery("select * from LessonInfo");
            while (rs.next()) {
                temp1 = rs.getString(2);
                tempLessonName = temp2 = rs.getString(3);
                temp3 = rs.getString(4);
                temp4 = rs.getString(5);
                temp5 = rs.getString(6);
                temp6 = rs.getString(7);
                temp7 = rs.getString(8);
                temp8 = rs.getString(9);
                temp9 = rs.getString(10);
                if (tempLessonName.equals(tempLesson)) {
                    JOptionPane.showMessageDialog(this,
                                                  "课程编号：" + temp1 +
                                                  "；课程名称：" + temp2 +
                                                  "；课程性质：" + temp3 +
                                                  "；课程学分：" + temp4 +
                                                  "；\n上课地点：" + temp5 +
                                                  "；授课教师：" + temp6 +
                                                  "；课程学时：" + temp7 +
                                                  "；考试类型：" + temp8 +
                                                  "；实验：" + temp9 +
                                                  "。",
                                                  "课程详细信息", 2);
                    break;
                }
            }
            stmt.close();
            con.close();
        } catch (Exception e) {}
    }

    public void goOnCheck() {
        haveFound = false;
        strNumber = strName = strStatus = "";
        haveSelectedCount = 0;
        jTextField_SN.setText("");
        jTextField_SN.setEditable(true);
        jTextField_Name.setText("");
        jTextField_Status.setText("");
        jTextField_All.setText("");
        jButton_LookMore.setEnabled(false);
        jButton_Delete.setEnabled(false);
        jButton_GoOn.setEnabled(false);
        jComboBox_HaveSelected.removeAllItems();
        jComboBox_HaveSelected.setEnabled(false);
        for (int i = 0; i < haveSelected.length; i++) {
            haveSelected[i] = null;
        }
    }

    public void getSelectedInfo() { //从Result_Info中获得已选的课程信息并输出在JComboBox中
        try {
            Statement stmt;
            ResultSet rs;
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection con = DriverManager.getConnection("jdbc:odbc:db_STU", "",
                    "");
            stmt = con.createStatement();
            rs = stmt.executeQuery("select 学号,课程1,课程2,课程3,课程4,课程5,课程6,课程7,课程8,课程9,课程10,课程11,课程12,课程13,课程14,课程15 from Result_Info");
            while (rs.next()) {
                if (rs.getString(1).equals(strNumber)) {
                    for (int i = 1; i <= 15; i++) {
                        String temp = rs.getString(i + 1);
                        if (temp != null) {
                            jComboBox_HaveSelected.addItem(temp);
                            haveSelectedCount++;
                            haveSelected[i - 1] = temp; //将已选课程记录入数组,但要注意数组的清空时机！！
                        }
                    }
                }
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        if (haveSelectedCount > 0) {
            jComboBox_HaveSelected.setEnabled(true);
            jButton_LookMore.setEnabled(true);
            if (MainFrame.id == 1) {
                jButton_Delete.setEnabled(true);
            }
        }
        jTextField_All.setText(haveSelectedCount + "");
    }

    public void getBasicInfo() { //从Basic_Info中获得基本信息并输出在窗口中的方法
        strNumber = jTextField_SN.getText().trim();
        try {
            Statement stmt;
            ResultSet rs;
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection con = DriverManager.getConnection("jdbc:odbc:db_STU", "",
                    "");
            stmt = con.createStatement();
            rs = stmt.executeQuery("select * from Basic_Info");
            while (rs.next()) {
                if (strNumber.equals(rs.getString(1))) {
                    jTextField_SN.setEditable(false);
                    strName = rs.getString(2);
                    jTextField_Name.setText(strName);
                    strStatus = rs.getString(11);
                    jTextField_Status.setText(strStatus);
                    jButton_GoOn.setEnabled(true);
                    haveFound = true;
                    break;
                }
            }
            if (strName.equals("")) {
                JOptionPane.showMessageDialog(this,
                                              "抱歉，没找到学号为“" + strNumber +
                                              "”的学生记录。请检查您输入的学号是否正确！如有其它问题请与管理员联系。",
                                              "注意！", 2);
            }
            con.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    public void jButton1_actionPerformed(ActionEvent e) {
        goOnCheck();
    }

    public void jTextField_SN_actionPerformed(ActionEvent e) {
        getBasicInfo();
        getSelectedInfo();
    }

    public void jButton_Cancel_actionPerformed(ActionEvent e) {
        dispose();
    }

    public void jButton_Delete_actionPerformed(ActionEvent e) {
        deleteFromComboBox();
    }

    public void jButton_LookMore_actionPerformed(ActionEvent e) {
        getLessonInfo();
    }
}


class SelectedLessonInfoCheck_jButton_LookMore_actionAdapter implements
        ActionListener {
    private SelectedLessonInfoCheck adaptee;
    SelectedLessonInfoCheck_jButton_LookMore_actionAdapter(
            SelectedLessonInfoCheck adaptee) {
        this.adaptee = adaptee;
    }

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


class SelectedLessonInfoCheck_jButton_Delete_actionAdapter implements
        ActionListener {
    private SelectedLessonInfoCheck adaptee;
    SelectedLessonInfoCheck_jButton_Delete_actionAdapter(
            SelectedLessonInfoCheck adaptee) {
        this.adaptee = adaptee;
    }

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


class SelectedLessonInfoCheck_jButton_Cancel_actionAdapter implements
        ActionListener {
    private SelectedLessonInfoCheck adaptee;
    SelectedLessonInfoCheck_jButton_Cancel_actionAdapter(
            SelectedLessonInfoCheck adaptee) {
        this.adaptee = adaptee;
    }

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


class SelectedLessonInfoCheck_jTextField_SN_actionAdapter implements
        ActionListener {
    private SelectedLessonInfoCheck adaptee;
    SelectedLessonInfoCheck_jTextField_SN_actionAdapter(SelectedLessonInfoCheck
            adaptee) {
        this.adaptee = adaptee;
    }

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


class SelectedLessonInfoCheck_jButton1_actionAdapter implements ActionListener {
    private SelectedLessonInfoCheck adaptee;
    SelectedLessonInfoCheck_jButton1_actionAdapter(SelectedLessonInfoCheck
            adaptee) {
        this.adaptee = adaptee;
    }

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