DBCP数据库连接池封装

package com3Util;

import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Properties;

import javax.sql.DataSource;

import org.apache.commons.dbcp.BasicDataSourceFactory;
import org.junit.Test;

public class DBCPUtil {
	private static DataSource source=null;
	//通过静态代码块读取配置文件信息，创建数据库连接池
	static{
		try {
			InputStream is=ClassLoader.getSystemClassLoader().getSystemResourceAsStream("dbcp.properties");
			Properties pros=new Properties();
			pros.load(is);
			source=BasicDataSourceFactory.createDataSource(pros);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	@Test
	public static Connection testConnection() throws Exception{
		
		Connection conn=source.getConnection();
		System.out.println("数据库连接状态："+conn);
		return conn;
	}
	public static void connectionClose(Connection conn,PreparedStatement ps){
		try {
			if(ps!=null)
				ps.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		
		try {
			if(conn!=null)
				conn.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	public static void connectionClose(Connection conn,PreparedStatement ps,ResultSet rs){
		try {
			if(ps!=null)
				ps.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		try {
			if(rs!=null)
				rs.close();
		} catch (SQLException e1) {
			e1.printStackTrace();
		}
		try {
			if(conn!=null)
				conn.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
}

在关闭资源这部分，可以使用dbutils.jar包提供的关闭资源方法，使用方法如下：

	//方法一
	public static void dbutilscolse1(Connection conn,PreparedStatement ps){
		try {
			DbUtils.close(conn);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		try {
			DbUtils.close(ps);
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	public static void dbutilscolse11(Connection conn,PreparedStatement ps,ResultSet rs){
		try {
			DbUtils.close(conn);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		try {
			DbUtils.close(ps);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		try {
			DbUtils.close(rs);
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	//方法二
	public static void dbutilscolse2(Connection conn,PreparedStatement ps){
		DbUtils.closeQuietly(conn);
		DbUtils.closeQuietly(ps);
	}
	public static void dbutilscolse22(Connection conn,PreparedStatement ps,ResultSet rs){
		DbUtils.closeQuietly(conn);
		DbUtils.closeQuietly(ps);
		DbUtils.closeQuietly(rs);
	}