#oracle
driverClassName = oracle.jdbc.OracleDriver
url = jdbc:oracle:thin:@127.0.0.1:1521:orcl
username = scott
password = tiger
#验证使用的SQL语句
validationQuery=SELECT 'x' FROM DUAL
#指明连接是否被空闲连接回收器(如果有)进行检验.如果检测失败,则连接将被从池中去除.
testWhileIdle=true
#指明在从池中租借对象时是否要进行校验,如果对象校验失败,则对象将从池子释放,然后我们将尝试租借另一个
testOnBorrow=true
#指明在将对象归还给连接池前是否需要校验。
testOnReturn=false
#是否为默认数据源(默认false,只能有一个数据源设置为true) true:是 false:否
isDefault = true
#mysql
driverClassName = com.mysql.cj.jdbc.Driver
url = jdbc:mysql://127.0.0.1:3306/bxt?useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8
username = root
password = 123456
#sqlserver
driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
url=jdbc:sqlserver://localhost:1433;database=bxt
username=sa
password=123456
pom.xml
<!-- oracle -->
<dependency>
<groupId>com.oracle</groupId>
<artifactId>ojdbc6</artifactId>
<version>11.2.0.3</version>
</dependency>
<!-- mysql -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<!-- sql server -->
<dependency>
<groupId>com.microsoft.sqlserver</groupId>
<artifactId>sqljdbc4</artifactId>
<version>4.0</version>
</dependency>