SpringBoot集成MybatisPlus及分页+Mysql

1. pom.xml依赖

        <!--mybatisplus-->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.5.3.1</version>
        </dependency>
        <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.28</version>
        </dependency>

2. application.yml 配置

spring:
  datasource:
    url: jdbc:mysql://localhost:3306/qiniuyun?useSSL=false&serverTimezone=UTC
    username: root
    password: root
    driver-class-name: com.mysql.cj.jdbc.Driver

mybatis-plus:
  configuration:
#    开启驼峰
    map-underscore-to-camel-case: true

3. 分页配置

@Configuration
//扫描mapper接口所在的包
@MapperScan("com.lzx.qiniuyun.dao")
public class MybatisPlusConfig {

    @Bean
    public MybatisPlusInterceptor mybatisPlusInterceptor(){
        MybatisPlusInterceptor mybatisPlusInterceptor=new MybatisPlusInterceptor();
        mybatisPlusInterceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));
        return mybatisPlusInterceptor;
    }

}

4. 使用
   1. 实体类

@Data
/*指定数据库表明*/
@TableName("video")
public class VideoData {
    private int id;
    private String videourl;
    private String title;
    private int tagid;
    @TableField(exist = false)
    private String tagname;
}

2. Mapper类

@Mapper
public interface VideoDao extends BaseMapper<VideoData> {
}

3. 调用类

        @Autowired
        VideoDao mapper;
        Page<VideoData> page = new Page<>(pageNum, pageSize);
        IPage<VideoData> videoDataPage = mapper.selectPage(page, null);