DBCP数据库连接池:
首先导入jar : commons-dbcp-1.4.jar、commons-pool-1.5.6.jar。
手动配置:
BasicDataSource bds = new BasicDataSource();
// 设置连接数据库最基本四个条件
bds.setDriverClassName("com.mysql.jdbc.Driver");
bds.setUrl("jdbc:mysql:///demo");
bds.setUsername("root");
bds.setPassword("123");
Connection con = bds.getConnection();
使用配置文件的自动配置:
Properties props = new Properties();
FileInputStream fis = new FileInputStream("src\\dbcp.properties");
props.load(fis);
DataSource ds = BasicDataSourceFactory.createDataSource(props);
C3P0数据库连接池:
导入jar包 : c3p0-0.9.1.2.jar
手动配置:
ComboPooledDataSource cpds = new ComboPooledDataSource();
cpds.setDriverClass("com.mysql.jdbc.Driver");
cpds.setJdbcUrl("jdbc:mysql:///day18");
cpds.setUser("root");
cpds.setPassword("abc");
自动配置:
首先在src下新建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:///demo1</property>
<property name="user">root</property>
<property name="password">1997WFY.....</property>
</default-config>
</c3p0-config>
然后直接在代码中获取,
ComboPooledDataSource cpds=new ComboPooledDataSource()
Connection conn=cpds.getConnection();