springboot中使用application.properties配置mysql和sqlserver

发布时间 2023-05-17 13:55:17作者: 妞妞猪

1.使用依赖

 * mysql:

<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>

* sqlserver:
<dependency>
<groupId>com.microsoft.sqlserver</groupId>
<artifactId>mssql-jdbc</artifactId>
<version>8.4.1.jre11</version>
</dependency>

2.在项目/src/main/resources/application.properties中加入
* mysql:
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/ 你的数据库名字 ?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone = GMT
spring.datasource.username=数据库账号
spring.datasource.password=数据库密码
*sqlserver:
spring.datasource.driver-class-name=com.microsoft.sqlserver.jdbc.SQLServerDriver
spring.datasource.url=jdbc:sqlserver://localhost:3306/ 你的数据库名字 ?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone = GMT
spring.datasource.username=数据库账号
spring.datasource.password=数据库密码