JDBCUtil2工具类

package com.fengya.util;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.sql.DataSource;

import com.mchange.v2.c3p0.ComboPooledDataSource;

public class JDBCUtil2 {
	
	static ComboPooledDataSource dataSource = null;

	static {
		dataSource = new ComboPooledDataSource();
	}
	
	public static DataSource getDataSource() {
		return dataSource;
	}

	public static Connection getConn() {
		try {
			return dataSource.getConnection();
		} catch (SQLException e) {
			System.out.println("数据库连接错误了哦！");
			e.printStackTrace();
		}
		return null;
	}

	public static void release(Connection conn, Statement st, ResultSet rs) {
		closePS(st);
		closeRS(rs);
		closeConn(conn);
	}
	
	public static void release(Connection conn, Statement st) {
		closePS(st);
		closeConn(conn);
	}

	private static void closeConn(Connection conn) {
		try {
			if (conn != null) {
				conn.close();
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			conn = null;
		}
	}

	private static void closePS(Statement st) {
		try {
			if (st != null) {
				st.close();
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			st = null;
		}
	}

	private static void closeRS(ResultSet rs) {
		try {
			if (rs != null) {
				rs.close();
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			rs = null;
		}
	}
}