【无标题】

21. mybatis与mybatis-plus的分页查询

1. mybatis分页查询

1.1 配置文件

1.1.1 yml文件

# mybatis的配置
mybatis:
  config-location: classpath:/mybatis-config.xml # 其他配置
  mapper-locations: classpath:/mapper/*.xml # 映射文件所在地

1.1.2 xml文件

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration PUBLIC
        "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <settings>
        <!-- 设置驼峰标识 -->
        <setting name="mapUnderscoreToCamelCase" value="true"/>
        <!-- 打印SQL语句 -->
        <setting name="logImpl" value="STDOUT_LOGGING"/>
    </settings>
    <plugins>
        <!-- 分页插件 -->
        <plugin interceptor="com.github.pagehelper.PageInterceptor"/>
    </plugins>
</configuration>

1.2 具体实现

1.2.1 controller层

    @GetMapping("/{page}/{limit}")
    @Operation(summary = "查询所有品牌接口")
    public Result<PageInfo<Brand>> findAll(@PathVariable(value = "page") Integer page,
                                             @PathVariable(value = "limit")Integer limit){
        return Result.build(brandService.findAll(page, limit), ResultCodeEnum.SUCCESS);
    }

1.2.2 service层

    public PageInfo<Brand> findAll(Integer page, Integer limit) {
        PageHelper.startPage(page , limit);
        List<Brand> all = brandMapper.findAll(page, limit);
        PageInfo pageInfo = new PageInfo(all) ;
        return pageInfo;
    }