SpringBoot关于Mysql和JDBC的配置

SpringBoot关于Mysql和JDBC的配置

首先注入依赖
MySQL和JBDC依赖

<dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-jdbc</artifactId></dependency><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId></dependency>

然后配置application文件
后缀为.properties

spring.datasource.url=jdbc:mysql://127.0.0.1:3306/test
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.driver-class-name&#sql.jdbc.Driver

后缀为.yml

 spring:datasource:username: rootpassword: 123456url: jdbc:mysql://localhost:3306/pestore?useUnicode=true&characterEncoding=utf-8&useSSL=true&serverTimezone=UTCdriver-class-name: sql.cj.jdbc.Driver

注意：配置文件和数据库连接的相对内容（url，username,password,classname)要相对应，而且要注意MySQL的版本与驱动之间的对应