C3P0使用方法

package com.java.dao;

import java.sql.SQLException;

import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.ScalarHandler;
import com.java.jdbc.JDBCUtils;

public class Dao {
	public static void main(String[] args) throws SQLException {
		QueryRunner query = new QueryRunner(JDBCUtils.getDataSource());
		String sql = "SELECT COUNT(*) FROM 表名;";
		Long count = (Long) query.query(sql, new ScalarHandler());
		System.out.println(count);
	}
}

package com.java.jdbc;

import java.sql.Connection;
import java.sql.SQLException;

import javax.sql.DataSource;

import com.mchange.v2.c3p0.ComboPooledDataSource;

public class JDBCUtils {
	private static final ComboPooledDataSource DATA_SOURCE =new ComboPooledDataSource();

	public static Connection getConnection(){
		Connection conn = null;
		try {
			conn = DATA_SOURCE.getConnection();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return conn;
	}
	
	public static DataSource getDataSource(){
		return DATA_SOURCE;
	}
	
}

<?xml version="1.0" encoding="UTF-8"?>
<c3p0-config>

  <default-config>
    <property name="driverClass">com.mysql.jdbc.Driver</property>
	<property name="jdbcUrl">jdbc:mysql:///数据库名</property>
	<property name="user">root</property>
	<property name="password">密码</property>
	<property name="initialPoolSize">5</property>
	<property name="maxPoolSize">20</property>
  </default-config>
  
</c3p0-config>

项目图片:

 

需要引用的lib里的3个jar包