mybatis-plus 自定义xml实现分页

Coco_淳

已于 2022-03-22 10:25:11 修改

阅读量2.3k

点赞数

分类专栏： mybatis-plus 文章标签： mybatis

于 2022-03-22 10:24:35 首次发布

本文链接：https://blog.csdn.net/coco_chun/article/details/123653741

版权

mybatis-plus 专栏收录该内容

3 篇文章

订阅专栏

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>