mybatis-plus 自定义xml实现分页

1、定义实体类

2、定义一个mapper接口

public interface xxxMapper extends BaseMapper<xxxx> {
    IPage<xxx> queryUserReportRecordList(IPage<xxx> page,@Param("dto") xxxx dto);

}

3、编写xml

<?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="xxx.mapper.xxMapper">

    

    <select id="xxx"
            resultType="xxx.xxx.xxx"
            parameterType="xxx.xxx">
        SELECT
            *
        FROM
            xxxx
        <where>
            <if test="dto.xxx != null">
                AND RETD_STATUS = ${dto.xxx}
            </if>
  
            <if test="dto.xxx != null ">
                AND USER_ID in
                <foreach collection="dto.xxx" item="sss" index="index" open="(" close=")" separator=",">
                    #{sss}
                </foreach>
            </if>
  
        </where>
        order by CREATE_TIME desc
    </select>
</mapper>