1、xxxMapper.xml定义
<select id="leftJoinPageList" resultMap="MonitoringDataResult"
parameterType="com.ktt.carbon.verification.domain.bo.MonitoringDataBo">
SELECT d.* from carbon_monitoring_data d LEFT JOIN carbon_monitoring_site s on d.site_id=s.id
<where>
<if test="bo.siteName != null">
and site_name like concat('%',#{bo.siteName},'%')
</if>
<if test="bo.siteNumber != null">
and site_number like concat('%',#{bo.siteNumber},'%')
</if>
<if test="bo.siteNumber != null">
and site_number like concat('%',#{bo.siteNumber},'%')
</if>
</where>
where s.site_name like "%test1%"
</select>
2、xxMapper.xml
/**
* 左连接站点表分页查询
*/
Page<CarbonMonitoringDataVo> leftJoinPageList(IPage pageQuery, @Param("bo") MonitoringDataBo bo);
3、使用
@Override
public TableDataInfo<MonitoringDataVo> groupByPageList(MonitoringDataBo bo, PageQuery pageQuery) {
Page<CarbonMonitoringDataVo> carbonMonitoringDataPage = baseMapper.leftJoinPageList(pageQuery.build(), bo);
List<MonitoringDataVo> records = MonitoringDataPage.getRecords();
return TableDataInfo.build(carbonMonitoringDataPage);
}
文章来源地址https://www.toymoban.com/news/detail-609802.html
文章来源:https://www.toymoban.com/news/detail-609802.html
到了这里,关于mybatisplus自定义xml的sql语句进行自动分页的文章就介绍完了。如果您还想了解更多内容,请在右上角搜索TOY模板网以前的文章或继续浏览下面的相关文章,希望大家以后多多支持TOY模板网!