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=数据库密码
- application springboot properties sqlserver mysqlapplication springboot properties sqlserver application springboot properties就是 application springboot properties文件 application树叶springboot properties 乱码application springboot properties springboot sqlserver数据mysql application components sqlserver reinstall jdbctemplatedemo jdbctemplate application properties application properties数据库 数据 configurationproperties application properties