一、集成JDBC
1.引入相关模块(pom会自动导入相关启动器):
2.编写yaml文件链接数据库:
spring:
datasource:
username: root
password: 123456
#?serverTimezone=UTC解决时区的报错
url: jdbc:mysql://localhost:3306/springboot? serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8
driver-class-name: com.mysql.cj.jdbc.Driver
注1:时区异常报错
注2:多个配置文件存在时,注意优先性!!否则测试数据库连接会存在问题!
二、集成Druid![](https://img-blog.csdnimg.cn/74b2ca2bc533452aa21ed0898bb3839c.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA6IGq5piO5Ly25L-Q5p2o5qGD5a2Q,size_20,color_FFFFFF,t_70,g_se,x_16)
导入依赖:
<!-- https://mvnrepository.com/artifact/com.alibaba/druid -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.2.8</version>
</dependency>
自定义数据源:
三、整合Mybatis
1.导入依赖
2.配置文件中指定
(Mybatis-plus更加方便,待学习)