使用步骤:
1.添加JAR包
添加路径:web应用 WEB-INF/lib
2.编写配置文件:c3p0-config.xml 放在web应用 src目录下
<?xml version="1.0" encoding="UTF-8"?>
<c3p0-config>
<default-config>
<property name="driverClass">oracle.jdbc.OracleDriver</property>
<property name="jdbcUrl">jdbc:oracle:thin:@127.0.0.1:1521:ORACLE</property>
<property name="user">WUXS</property>
<property name="password">ADMIN</property>
<property name="maxIdleTime">30</property>
<property name="maxPoolSize">100</property>
<property name="minPoolSize">10</property>
<property name="maxStatements">200</property>
</default-config>
</c3p0-config>
编写工具类:C3P0Utils.java
package com.wxs.utils;
import java.sql.Connection;
import java.sql.SQLException;
import javax.sql.DataSource;
import com.mchange.v2.c3p0.ComboPooledDataSource;
public class C3P0Utils {
private static ComboPooledDataSource cpds = new ComboPooledDataSource();
//获取数据源
public static DataSource getDataSource(){
return cpds;
}
//获取连接
public static Connection getConnection(){
try {
return cpds.getConnection();
} catch (SQLException e) {
throw new ExceptionInInitializerError("初始化错误");
}
}
}
编写测试类:
package com.wxs.test;
import static org.junit.Assert.*;
import java.sql.SQLException;
import java.util.List;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanListHandler;
import org.junit.Before;
import org.junit.Test;
import com.wxs.utils.C3P0Utils;
import com.wxs.utils.User;
public class testC3P0 {
@Before
public void setUp() throws Exception {
}
@Test
public void test() {
QueryRunner rq =new QueryRunner(C3P0Utils.getDataSource());
try {
List<User> list=rq.query("select * from tuser", new BeanListHandler<User>(User.class));
for (User user : list) {
System.out.println(user.getUsername()+" "+user.getPassword());
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}