PostgreSQL
JDBC包Maven源:
<dependency>
<groupId>org.postgresql</groupId>
<artifactId>postgresql</artifactId>
<version>42.2.11</version>
</dependency>
JDBC信息:
# jdbc连接信息
driver=org.postgresql.Driver
url=jdbc:postgresql://10.168.x.x:5432/postgres_db
username=postgre
password=postgre
MySql
JDBC包Maven源:
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.15</version>
</dependency>
JDBC信息:
# jdbc连接信息
driver=com.mysql.cj.jdbc.Driver
url=<![CDATA[jdbc:mysql://192.168.0.221:3306/htdasm_cn?characterEncoding=utf8&allowPublicKeyRetrieval=true&useSSL=false&serverTimezone=Asia/Shanghai&rewriteBatchedStatements=true]]>
username=root
password=postgre
Oracle
JDBC包Maven源:
<dependency>
<groupId>com.oracle</groupId>
<artifactId>ojdbc6</artifactId>
<version>11.2.0.1.0</version>
</dependency>
<dependency>
<groupId>com.oracle</groupId>
<artifactId>ojdbc14</artifactId>
<version>10.2.0.1.0</version>
</dependency>
JDBC信息:
# jdbc连接信息
spring.datasource.driver-class-name=oracle.jdbc.driver.OracleDrive
spring.datasource.url=jdbc:oracle:thin:@192.168.50.215:1521:orcl
username=sys
password=sysdba