MybatisPlus自定义多表Sql分页查询

自定义sql分页的步骤

1. 第一个参数必须为分页的参数IPage，后面参数为QueryWrapper

使用的MybatisPlus的版本

<properties><mybatis.plus.version>3.1.0</mybatis.plus.version></properties>
     <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-core</artifactId>
            <version>${mybatis.plus.version}</version>
        </dependency>
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>${mybatis.plus.version}</version>
        </dependency>
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-annotation</artifactId>
            <version>${mybatis.plus.version}</version>
        </dependency>
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-extension</artifactId>
            <version>${mybatis.plus.version}</version>
        </dependency>

分页工具可以自己定义

//
@Slf4j
@Data
@ToString
@ApiModel(description = "分页请求对象")
public class PageReq<T> implements Serializable {
   

    private static final long serialVersionUID = 1L;

    @ApiModelProperty(value = "页码", required = true, example = "1")
    private int pageNo;
    @ApiModelProperty(value = "页大小", required = true, example = "20")
    private int pageSize;
    @ApiModelProperty(value = "参数实体")
    private T t;

    /**
     * 获取mysql的limit的开始位置
     *
     * @return
     */
    public int getMyStart() {
   
        return (pageNo - 1) * pageSize;
    }

    public static <T> PageReq<T> getPageReq(String json, Class<T> objClass) {
   
        ObjectMapper mapper =