使用Mybatis-plus实现两个表联合查询分页

转载已于 2023-04-06 15:49:09 修改 · 2.7k 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

原文链接：https://blog.csdn.net/lyq_cc/article/details/119063556

标签

#java

于 2022-06-13 17:34:09 首次发布

该博客介绍了如何利用Mybatis-plus进行两个表的联合查询并实现分页功能。示例中展示了Page对象的使用，以及Mapper中的SQL查询，通过LEFT JOIN连接两个表并根据条件过滤数据，最后按指定字段排序。适用于需要在Java后端进行复杂数据查询的场景。

使用Mybatis-plus实现两个表联合查询分页_lyq_cc的博客-CSDN博客_mybatisplus 两个表分页

eg:

Page导包 : import com.baomidou.mybatisplus.extension.plugins.pagination

Page<TbQuantityElectricityDTO> getElectricitysByEId(TbQuantityElectricityQuery tbQuantityElectricityQuery);

@Override
public Page<TbQuantityElectricityDTO> getElectricitysByEId(TbQuantityElectricityQuery tbQuantityElectricityQuery) {
Page<TbQuantityElectricityDTO> page = new Page<>(tbQuantityElectricityQuery.getPageNum(), tbQuantityElectricityQuery.getPageSize())
Page<TbQuantityElectricityDTO> userDayPowerPage = tbQuantityElectricityMapper.getElectricitysByEId(page, tbQuantityElectricityQuery);
return userDayPowerPage;
}

Mapper:

<TbQuantityElectricityDTO> page, @Param("tbQuantityElectricityQuery") TbQuantityElectricityQuery tbQuantityElectricityQuery);

Mapper:

<select id="getElectricitysByEId" resultType="com.power.market.dto.TbQuantityElectricityDTO">

SELECT qe.*,ui.ElectricInstrument_id electricInstrumentId,ui.User_num2 userNum2,ui.User_Name userName,ui.User_Address
FROM tbQuantity_Electricity qe
LEFT JOIN tbUser_Info ui on qe.User_ID = ui.User_Id
where qe.DeleteFlag=0
<if test="tbQuantityElectricityQuery.electricInstrumentId != null and tbQuantityElectricityQuery.electricInstrumentId !='' " >
and ui.ElectricInstrument_id = #{tbQuantityElectricityQuery.electricInstrumentId}
</if>
<if test="tbQuantityElectricityQuery.haveCalculated != null and tbQuantityElectricityQuery.haveCalculated !='' " >
AND qe.haveCalculated = #{tbQuantityElectricityQuery.haveCalculated}
</if>
<if test="tbQuantityElectricityQuery.buro != null and tbQuantityElectricityQuery.buro !='' " >
and ui.buro = #{tbQuantityElectricityQuery.buro}
</if>

ORDER BY qe.Meter_Time desc

</select>