1.mysql连接
spring.datasource.url=jdbc:mysql://192.168.1.1:3306/testDemo?useSSL=false&useUnicode=true&characterEncoding=utf-8&autoReconnect=true&serverTimezone=Asia/Shanghai
spring.datasource.username=your-name
spring.datasource.password=your-password
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.21</version>
</dependency>
2.postgre连接
spring:
datasource:
url: jdbc:postgresql://192.168.1.1:5432/database-name
username: your-name
password: your-password
3.oracle连接
spring.datasource.driver-class-name = oracle.jdbc.driver.OracleDriver
spring.datasource.url = jdbc\:oracle\:thin\:@192.168.1.1\:1521\:orcl
spring.datasource.username = your-name
spring.datasource.password = your-password
4.mongo连接
spring.data.mongodb.uri=mongodb://your-name:your-password@192.168.1.1:27017/database-name
5.mariadb连接
<dependency>
<groupId>org.mariadb.jdbc</groupId>
<artifactId>mariadb-java-client</artifactId>
<version>2.7.2</version>
</dependency>
spring.datasource.driver-class-name = org.mariadb.jdbc.Driver