jdbc.properties:
首先在jdbc文件中配置多个数据源信息
jdbc.driverClassName=com.mysql.jdbc.Driver
orcl.jdbc.driverClassName=oracle.jdbc.driver.OracleDriver
#生产环境数据库配置
jdbc.url=jdbc:mysql://XXXX:3306/XXX?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8
jdbc.username=XXX
jdbc.password=XXX
cpool.checkoutTimeout=1000
cpool.minPoolSize=2
cpool.maxPoolSize=10
cpool.maxIdleTime=300
cpool.maxIdleTimeExcessConnections=100
cpool.acquireIncrement=2
#XX数据库配置
zg1.jdbc.url=jdbc\:oracle\:thin\:@XXX\:1522\:orcl
zg1.jdbc.username=XXX
zg1.jdbc.password=XXX
applicationContext.xml
编写DynamicDataSource.java类
并在applicationContext文件中进行动态配置
<!--创建jdbc数据源 -->
<bean id="default_dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="driverClass" value=