c3p0与DBCP连接池

最新推荐文章于 2021-08-23 12:42:20 发布

原创最新推荐文章于 2021-08-23 12:42:20 发布 · 217 阅读

0 ·

CC 4.0 BY-SA版权

MySQL 专栏收录该内容

8 篇文章

订阅专栏

import com.mchange.v2.c3p0.ComboPooledDataSource;
import org.apache.commons.dbcp.BasicDataSource;
import org.apache.commons.dbcp.BasicDataSourceFactory;

import javax.sql.DataSource;
import java.beans.PropertyVetoException;
import java.io.InputStream;
import java.util.Properties;

public class DataSourceUtil {
    //DBCP连接池硬编码形式
    public static DataSource getDataSourceWithDBCP(){
        BasicDataSource dbcp = new BasicDataSource();
        dbcp.setDriverClassName("com.mysql.jdbc.Driver");
        dbcp.setUrl("jdbc:mysql://localhost:3306/stu");
        dbcp.setUsername("root");
        dbcp.setPassword("root");
        dbcp.setInitialSize(20);
        dbcp.setMaxActive(10);

        return dbcp;
    }
//DBCP配置文件方式
    public static DataSource getDataSourceWithDBCPByProperties() throws Exception {
        DataSource dbcp =  null;
        Properties props = new Properties();
        InputStream input = new DBCPDemo().getClass().getClassLoader().getResourceAsStream("dbcpconfig.properties");

        props.load(input);

        dbcp = BasicDataSourceFactory.createDataSource(props);

        return dbcp;
    }


//C3P0硬编码形式
    public static DataSource getDataSourceWithC3P0() throws PropertyVetoException {
        ComboPooledDataSource c3p0 = new ComboPooledDataSource();
        c3p0.setDriverClass("com.mysql.jdbc.Driver");
        c3p0.setJdbcUrl("jdbc:mysql://localhost:3306/stu");
        c3p0.setUser("root");
        c3p0.setPassword("root");

        return c3p0;
    }


    //C3P0使用配置文件方式
    public static DataSource getDataSourceWithC3P0ByXML() throws PropertyVetoException {
        ComboPooledDataSource c3p0 = new ComboPooledDataSource("wpc");

        return c3p0;
    }
    
}