SpringBoot+PostgreSQL/Oracle/MySQL连接配置

1. SpringBoot 配置连接mysql数据库

添加依赖

    mysql
    mysql-connector-java
    6.0.6

在application.properties 文件 添加配置

#数据库连接信息
spring.datasource.url=jdbc:mysql://localhost:3306/boot_transaction?useUnicode=true&characterEncoding=UTF-8&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC
spring.datasource.username=root
spring.datasource.password=root
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQL5Dialect
spring.jpa.database=mysql

2. SpringBoot 配置连接Oracle数据库　

添加依赖

    com.oracle.database.jdbc
    ojdbc8
    21.1.0.0

在application.properties 文件 添加配置

#spring.datasource.url=jdbc:oracle:thin:@//主机名:端口号/服务名
spring.datasource.url=jdbc:oracle:thin:@//Host Name:port/Service Name
spring.datasource.username=username
spring.datasource.password=pwd
spring.datasource.driver-class-name=oracle.jdbc.OracleDriver
spring.jpa.database-platform=org.hibernate.dialect.Oracle10gDialect

3. SpringBoot 配置连接Oracle数据库

添加依赖

    org.postgresql
    postgresql
    42.2.20

在application.properties 文件 添加配置

#postgresql
spring.datasource.url=jdbc:postgresql://serverip:port/yourdatabasename?currentSchema=yourschemaname
spring.datasource.username=username
spring.datasource.password=password
spring.datasource.driver-class-name=org.postgresql.Driver
spring.jpa.database-platform=org.hibernate.dialect.PostgreSQLDialect