c3p0连接mysql数据库

导入mysql数据jar包
mysql-connector-java-5.1.49.jar
导入c3p0相关jar
c3p0-0.9.2.1.jar
mchange-commons-java-0.2.3.4.jar
导入配置文件
c3p0-config.xml
或者
c3p0.properties

import java.sql.Connection;
import java.sql.PreparedStatement;
import org.junit.Test;
import com.mchange.v2.c3p0.ComboPooledDataSource;
public class C3P0_Demo {
	//创建连接池
	private ComboPooledDataSource dataSource = new ComboPooledDataSource();
	
	@Test
	public void deleteUser() throws Exception {
		
		//从连接池中获取连接
		Connection con = dataSource.getConnection();
		String sql ="delete from user where id =?";
		//获取可执行对象
		PreparedStatement ps = con.prepareStatement(sql);
		
		ps.setInt(1, 1);
		//执行
		int row = ps.executeUpdate();
		
		if(row>0) {
			System.out.println("删除成功");
		}else {
			System.out.println("删除失败");
		}
		//关闭资源
		ps.close();
	}
	
}

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:///school</property>
		<property name="user">root</property>
		<property name="password">root</property>
		
		<property name="initialPoolSize">10</property>
		<property name="maxIdleTime">30</property>
		<property name="maxPoolSize">20</property>
		<property name="minPoolSize">5</property>
		<property name="maxStatements">200</property>
	</default-config>
	

</c3p0-config>

c3p0.properties

#c3p0

c3p0.driverClass=com.mysql.jdbc.Driver 
c3p0.jdbcUrl=jdbc:mysql://localhost:3306/test0820?useUnicode=true&characterEncoding=utf-8
c3p0.user=root 
c3p0.password=root
c3p0.acquireIncrement=3 
c3p0.idleConnectionTestPeriod=60 
c3p0.initialPoolSize=10 
c3p0.maxIdleTime=60 
c3p0.maxPoolSize=150 
c3p0.maxStatements=100 
c3p0.minPoolSize=5