C3P0的使用

使用步骤：
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();
        }
    }

}