Druid数据库连接池

//初始化druid连接池对象
private static DataSource dataSource;
static {
//读取properties文件
//getClassLoader()方法是得到当前类型的类加载器，类加载器的getResourceAsStream()方法来加载资源
    InputStream in = JDBCutils.class.getClassLoader().getResourceAsStream("druid.properties"); 
    Properties properties = new Properties();
    try {
        properties.load(in);
//直接通过文件创建druid连接池连接
        dataSource = DruidDataSourceFactory.createDataSource(properties);
    } catch (Exception e) {
        e.printStackTrace();
    }
}
//设置方法获取数据库连接对象
public static Connection getConnction() throws SQLException {
    return dataSource.getConnection();
}
public static DataSource getDataSource() {
    return dataSource;
}
//关闭连接
public static void close(Statement statement, Connection conn) throws SQLException {
    statement.close();
    conn.close();
}
public static void close(Statement statement, Connection conn, ResultSet resultSet) throws SQLException {
    if(statement != null){
        statement.close();
    }
    if(conn != null){
        conn.close();
    }
    if(resultSet != null){
        resultSet.close();
    }
}