Mybitis-Plus自定义分页

添加maven依赖

<dependency>
	<groupId>com.baomidou</groupId>
	<artifactId>mybatis-plus-boot-starter</artifactId>
	<version>3.1.0</version>
</dependency>

properties

mybatis-plus.typeAliasesPackage=com.gx.domain
mybatis-plus.mapper-locations=classpath:/mapper/*Mapper.xml

添加分页插件

@Configuration
@EnableTransactionManagement
public class MyBatisPlusConfig {

    /**
     * 分页插件
     */
    @Bean
    public PaginationInterceptor paginationInterceptor() {
        return new PaginationInterceptor();
    }

    /**
     * 打印 sql
     */
    @Bean
    public PerformanceInterceptor performanceInterceptor() {
        PerformanceInterceptor performanceInterceptor = new PerformanceInterceptor();
        //格式化sql语句
        Properties properties = new Properties();
        properties.setProperty("format", "true");
        performanceInterceptor.setProperties(properties);
        return performanceInterceptor;
    }
}

编写mapper接口

public interface TravelPointMapper extends BaseMapper<TravelPoint> {

    IPage<TravelPoint> selectTravePonintPage(IPage<TravelPoint> pagination, @Param("dto") QueryTravePointPageDTO queryTravePointPageDTO);

}

mapper文件

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.gx.mapper.TravelPointMapper">

    <select id="selectTravePonintPage" resultType="com.gx.domain.TravelPoint">
        select
            stp.*, sp.thumb
        from
            sent_travel_point stp
        left join
            sent_picture sp
        on
            stp.logo = sp.id
        where
            stp.status = 1
            <if test="dto.type != null and dto.type != ''">
                and stp.type = #{dto.type}
            </if>
        order by
            stp.sort
    </select>
</mapper>

调用Mapper接口

Page<TravelPoint> page = new Page<>();
page.setSize(queryTravePointPageDTO.getSize());
page.setCurrent(queryTravePointPageDTO.getCurrent());
IPage<TravelPoint> travelPointIPage = travelPointMapper.selectTravePonintPage(page, queryTravePointPageDTO);