Druid连接池工具类，配置文件在resource下读取

标题Druid连接池工具类，配置文件在resource下读取

public class JDBCUtil {
    private static DataSource dataSource;
    static {
        //只会在类加载的时候创建一次Druid连接池
        try {
            Properties properties = new Properties();
            InputStream in = JDBCUtil.class.getClassLoader().getResourceAsStream("druidconfig.properties");
            properties.load(in);
            dataSource = DruidDataSourceFactory.createDataSource(properties);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    public static DataSource getDataSource(){
        return dataSource;
    }
    /**
     * 获取连接的方法
     * @return
     */
    public static Connection getConnection() throws SQLException {
        //从连接池中获取连接
        return dataSource.getConnection();
    }

    /**
     * 关闭资源的方法
     * @param conn
     * @param stm
     * @throws SQLException
     */
    public static void close(Connection conn, Statement stm) throws SQLException {
        stm.close();
        conn.close();
    }

    /**
     * 关闭资源的方法
     * @param conn
     * @param stm
     * @param rst
     * @throws SQLException
     */
    public static void close(Connection conn, Statement stm, ResultSet rst) throws SQLException {
        close(conn,stm);
        rst.close();
    }
}