版本管理过程

版本管理过程

主要负责代码

	Mapper层：
	<select id="selectCourseBySidCid" resultMap="CourseMapBySidCid">
        SELECT student.id AS studentId,student.name As studentName,class.name As GradeName,course.cname AS ConCname,middle_cs.grade_usual,middle_cs.grade_finally, middle_cs.grade_total
        FROM middle_cs,course,class,student
        <where>
            middle_cs.cid=course.cid and student.id=middle_cs.sid and class.id=student.class_id
            <if test="grade != null and grade != ''">
                and class.id = #{grade}
            </if>
            <if test="course != null and course != ''">
                and course.cid= #{course}
            </if>
            <if test="sid !=null and sid != '' ">
                and student.id= #{sid}
            </if>
            <if test="message!= null and message != '' ">
                and student.name=#{sssname}
            </if>
        </where>
    </select>
	Controller层：
	@GetMapping("scores")
    public PageInfo<MiddleStudentCourse> ShowScoreAllByPage(int num){
        PageHelper.startPage(num,7);
        List<MiddleStudentCourse> list= 
	middleStudentCourseService.findAllStudentCourse();
        PageInfo<MiddleStudentCourse> pageInfo=
	new PageInfo<MiddleStudentCourse>(list);
        return pageInfo;
    }
    Mapper.xml:
    <select id="selectAllStudent" resultMap="StudentMap">
        select id,name,age,sex,school,class_id,telephone from student
</select>
   Controller层：
@GetMapping("students")
    public PageInfo<Student> findAllStudent(int num){
        PageHelper.startPage(num,7);
        List<Student> list= studentService.findAllStudent();
        PageInfo<Student> page = new PageInfo<Student>(list);
        return page;
    }

学生信息修改功能：
	Mapper.xml:
	<update id="updateStudent">
update student set name = #{name},age = #{age},sex = #{sex},school = #{school},class_id = #{class_id},telephone = #{telephone}
        where id = #{id}
    </update>
	Controller层:
		@PutMapping("student")
   		 public int updateStudent(Student student){
        System.out.println("put update");
        return studentService.reviseStudent(student);
}

学生信息的添加：
Mapper:
	<insert id="insertStudent" >
        insert into student (name,age,sex,school,class_id,telephone)
        values (#{name},#{age},#{sex},#{school},#{class_id},#{telephone})
    </insert>
Controller层：
@PostMapping("student")
    public int addStudent(Student student){
        System.out.println("要添加学生："+student);
       return studentService.addStudent(student);
    }

版本管理

1.使用git

2.将项目交给git管理

3.将项目进行add。
4.将项目进行commit

5.将项目进行push