mybatisplus分页插件示例（springboot）

pom

        <!--mybatis-plus包-->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.3.2</version>
        </dependency>

config

package com.sec.config;

import com.baomidou.mybatisplus.extension.plugins.OptimisticLockerInterceptor;
import com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.transaction.annotation.EnableTransactionManagement;

/**
 * mybatisplus配置类
 */
//扫描mapper文件夹
@MapperScan("com.sec.mapper")
@EnableTransactionManagement
@Configuration//配置类
public class MybatisPlusConf {


    //配置乐观锁插件
    @Bean
    public OptimisticLockerInterceptor optimisticLockerInterceptor() {
        return new OptimisticLockerInterceptor();
    }

    //配置分页插件
    @Bean
    public PaginationInterceptor paginationInterceptor() {
        PaginationInterceptor paginationInterceptor = new PaginationInterceptor();
        paginationInterceptor.setOverflow(false);
        return paginationInterceptor;
    }
}

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="com.sec.mapper.Zk_prod_tagMapper">


    <select id="queryAll" resultType="com.sec.pojo.Zk_prod_tag">
        SELECT id,title,shop_id,status,is_default,prod_count,style,seq,create_time,update_time,delete_time FROM zk_prod_tag 
        <where>
            <if test="title!=null and title!=''">
                and title like CONCAT('%','${title}','%' )
            </if>
            <if test="status!=null">
                and status=#{status}
            </if>
        </where>
    </select>
</mapper>

mapper

/**
 * <p>
 * 商品分组表 Mapper 接口
 * </p>
 *
 * @author 周坤
 * @since 2020-09-19
 */
@Repository
public interface Zk_prod_tagMapper extends BaseMapper<Zk_prod_tag> {
 /**
  * <p>
  * 查询 : 根据state状态查询用户列表，分页显示
  * </p>
  *
  * @param page 分页对象,xml中可以从里面进行取值,传递参数 Page 即自动分页,必须放在第一位(你可以继承Page实现自己的分页对象)
  * @return 分页对象
  */
 IPage<Zk_prod_tag> queryAll(Page<?> page,String title,Integer status);
}

serviceimpl

/**
 * <p>
 * 商品分组表 服务实现类
 * </p>
 *
 * @author 周坤
 * @since 2020-09-19
 */
@Service
public class Zk_prod_tagServiceImpl extends ServiceImpl<Zk_prod_tagMapper, Zk_prod_tag> implements Zk_prod_tagService {

    @Autowired
    Zk_prod_tagMapper mapper;


    @Override
    public IPage<Zk_prod_tag> queryAll(Page<?> page,String title,Integer status) {
        return mapper.queryAll(page,title,status);
    }
}

Controller

    //查看所有分组（分页查询）
    @ApiOperation(value = "所有商品分组(plus)", notes = "admin后台")
    @GetMapping("/queryall/finall/{limit}/{numberpage}")
    public  Map queryall(
                      @ApiParam("开始页数") @PathVariable("limit") Integer limit,
                      @ApiParam("总页数") @PathVariable("numberpage") Integer numberpage,
                      @ApiParam("（可变参数）标题") @RequestParam(required = false) String title,
                      @ApiParam("（可变参数）状态") @RequestParam(required = false) Integer status) {


        Page<Zk_prod_tag> page = new Page<>(limit, numberpage);
        service.queryAll(page,title,status);
        List list=page.getRecords();
        return layui.data((int) page.getTotal(),list);

    }