JDBC连接池

import com.alibaba.druid.pool.DruidDataSourceFactory;

import javax.sql.DataSource;
import java.io.IOException;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;

/**
*Druid的数据库连接池
*/
public class JDBCUtils {
private static DataSource ds;

static {
    try {
        Properties properties = new Properties();
        properties.load(JDBCUtils.class.getClassLoader().getResourceAsStream("druid.properties"));
        ds = DruidDataSourceFactory.createDataSource(properties);
    } catch (IOException e) {
        e.printStackTrace();
    } catch (Exception e) {
        e.printStackTrace();
    }
}

/**
 * 获取连接
 */
public static Connection getConnection() throws SQLException {
    return ds.getConnection();
}
/**
 * 释放资源
 */
public static void close(Statement stat,Connection connection) throws SQLException {
    close(null,stat,connection);
}

public static void close(ResultSet rs,Statement stat,Connection connection) throws SQLException {
    if (rs != null){
        try {
            rs.close();
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }
    }
    if (stat != null){
        try {
            stat.close();
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }
    }
    if (connection != null){
        connection.close();
    }
}

/**
 * 获取连接池方法
 */
public static DataSource getDataSource(){
    return ds;
}

}