src/main/java/com/system/mapper/StudentMapperCustom.xml

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >

<mapper namespace="com.system.mapper.StudentMapperCustom">

    <!--一对多查询-->
    <resultMap id="StudentAndSelectCourseResultMap" type="StudentCustom">
        <!--配置映射的订单信息
            property 的值应跟 该vo 的变量名相同
            column 的值，应与对应的数据库 表字段名相同
        -->
        <id column="userID" property="userid"/>
        <result column="userName" property="username" />
        <result column="sex" property="sex" />
        <result column="birthYear" property="birthyear" />
        <result column="grade" property="grade" />
        <result column="collegeID" property="collegeid" />

        <!--collection 对关联查询到的多条记录映射到集合对象中
            property： 将关联查询到的多条信息映射到 vo 哪个属性
            ofType：映射到集合属性中 pojo 的类型
        -->
        <collection property="selectedCourseList" ofType="SelectedCourseCustom">
            <result column="courseID" property="courseid"/>
            <result column="studentID" property="studentid"/>
            <result column="mark" property="mark"/>
            <result column="coursedate" property="coursedate"/>
            <!--配置映射的关系的课程信息-->
            <association property="courseCustom" javaType="CourseCustom">
                <id column="courseID" property="courseid"/>
                <result column="courseName" property="coursename"/>
                <result column="teacherID" property="teacherid"/>
                <result column="courseTime" property="coursetime"/>
                <result column="classRoom" property="classroom"/>
                <result column="courseWeek" property="courseweek"/>
                <result column="courseType" property="coursetype"/>
                <result column="collegeID" property="collegeid"/>
                <result column="score" property="score"/>
            </association>
        </collection>
    </resultMap>

    <select id="findByPaging" parameterType="PagingVO" resultType="StudentCustom">
        select student.*, college.collegeName
        from student, college
        WHERE student.collegeID = college.collegeID
        limit #{toPageNo}, #{pageSize}
    </select>

    <select id="findStudentAndSelectCourseListById" parameterType="int" resultMap="StudentAndSelectCourseResultMap">
        SELECT
          student.*,
          selectedcourse.*,
          course.*
        FROM
          student,
          selectedcourse,
          course
        WHERE
          student.userID = #{id}