C3P0连接池及其工具类的使用

准备工作：
1.导包

2.配置c3p0-config.properties文件

3.数据库准备

二、正式开始
1.使用成c3p0连接池对数据库进行查询

package com.henu.c3p0;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import javax.sql.DataSource;
import com.henu.until.C3P0Utill;
import com.mchange.v2.c3p0.ComboPooledDataSource;

public class Demo1_c3p0 {

	public static void main(String[] args) throws Exception {
		// c3p0提供的ComboPooledDataSource实现类
		// 默认加载src下的c3p0-config.xml中的<default-config>的配置
		DataSource ds = new ComboPooledDataSource();
		//加载src下的c3p0-config.xml中的<named-config name="henu">的配置
		//DataSource ds = new ComboPooledDataSource("henu");
		
		Connection conn = ds.getConnection();
		PreparedStatement ps = conn.prepareStatement("select * from student");
		ResultSet rs = ps.executeQuery();
		while (rs.next()) {
			System.out.println(rs.getInt("id") + "\t" + rs.getString("name") + "\t" + rs.getInt("age") + "\t"
					+ rs.getDate("birthday"));
		}
		rs.close();
		ps.close();
		conn.close();

	}

}

2.工具类C3P0Util的创建

package com.henu.until;

import java.sql.Connection;
import javax.sql.DataSource;

import com.mchange.v2.c3p0.ComboPooledDataSource;

public class C3P0Util {
	private static DataSource ds;
	static{
		ds = new ComboPooledDataSource();
	}
	public static DataSource getDataSource(){
		return ds;
		
	}
	public static Connection getConnection() throws Exception{
		Connection conn = ds.getConnection();
		return  conn;
		
	}
}

3.使用工具类进行查询操作

package com.henu.c3p0;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import javax.sql.DataSource;
import com.henu.until.C3P0Util;
import com.mchange.v2.c3p0.ComboPooledDataSource;

public class Demo1_c3p0 {

	public static void main(String[] args) throws Exception {
		Connection conn = C3P0Util.getConnection();
		PreparedStatement ps = conn.prepareStatement("select * from student");
		ResultSet rs = ps.executeQuery();
		while (rs.next()) {
			System.out.println(rs.getInt("id") + "\t" + rs.getString("name") + "\t" + rs.getInt("age") + "\t"
					+ rs.getDate("birthday"));
		}
		rs.close();
		ps.close();
		conn.close();

	}

}