c3p0数据库连接池

java

package com.library.util;

//导入c3p0包
import com.mchange.v2.c3p0.ComboPooledDataSource;

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

public class JDBCTools {

    private static DataSource dataSource = new ComboPooledDataSource("testc3p0");

    public static Connection getConnection(){
        Connection connection = null;
        try {
            connection = dataSource.getConnection();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return connection;
    }

    public static void release(Connection connection, Statement statement, ResultSet resultSet){
        try {
            if (connection != null) connection.close();
            if (statement !=null)statement.close();
            if (resultSet!=null)resultSet.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }

    }

}

c3p0-config.xml

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


	
		
		
		web
		123123
		com.mysql.jdbc.Driver
		jdbc:mysql://localhost:3306/webtest?useUnicode=true&characterEncoding=UTF-8
		
		
		5
		
		5
		
		5
		
		10