C3P0连接池和德鲁伊连接池

连接C3P0方式1 手动连接

    @Test
    //方式1 手动连接
    public void C3P0_01() throws PropertyVetoException, SQLException {
        ComboPooledDataSource cps = new ComboPooledDataSource();
        cps.setJdbcUrl(JDBCUtils.getUrl());
        cps.setUser(JDBCUtils.getUser());
        cps.setPassword(JDBCUtils.getPassword());
        cps.setDriverClass(JDBCUtils.getDriver());
        //初始连接数
        cps.setInitialPoolSize(10);
        //最大连接数
        cps.setMaxPoolSize(50);
        //建立连接
        Connection connection = cps.getConnection();
        connection.close();
    }

方式2 通过配置文件模板

    public void C3P0_02() throws SQLException {
        ComboPooledDataSource wzg_db02 = new ComboPooledDataSource("wzg_db02");
        Connection connection = wzg_db02.getConnection();
        connection.close();
    }

德鲁伊连接方法

    @Test
    public void Druid_01() throws Exception {
        Properties properties = new Properties();
        properties.load(new FileInputStream("src\\druid.properties"));
        DataSource dataSource = DruidDataSourceFactory.createDataSource(properties);
        Connection connection = dataSource.getConnection();
        connection.close();
    }

使用上述连接池

1.需要将对应的jar包导入到java，可以新建一个文件夹存放进去并右击添加到库

2.将对应的配置文件拖入src包下 

德鲁伊工具类

package JDBC.Tool;

import com.alibaba.druid.pool.DruidDataSourceFactory;

import javax.sql.DataSource;
import java.io.FileInputStream;
import java.io.IOException;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;

/**
 * @author whlie(true){learn}
 */
public class DruTool {
    private static DataSource ds;
    private static String user;
    private static String password;
    private static String url;
    private static String driver;

    static {
        Properties properties = new Properties();
        try {
            properties.load(new FileInputStream("src\\druid.properties"));
            user = properties.getProperty("user");
            password = properties.getProperty("password");
            url = properties.getProperty("url");
            driver = properties.getProperty("driver");
            ds = (DataSource) DruidDataSourceFactory.createDataSource(properties);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    public static Connection getConnection() throws SQLException {
        return ds.getConnection();
    }

    public static void close(ResultSet resultSet, Statement statement, Connection connection) throws SQLException {
        try {
            if (resultSet != null) {
                resultSet.close();
            }
            if (statement != null) {
                statement.close();
            }
            if (connection != null) {
                connection.close();
            }
        } catch (SQLException e) {
            throw new RuntimeException(e);
        }
    }
    public static String getUser() {
        return user;
    }

    public static String getPassword() {
        return password;
    }

    public static String getUrl() {
        return url;
    }

    public static String getDriver() {
        return driver;
    }
}