Spring Boot MySQL 配置
2025/11/30小于 1 分钟
配置Mysql
Maven依赖
<!-- 数据库相关-->
<!-- mybatis-plus-->
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>${mybatis-plus}</version>
</dependency>
<!-- Druid连接池-->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid-spring-boot-starter</artifactId>
<version>${druid}</version>
</dependency>
<!-- mysql驱动-->
<dependency>
<groupId>com.mysql</groupId>
<artifactId>mysql-connector-j</artifactId>
<version>${mysql-connector-j}</version>
</dependency>
<!-- Lombok (可选,简化代码) -->
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>${lombook}</version>
</dependency>
<!-- properties属性加入版本信息-->
<properties>
<lombook>1.18.36</lombook>
<mybatis-plus>3.5.5</mybatis-plus>
<druid>1.2.19</druid>
<mysql-connector-j>8.0.33</mysql-connector-j>
</properties>yml配置
application-dev.yml:
belnuan:
spring:
#mysql
datasource:
type: com.alibaba.druid.pool.DruidDataSource
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://localhost:3306/your_database?useUnicode=true&characterEncoding=utf8&useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true
username: root
password: 123456application.yml:
spring:
#mysql
datasource:
type: ${belnuan.spring.datasource.type}
driver-class-name: ${belnuan.spring.datasource.driver-class-name}
url: ${belnuan.spring.datasource.url}
username: ${belnuan.spring.datasource.username}
password: ${belnuan.spring.datasource.password}