inputselectedlessoninfo.java~371~

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

            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);
                        haveSelectedResult[i - 1] = temp.trim(); //将已选课程成绩记录入数组,但要注意数组的清空时机！！
                    }
                }
            }
            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) {
                            haveSelectedNature[i - 1] = temp.trim(); //将已选课程成绩记录入数组,但要注意数组的清空时机！！
                        }
                    }
                }
            }
            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);
                        haveSelectedScoreAll += Integer.parseInt(temp.trim());
                    }
                }
            }
            jTextField_Score.setText(haveSelectedScoreAll + ""); //将已选学分显示
            rs = stmt.executeQuery("select 课程名称,课程学分 from LessonInfo");
            while (rs.next()) {
                String tempLesson = "", tempNumber = "";
                tempLesson = rs.getString(1);
                tempNumber = rs.getString(2);
                for (int i = 0; i < haveSelected.length; i++) {
                    if (tempLesson.equals(haveSelected[i])) {
                        haveSelectedScore[i] = tempNumber; //将各课程的学分记录入数组
                    }
                }
            }
            con.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
        jTextField_SelectedAll.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(3);
                    jTextField_Status.setText(strStatus);
                    canInputSelectedInfo = true; //提示可以录入选课信息
                    jTextField_ScoreHad.setText("0"); //还有很多要完善的地方！！！！！！
                    break;
                }
            }
            if (strName.equals("")) {
                JOptionPane.showMessageDialog(this,
                                              "抱歉，没找到学号为“" + strNumber +
                                              "”的学生记录。请检查您输入的学号是否正确！如有其它问题请与管理员联系。",
                                              "注意！", 2);
            }
            con.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    public void inputOneSubject() { //录入一门课程的方法
        try {
            Statement stmt;
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection con = DriverManager.getConnection("jdbc:odbc:db_STU", "",
                    "");
            stmt = con.createStatement();
            String tempOrder = "update Result_Info set ";
            for (int i = 0; i < haveSelected.length; i++) { //确定命令语句的循环
                if (haveSelected[i] != null) {
                    tempOrder += "课程" + (i + 1) + "='" + haveSelected[i] +
                            "',属性" + (i + 1) + "='" + haveSelectedNature[i] +
                            "',学分" +
                            (i + 1) + "=" +
                            haveSelectedScore[i] + ",成绩" + (i + 1) + "=" +
                            haveSelectedResult[i] + ",";
                } else {
                    tempOrder += "课程" + (i + 1) + "=null,属性" + (i + 1) +
                            "=null,学分" + (i + 1) +
                            "=0,成绩" + (i + 1) + "=0,";
                }
            }
            tempOrder = tempOrder.substring(0, tempOrder.length() - 1) +
                        " where 学号='" + strNumber + "'";
            stmt.executeUpdate(tempOrder);
            stmt.close();
            con.close();
        }

        catch (Exception e) {
            e.printStackTrace();
        }
        jTextField_SelectedAll.setText(haveSelectedCount + ""); //更新已选课程数目
    }


    public void enableInput() { //使输入选课信息使能的方法
        if (jComboBox_HaveSelected.getItemCount() == 0) {
            jButton_SelectedAllLookMore.setEnabled(false);
            jButton_DeleteSelected.setEnabled(false);
            jComboBox_HaveSelected.setEnabled(false);
            jComboBox_HaveSelected.addItem("尚未选定课程");
        } else if (jComboBox_HaveSelected.getItemCount() >= 1) {
            jButton_SelectedAllLookMore.setEnabled(true);
            jButton_DeleteSelected.setEnabled(true);
            jComboBox_HaveSelected.setEnabled(true);
        }
        jComboBox_CanBeSelected.setEnabled(canInputSelectedInfo);
        jComboBox_ScoreHad.setEnabled(canInputSelectedInfo);
        jButton_LookMore.setEnabled(canInputSelectedInfo);
        jButton_GoOn.setEnabled(canInputSelectedInfo);
        jButton_InputSelected.setEnabled(canInputSelectedInfo);
        jTextField_CanBeSelected.setEnabled(canInputSelectedInfo);
    }

    public void getLessonInfo(int which) { //显示课程详细信息的方法其中0为已选课程1为建议选的课程
        String temp1, temp2, temp3, temp4, temp5, temp6, temp7, temp8,
                temp9, tempLessonName, tempLesson = "";
        try {
            if (jComboBox_HaveSelected.getItemCount() == 0 && which == 0) {
                JOptionPane.showMessageDialog(this, "尚未选定任何课程！", "注意！", 2);
                throw new Exception();
            }
            if (which == 0) {
                tempLesson = jComboBox_HaveSelected.getSelectedItem().
                             toString().trim();
            }
            if (which == 1) {
                tempLesson = jComboBox_CanBeSelected.getSelectedItem().
                             toString();
            }
            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);
                //在getString的时候要按顺序并且get走了后就没有了且不能进行下一个getSting！！
                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 showDetail() {
        String tempLessonNumber = jTextField_CanBeSelected.getText().trim();
        boolean haveFound = false;
        try {
            if (tempLessonNumber.equals("")) {
                JOptionPane.showMessageDialog(this,
                                              "注意！课程号不能为空！",
                                              "注意！", 2);

                throw new Exception();
            }
            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()) {
                String temp1, temp2, temp3, temp4, temp5, temp6, temp7, temp8,
                        temp9;
                temp1 = rs.getString(2);
                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 (temp1.equals(tempLessonNumber)) {
                    JOptionPane.showMessageDialog(this,
                                                  "课程编号：" + temp1 +
                                                  "；课程名称：" + temp2 +
                                                  "；课程性质：" + temp3 +
                                                  "；课程学分：" + temp4 +
                                                  "；\n上课地点：" + temp5 +
                                                  "；授课教师：" + temp6 +
                                                  "；课程学时：" + temp7 +
                                                  "；考试类型：" + temp8 +
                                                  "；实验：" + temp9 +
                                                  "。",
                                                  "课程详细信息", 2);
                    haveFound = true;
                    break;
                }
            }
            if (!haveFound) {
                JOptionPane.showMessageDialog(this,
                                              "抱歉，没找到课程号为“" + tempLessonNumber +
                                              "”的课程记录。请检查您输入的课程号是否正确！如有其它问题请与管理员联系。",
                                              "课程信息查询失败", 2);
            }
            stmt.close();
            con.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

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

    public void jButton_Input_actionPerformed(ActionEvent e) {
        JOptionPane.showMessageDialog(this, "本次录入选课信息共成功录入3门课程！", "录入结果", 1);
    }

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