mybatis一对多分页方案

在使用mybatis时候一对多分页，这时候分页会有问题，采用子查询

<resultMap id="getException" type="com.dcs.adminapi.BO.returnBO.ReturnInspectionExceptionBO">
        <!--column实体类列名   property为数据库中的列名 区分上边的id 列名改为aid-->
        <id property="id" column="id"></id>
        <result column="is_solve" property="isSolve"></result>
        <result column="created_time" property="createdTime"></result>
        <result column="inspection_error" property="inspectionError"></result>
        <result column="charge_person_Name" property="chargePersonName"></result>
        <result column="customer_name" property="customerName"></result>
        <result column="inspection_name" property="inspectionName"></result>

        <collection property="exceptionCode" javaType="java.util.List" ofType="java.lang.String" select="getExceptionCode" column="id"/>
    </resultMap>

<select id="getExceptionCode" resultType="java.lang.String">
        select distinct code
        from sys_inspection_content
        where function_status = '2' and del_flag = '0' and record_id = #{id}
    </select>