SpringBoot集成MybatisPlus

最新推荐文章于 2024-12-15 20:05:58 发布

原创最新推荐文章于 2024-12-15 20:05:58 发布 · 114 阅读

0 ·

CC 4.0 BY-SA版权

本文详细介绍如何在Spring Boot项目中引入并配置MyBatis Plus、Druid数据源以及MySQL连接器，实现高效数据库操作。涵盖依赖引入、配置参数设置及启动类注解使用。

引入依赖：

<!-- mysql connector java -->
<dependency>
   <groupId>mysql</groupId>
   <artifactId>mysql-connector-java</artifactId>
   <version>8.0.16</version>
</dependency>

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

<!-- alibaba druid -->
<dependency>
   <groupId>com.alibaba</groupId>
   <artifactId>druid</artifactId>
   <version>1.0.25</version>
</dependency>

<dependency>
   <groupId>com.baomidou</groupId>
   <artifactId>mybatis-plus-generator</artifactId>
   <version>3.1.2</version>
</dependency>

<dependency>
   <groupId>org.freemarker</groupId>
   <artifactId>freemarker</artifactId>
</dependency>

添加配置

server:
  port: 项目端口号

spring:
  datasource:
    username: 数据库账号
    password: 数据库密码
    url: jdbc:mysql://IP:3306/数据库名称?useUnicode=true&characterEncoding=utf-8&useSSL=true&serverTimezone=UTC
    driver-class-name: com.mysql.cj.jdbc.Driver
    type: com.alibaba.druid.pool.DruidDataSource
  druid:
    initial-size: 5
    min-idle: 5
    max-active: 20
    max-wait: 60000
    time-between-eviction-runs-millis: 60000
    min-evictable-idle-time-millis: 300000
    validation-query: SELECT 1 FROM DUAL
    test-while-idle: true
    test-on-borrow: true
    test-on-return: false
    pool-prepared-statements: true
    max-pool-prepared-statement-per-connection-size: 20
    filters: stat,wall
    use-global-data-source-stat: true
    connect-properties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000

mybatis-plus:
  mapper-locations: classpath:mapper/*Mapper.xml
  type-aliases-package: 实体类包路径

启动类添加mapper接口扫描器