关于mybatis映射文件中表一对多时分页异常解决方法

   <resultMap id="resultMapName" type="com.cn.entity.实体类名">
        <id property="id" column="id"/>
        <result property="stuId" column="stu_id"/>
        <result property="subjectId" column="subject_id"/>
        <result property="score" column="score"/>
        <result property="createPeople" column="create_people"/>
        <result property="updatePeople" column="update_people"/>
        <result property="createTime" column="create_time" jdbcType="TIMESTAMP"/>
        <result property="updateTime" column="update_time" jdbcType="TIMESTAMP"/>
        <collection property="实体类1中List集合名字"  select="selectItem" column="id" ofType="com.cn.entity.实体类名2">
            <id property="id" column="id"/>
            <result property="scoreId"  column="score_id" />
            <result property="nameId"  column="name_id" />
            <result property="score"  column="score" />
            <result property="createPeople"  column="create_people" />
            <result property="updatePeople"  column="update_people" />
            <result property="createTime"  column="create_time" jdbcType="TIMESTAMP" />
            <result property="updateTime"  column="update_time" jdbcType="TIMESTAMP"/>
            <result property="moduleName"  column="module_name" />
        </collection>
    </resultMap>

    <select id="selectItem" resultType="com.cn.entity.实体类名2">
        select
        is.id,
        is.score_id,
        is.name_id,
        is.score,
        em.name as module_name
        from item_score is
        left join exam_module em on em.id=is.name_id
        where  is.score_id=#{id}
    </select>

 <select id="queryList" resultMap="resultMapName">
        select
        s.id, s.stu_id, s.score,s.subject_id
        from
        score_table s
        where 1=1
    <if test="obj != null and obj.classId != null">
            and s.stu_id = #{studentId}
   </if>
   <if test="offset != null and limit != null">
            limit #{offset}, #{limit}
   </if>
    </select>

这个字段就是关键----获取查询语句并封装结果集到list中(类似一直接写一个子查询),所以并不会影响到分页

select=“selectItem” column=“id”