使用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>