mybatis-plus新建demo，分页查询

新建demo

依赖

		<dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>

        <!--        引入mysql-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.28</version>
        </dependency>

        <!--        引入mybatis-plus-->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.2.0</version>
        </dependency>

        <!--      lombok -->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.18.8</version>
        </dependency>

        <!--      thymeleaf -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-thymeleaf</artifactId>
        </dependency>

配置

spring:
  datasource:
    username: root
    password: 123456
    url: jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai
    driver-class-name: com.mysql.jdbc.Driver


  application:
    name: gulimall-product
  jackson:
    date-format: yyyy-MM-dd HH:mm:ss

  thymeleaf:
    cache: false
    suffix: .html
    prefix: classpath:/templates/

#  redis:
#    host: 192.168.137.129
#    port: 6379

mybatis-plus:
  mapper-locations: classpath:/mapper/**/*.xml
  global-config:
    db-config:
      id-type: auto
      #      代表删除
      logic-delete-value: 1
      #      代表没删除
      logic-not-delete-value: 0
  configuration:
    # 控制台打印SQL
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl

#pagehelper分页插件配置
pagehelper:
  helperDialect: mysql
  reasonable: true
  supportMethodsArguments: true
  params: count=countSql

server:
  port: 8080

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.lingtu.gulimall.gulimallproduct.dao.AttrDao">

	<!-- 可根据自己的需求，是否要使用 -->
    <resultMap type="com.lingtu.gulimall.gulimallproduct.entity.AttrEntity" id="attrMap">
        <result property="attrId" column="attr_id"/>
        <result property="attrName" column="attr_name"/>
    </resultMap>
    <select id="selectSearchAttrIds" resultType="java.lang.Long">
        SELECT attr_id FROM `pms_attr` WHERE attr_id IN
        <foreach collection="attrIds" item="id" separator="," open="(" close=")"> #{id} </foreach>
        AND search_type = 1
    </select>
    <select id="selectPageUrl" resultType="com.example.test.entity.Data1">
        select * from t_student order by ${typeName}
    </select>
</mapper>

mybatisConfig

@Configuration
@EnableTransactionManagement//开启事务
@MapperScan("com.example.test.dao")
public class MybatisConfig {

    @Bean
    public PaginationInterceptor paginationInterceptor(){
        PaginationInterceptor paginationInterceptor = new PaginationInterceptor();
        //设置请求页面大于最大页后操作，true调回到首页，flase 继续请求 默认flase
        paginationInterceptor.setOverflow(true);
        //设置最大单页限制数量，默认500条 -1不受限制
        paginationInterceptor.setLimit(1000);
        return paginationInterceptor;
    }
}

Controller

	@GetMapping("/queryPage")
    @ResponseBody
    public Page<Data1> queryPage(
    					@PathVariable String typeName,
   						@Param("pageNum") int pageNum, 
    					@Param("pageSize") int pageSize){
        Page<Data1> pageList = dataService.queryPage(pageNum,pageSize);
        return pageList;
    }

dao

    Page<Data1> selectPageUrl(
    	@Param("page")Page<Data1> page,
    	@Param("typeName") String typeName
    	);

mybatis-plus继承

extends BaseMapper<Data1>

extends IService<Data1>

extends ServiceImpl<DataDao, Data1> implements DataService 

Impl

@Override
    public Page<Data1> queryPageUrl(int pageNum, int pageSize, String typeName) {
        Page<Data1> page = new Page<>(pageNum, pageSize);
        Page<Data1> pageResult = dataDao.selectPageUrl(page,typeName);
        return pageResult;
    }

请求 ：http://localhost:8080/test/get/queryPage?pageNum=2&pageSize=2