尚硅谷之JDBC

package com.atguigu.utils;

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import org.apache.commons.dbutils.DbUtils;

import com.mchange.v2.c3p0.ComboPooledDataSource;

public class DBUtilsTool {

//创建数据源，用的是c3p0-config.xml文件中<default-config>

private static ComboPooledDataSource dataSource = new ComboPooledDataSource();

//获取数据源对象

public static ComboPooledDataSource getDataSource() {

return dataSource;

}

//获取连接

public static Connection getConnection() throws SQLException{

return dataSource.getConnection();

}

public static void closeQuietly(Connection conn){

DbUtils.closeQuietly(conn);

}

public static void closeQuietly(Statement st){

DbUtils.closeQuietly(st);

}

public static void closeQuietly(ResultSet rs){

DbUtils.closeQuietly(rs);

}

}