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=数据库密码
标签:jdbc,springboot,spring,数据库,sqlserver,application,datasource,mysql From: https://www.cnblogs.com/luzanzan/p/17408525.html