mybatis 一对多查询 分页

第一种只有查询没有分页的

<!--主查询的resultMap-->
    <resultMap id="hornLightList" type="com.yongwei.cloud.model.HornLightModel">
        <id column="id" property="id"/>
        <result column="code" property="code"/>
        <result column="horn_type" property="hornType"/>
        <result column="factory" property="factory"/>
        <result column="address" property="address"/>
        <result column="create_time" property="createTime"/>
        <result column="play_time" property="playTime"/>
        <result column="status" property="status"/>
        <result column="vol" property="vol"/>
		<collection property="lightList" javaType="list" ofType="com.yongwei.cloud.entity.LightInfo">
           <id column="lightId" property="id"/>
            <result column="lightStatus" property="status"/>
            <result column="address" property="address"/>
            <result column="lightType" property="type"/>
        </collection>
    </resultMap>

    <select id="hornLightlist" resultMap="hornLightList">
        select h.*,l.id lightId,l.`status` lightStatus,l.type lightType
        from horn_info h LEFT JOIN light_info l
        on h.code=l.horn_id
        where 1=1
        ORDER BY h.create_time desc
    </select>

第二种有查询和分页的

<resultMap id="hornLightList" type="com.yongwei.cloud.model.HornLightModel">
    <id column="id" property="id"/>
    <result column="code" property="code"/>
    <result column="horn_type" property="hornType"/>
    <result column="factory" property="factory"/>
    <result column="address" property="address"/>
    <result column="create_time" property="createTime"/>
    <result column="play_time" property="playTime"/>
    <result column="status" property="status"/>
    <result column="vol" property="vol"/>
    <collection property="lightList"  ofType="com.yongwei.cloud.entity.LightInfo"
                select="selectLightList"
                column="code" />
</resultMap>
<!--主查询的sql-->
<select id="hornLightlist" resultMap="hornLightList">
    select h.*
    from horn_info h
    ORDER BY h.create_time desc
</select>
<!--子查询的sql-->
<select id="selectLightList" resultType="com.yongwei.cloud.entity.LightInfo">
    SELECT *
    FROM  light_info
    WHERE horn_id = #{code}
</select>