用jdbc连接mysql数据库(c3p0连接池篇)

最新推荐文章于 2023-12-04 18:45:56 发布

原创最新推荐文章于 2023-12-04 18:45:56 发布 · 898 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#c3p0 #java #mysql #jdbc #数据库

mysql 专栏收录该内容

6 篇文章

订阅专栏

本文介绍了一个基于c3p0的Java数据库连接池实现，通过组合配置文件和Java代码，实现了数据库连接的高效管理和资源释放。具体包括连接池的初始化配置、连接获取方法及资源关闭流程。

package cn.lfd.Utils;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import com.mchange.v2.c3p0.ComboPooledDataSource;

public class JdbcUtils_c3p0 {
	private static ComboPooledDataSource ds;
	
	static{
		 ds = new ComboPooledDataSource("lfd");//读取配置文件中名字为lfd的配置，不写的话读取默认配置
	}
	
	//从数据源中获取连接
	public static Connection getConnection() throws SQLException {
		return ds.getConnection();
	}
	
	//释放资源
	public static void release(Connection conn, Statement st, ResultSet rs) {
		if(conn!=null) {
			try {
				conn.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}finally{
				if(st!=null) {
					try {
						st.close();
					} catch (SQLException e) {
						e.printStackTrace();
					}finally{
						if(rs!=null) {
							try {
								rs.close();
							} catch (SQLException e) {
								e.printStackTrace();
							}
						}
					}
				}
			}
		}
	}
}

c3p0-config.xml文件

<?xml version="1.0" encoding="UTF-8"?>
<c3p0-config>
 <default-config>  <!--默认配置 -->
 <property name="driverClass">com.mysql.jdbc.Driver</property>
 <property name="jdbcUrl">jdbc:mysql://localhost:3306/test</property>
 <property name="user">root</property>
 <property name="password">root</property>
 <property name="automaticTestTable">con_test</property> 
<property name="checkoutTimeout">30000</property> 
<property name="idleConnectionTestPeriod">30</property> 
<property name="initialPoolSize">20</property> 
<property name="maxIdleTime">30</property> 
<property name="maxPoolSize">30</property> 
<property name="minPoolSize">10</property>
 <property name="maxStatements">200</property>
 <user-overrides user="test-user"> 
<property name="maxPoolSize">10</property> 
<property name="minPoolSize">1</property> 
<property name="maxStatements">0</property>
 </user-overrides> 
</default-config> 
<!-- This app is massive! -->

 <named-config name="lfd">    <!--名称为lfd的配置 ，自己可以自定义设置-->
 <property name="driverClass">com.mysql.jdbc.Driver</property>
 <property name="jdbcUrl">jdbc:mysql://localhost:3306/test</property>
 <property name="user">root</property>
 <property name="password">root</property>
 <property name="initialPoolSize">20</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>
 <!-- he's important, but there's only one of him --> 
<user-overrides user="master-of-the-universe"> 
<property name="acquireIncrement">1</property>
 <property name="initialPoolSize">1</property> 
<property name="minPoolSize">1</property>
 <property name="maxPoolSize">5</property> 
<property name="maxStatementsPerConnection">50</property> 
</user-overrides> 
</named-config>
</c3p0-config>

注意事项:

1.c3p0-config.xml文件必须放在src目录下

2.需要的jar包: c3p0-0.9.1.2.jar mchange-commons-java-0.2.3.4.jar