工具组件jar包: c3p0-0.9.1.2.jar
目标: 使用c3p0工具组件,进行连接Mysql数据库、Oracle数据库。
一、 使用c3p0工具组件连接Mysql数据库
1、Mysql数据库的基本信息: Mysql中的配置,IP地址: 127.0.0.1:3306, 账号/密码:root/root123, 连接root账号下的'mybatis'数据库
2、XML文件中的配置信息为:
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">
<!-- Mysql数据库配置信息,本地测试数据库. @moon 2019/06/25 14:45 -->
<property name="driverClass" value="com.mysql.jdbc.Driver" />
<property name="jdbcUrl" value="jdbc:mysql://127.0.0.1:3306/mybatis" />
<property name="user" value="root" />
<property name="password" value="root123" />
<property name="acquireIncrement" value="3"></property>
<property name="maxIdleTime" value="300"></property>
<property name="initialPoolSize" value="1"></property>
<property name="maxPoolSize" value="20"></property>
<property name="minPoolSize" value="5"></property>
<property name="maxStatements" value="1"></property>
<property name="maxStatementsPerConnection" value="100"></property>
</bean>
二、 使用c3p0工具组件连接Oracle数据库
1、Oracle数据库的第一种配置, 其如下所示:
# Oracle中的第一个配置
# 用户/密码: moon/123456, alice/123654
TEST_NEW =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = SMARTBSS)
)
)
2、 连接 Oracle数据库的第一种配置下的 'alice'用户。XML文件中的配置信息如下所示:
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">
<!-- Oracle数据库配置信息,目标数据库. @moon 2019/06/25 14:56 -->
<property name="driverClass" value="oracle.jdbc.driver.OracleDriver"/>
<property name="jdbcUrl" value="jdbc:oracle:thin:@127.0.0.1:1521:SMARTBSS"/>
<property name="user" value="alice"/>
<property name="password" value="123654"/>
<property name="acquireIncrement" value="3"></property>
<property name="maxIdleTime" value="300"></property>
<property name="initialPoolSize" value="1"></property>
<property name="maxPoolSize" value="20"></property>
<property name="minPoolSize" value="5"></property>
<property name="maxStatements" value="1"></property>
<property name="maxStatementsPerConnection" value="100"></property>
</bean>
3、Oracle数据库的第二种配置, 其如下所示:
# Oracle中的第二个配置
# 用户/密码: moon/123456, alice/123654
moonbdb =
(DESCRIPTION =
(FAILOVER=ON)
(LOAD_BALANCE=ON)
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 3001))
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.2)(PORT = 3001))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = moonbdb)
( FAILOVER_MODE=
(TYPE=SELECT)
(METHOD=BASIC))
)
)
4、 连接 Oracle数据库的第二种配置下的 'moon'用户。XML文件中的配置信息如下所示。
其中 <property name="jdbcUrl" value="...@...">标签中的 '@' 符号后面包含了整个“Oracle中的第二个配置”内容。内容为: (DESCRIPTION .... METHOD=BASIC)))) 。
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">
<!-- Oracle数据库配置信息,目标数据库. @moon 2019/06/25 15:08 -->
<property name="driverClass" value="oracle.jdbc.driver.OracleDriver"/>
<property name="jdbcUrl" value="jdbc:oracle:thin:@(DESCRIPTION =(FAILOVER=ON)(LOAD_BALANCE=ON)(ADDRESS=(PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 3001))(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.2)(PORT = 3001))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = moonbdb)(FAILOVER_MODE= (TYPE=SELECT)(METHOD=BASIC))))"/>
<property name="user" value="moon"/>
<property name="password" value="123456"/>
<property name="acquireIncrement" value="3"></property>
<property name="maxIdleTime" value="300"></property>
<property name="initialPoolSize" value="1"></property>
<property name="maxPoolSize" value="20"></property>
<property name="minPoolSize" value="5"></property>
<property name="maxStatements" value="1"></property>
<property name="maxStatementsPerConnection" value="100"></property>
</bean>