Ch05_C3p0
Yang Haoran 6/2/2019 Java
# C3p0
maven依赖（记得要导2个包！！）
<dependency>
<groupId>com.mchange</groupId>
<artifactId>c3p0</artifactId>
<version>0.9.5.2</version>
</dependency>
<dependency>
<groupId>com.mchange</groupId>
<artifactId>mchange-commons-java</artifactId>
<version>0.2.15</version>
</dependency>
1
2
3
4
5
6
7
8
9
10
2
3
4
5
6
7
8
9
10
在src文件夹下配置文件：（idea要放在src的resource目录下）
c3p0配置文件名字一定是c3p0-config.xml
<?xml version="1.0" encoding="UTF-8"?>
<c3p0-config>
<!--使用默认的配置读取连接池对象-->
<default-config>
<!--连接参数-->
<property name="driverClass">com.mysql.cj.jdbc.Driver</property>
<property name="jdbcUrl">jdbc:mysql://localhost:3306/flink?serverTimezone=GMT%2B8&characterEncoding=utf-8&useSSL=false</property>
<property name="user">root</property>
<property name="password">123456</property>
<!--连接池参数-->
<!--初始化申请的连接数量-->
<property name="initialPoolSize">8</property>
<!--超时时间-->
<property name="checkoutTimeout">3000</property>
<!--连接的最大空闲时间，如果超过这个时间，某个数据库连接还没有被使用，则会断开掉这个连接如果为0，则永远不会断开连接-->
<property name="maxIdleTime">30</property>
<!--最大的连接数量-->
<property name="maxPoolSize">100</property>
<property name="minPoolSize">5</property>
<property name="maxStatements">200</property>
</default-config>
<named-config name="mysql">
<property name="acquireIncrement">5</property>
<property name="initialPoolSize">8</property>
<property name="minPoolSize">5</property>
<property name="maxPoolSize">30</property><!-- intergalactoApp adopts a different approach to configuring statement caching -->
<property name="maxStatements">0</property>
<property name="maxStatementsPerConnection">5</property>
</named-config>
</c3p0-config>
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33