直接在mapper 接口内传入 Page 对象, 接口返回使用Page 对象接收就可以实现连表查询的分页
示例:
Page<EqmBaseInfoRespVO> selectByCntrNoOrTypeSizeOrCntrNos( @Param("page") Page<EqmBaseInfoDO> page, @Param("req") EqmBaseInfoQueryReq req);
<select id="selectByCntrNoOrTypeSizeOrCntrNos"
resultMap="baseInfoResp">
select baseinfo.* ,es.cntr95,es.cntr_size,es.cntr_type,es.type_size
from eqm_base_info baseinfo
left join eqm_container_certificate es
on baseinfo.deleted = es.deleted
and baseinfo.certificate_no=es.certificate_no
<where>
<if test="req.typeSize!=null and req.typeSize!=''">
and es.type_size=#{req.typeSize}
</if>
<if test="req.certificateNo!=null and req.certificateNo!=''">
and es.certificate_no=#{certificateNo}
</if>
<if test="req.cntrNos!=null and req.cntrNos.size!=0">
and baseinfo.cntr_no in
<foreach collection="req.cntrNos" close=")" open="(" item="e" separator=",">
#{e}
</foreach>
</if>
</where>
</select>