c3p0 和 dbcp的配置

c3p0配置是在src目录下建一个c3p0-config.xml文件：

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

<c3p0-config>
<default-config>
<property name="driverClass">com.microsoft.sqlserver.jdbc.SQLServerDriver</property>
<property name="jdbcUrl">jdbc:sqlserver://localhost:1433;DatabaseName=testuser</property>
<property name="user">sa</property>
<property name="password">pass</property>

<property name="acquireIncrement">5</property>
<property name="initialPoolSize">10</property>
<property name="minPoolSize">5</property>
<property name="maxPoolSize">20</property>
</default-config>
<named-config name="flx">
<property name="driverClass">com.microsoft.sqlserver.jdbc.SQLServerDriver</property>
<property name="jdbcUrl">jdbc:sqlserver://localhost:1433;DatabaseName=testuser</property>
<property name="user">sa</property>
<property name="password">pass</property>
<property name="acquireIncrement">50</property>
<property name="initialPoolSize">100</property>
<property name="minPoolSize">50</property>
<property name="maxPoolSize">1000</property>
</named-config>

</c3p0-config>

dbcp的配置是需要在META-INF目录下创建一个context.xml文件：

<?xml version="1.0" encoding="utf-8"?>
<Context>

<!--mysql的数据库-->
<!-- <Resource name="jdbc/mysql"
type="javax.sql.DataSource"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/bookstore"
username="root"
password="123"
maxactive="40"
maxIdle="2"
minIdle="1"
maxWait="50000"
/> -->

<!--oracle的数据库-->
<Resource name="jdbc/oracle"
type="javax.sql.DataSource"
driverClassName="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@localhost:1521:oracle"
username="jani"
password="pass"
maxactive="40"
maxIdle="2"
minIdle="1"
maxWait="50000"
/> 
</Context>

下面是jdbc的工具类

package com.utils;
import java.sql.Connection;
import java.sql.SQLException;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.sql.DataSource;
import org.apache.commons.dbutils.QueryRunner;
import com.mchange.v2.c3p0.ComboPooledDataSource;
public class JdbcUtils {

//c3p0获取数据源
public static DataSource getDataSource1(){
DataSource ds  = new ComboPooledDataSource();
return ds;
}


//dbcp获取数据源
public static DataSource getDataSource2(){
DataSource ds = null;
try {
Context c = new InitialContext();
ds = (DataSource) c.lookup("java:/comp/env/jdbc/oracle");
} catch (Exception e) {
e.printStackTrace();
}
return ds;
}

public static Connection getConnection(){
Connection conn=null;
try {
conn = getDataSource1().getConnection();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return conn;
}

public static QueryRunner getQueryRunner(){
DataSource ds=getDataSource1();
QueryRunner qr=new QueryRunner(ds);
return qr;
}
}