每日总结-23.4.4

/* lesson add
     * 课程增加，将课程信息添加到数据库
     * 1.输入参数为： 课程名称，任课教师，学分，授课专业，课程目标1，课程目标2，课程目标3，
     *              目标1作业，目标1实验，目标1考试，目标1分数，
     *              目标2作业，目标2实验，目标2考试，目标2分数，
     *              目标3作业，目标3实验，目标3考试，目标3分数，课程总分数
     * 2.输入参数为：Pd_lesson，其中包含课程信息，参考以上。
     * */
    public void lesson_add(Pd_lesson pdd) throws Exception
    {
        lesson_add(
        pdd.getLesson_name(),
        pdd.getLesson_teacher(),
        pdd.getLesson_credit(),
        pdd.getLesson_major(),
        pdd.getLesson_target1(),
        pdd.getLesson_target2(),
        pdd.getLesson_target3(),
        pdd.getT1_task(),
        pdd.getT1_test(),
        pdd.getT1_exam(),
        pdd.getT1_score(),
        pdd.getT2_task(),
        pdd.getT2_test(),
        pdd.getT2_exam(),
        pdd.getT2_score(),
        pdd.getT3_task(),
        pdd.getT3_test(),
        pdd.getT3_exam(),
        pdd.getT3_score(),
        pdd.getLesson_score()
        );
    }
    public void lesson_add(String lesson_name,
                           String lesson_teacher,
                           String lesson_credit,
                           String lesson_major,
                           String lesson_target1,
                           String lesson_target2,
                           String lesson_target3,
                           String t1_task,
                           String t1_test,
                           String t1_exam,
                           String t1_score,
                           String t2_task,
                           String t2_test,
                           String t2_exam,
                           String t2_score,
                           String t3_task,
                           String t3_test,
                           String t3_exam,
                           String t3_score,
                           String lesson_score) throws Exception
    {
        String sql = "insert into lesson(lesson_name,lesson_teacher,lesson_credit,lesson_major,lesson_target1,lesson_target2,lesson_target3,t1_task," +
                "t1_test,t1_exam,t1_score,t2_task,t2_test,t2_exam,t2_score,t3_task,t3_test,t3_exam,t3_score,lesson_score,lesson_ispass) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?);";
        PreparedStatement pre = connect.prepareStatement(sql);
        pre.setString(1,lesson_name);
        pre.setString(2,lesson_teacher);
        pre.setString(3,lesson_credit);
        pre.setString(4,lesson_major);
        pre.setString(5,lesson_target1);
        pre.setString(6,lesson_target2);
        pre.setString(7,lesson_target3);
        pre.setString(8,t1_task);
        pre.setString(9,t1_test);
        pre.setString(10,t1_exam);
        pre.setString(11,t1_score);
        pre.setString(12,t2_task);
        pre.setString(13,t2_test);
        pre.setString(14,t2_exam);
        pre.setString(15,t2_score);
        pre.setString(16,t3_task);
        pre.setString(17,t3_test);
        pre.setString(18,t3_exam);
        pre.setString(19,t3_score);
        pre.setString(20,lesson_score);
        pre.setString(21,"未审核");
        int count=pre.executeUpdate();
        pre.close();
    }