http://mvnrepository.com/ 这个网站可以查询所有maven库的最新版本
一.oracle
maven库上有以下版本:12.2.0.1、12.1.0.2、12.1.0.1和11.2.0.4。此外,companion jars包括simplefan.jar,ons.jar,orai18n.jar等,还提供了特定功能所需的功能。 com.oracle.jdbc ojdbc8 12.2.0.1
<dependency>
<groupId>oracle</groupId>
<artifactId>ojdbc14</artifactId>
<version>10.2.0.4</version>
</dependency>
oracle数据库的配置方式,分为两种: 1)如果是serviceName的配置方式
jdbc.driverClassName=oracle.jdbc.driver.OracleDriver
jdbc.url=jdbc:oracle:thin:@//86.103.71.2:1521/serviceName jdbc.username=username
jdbc.password=password jdbc.validationQuery=SELECT 1 FROM DUAL
2)如果是SID的配置方式时,url为:
jdbc.url=jdbc:oracle:thin:@86.103.71.2:1521:SID
https://blogs.oracle.com/dev2dev/get-oracle-jdbc-drivers-and-ucp-from-oracle-maven-repository-without-ides 这个网址有详细的英文教程
二.mysql
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.11</version> <!--$NO-MVN-MAN-VER$ -->
</dependency>
jdbc.properties文件配置:
spring.datasource.driverClassName=com.mysql.jdbc.Driver spring.datasource.url=jdbc:mysql://127.0.0.1:3306/databaseName?useSSL=false&allowPublicKeyRetrieval=true&rewriteBatchedStatements=true&characterEncoding=utf-8&serverTimezone=GMT%2B8
spring.datasource.username=root
spring.datasource.password=root
spring.datasource.type=com.zaxxer.hikari.HikariDataSource
spring.datasource.hikari.minimum-idle=5
spring.datasource.hikari.maximum-pool-size=15
spring.datasource.hikari.auto-commit=true
spring.datasource.hikari.idle-timeout=30000
spring.datasource.hikari.pool-name=DatebookHikariCP
spring.datasource.hikari.max-lifetime=1800000
spring.datasource.hikari.connection-timeout=30000
spring.datasource.hikari.connection-test-query=SELECT 1
三.sqlserver
<!-- https://mvnrepository.com/artifact/com.microsoft.sqlserver/sqljdbc4 -->
<dependency>
<groupId>com.microsoft.sqlserver</groupId>
<artifactId>sqljdbc4</artifactId>
<version>4.0</version>
<scope>test</scope>
</dependency>
驱动程序 com.microsoft.jdbc.sqlserver.SQLServerDriver
URL
jdbc:microsoft.sqlserver://127.0.0.1:1433;DatabaseName=databaseName #老版本的
jdbc:sqlserver://localhost:1433;DatabaseName=databaseName
spring.datasource.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
#spring.datasource.url=jdbc:microsoft.sqlserver://127.0.0.1:1433;DatabaseName=databaseName
spring.datasource.url=jdbc:sqlserver://127.0.0.1:1433;DatabaseName=databaseName
spring.datasource.username=sa
spring.datasource.password=root