package cn.itcast.utils;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;/** * @author newcityman * @date 2019/8/16 - 23:56 * Druid 的工具类 */public class JDBCUtils {// 1、定义成员变量DataSource private static DataSource ds; static {try {// 2、加载配置文件 Properties pro = new Properties(); pro.load(JDBCUtils.class.getClassLoader().getResourceAsStream("druid.properties"));// 3、获取连接对象Datasource ds = DruidDataSourceFactory.createDataSource(pro); } catch (IOException e) { e.printStackTrace(); } catch (Exception e) { e.printStackTrace(); } }/* * 获取连接的方法 * */ public static Connection getConnetion() throws SQLException {return ds.getConnection(); }/* * 释放资源 * */ public static void close(Statement stmt,Connection conn){/* if(stmt!=null){ try { stmt.close(); } catch (SQLException e) { e.printStackTrace(); } } if(conn!=null){ try { conn.close(); } catch (SQLException e) { e.printStackTrace(); } }*/ close(null,stmt,conn); }/* * 释放资源 * */ public static void close(ResultSet rs,Statement stmt, Connection conn){if(rs!=null){try { rs.close(); } catch (SQLException e) { e.printStackTrace(); } }if(stmt!=null){try { stmt.close(); } catch (SQLException e) { e.printStackTrace(); } }if(conn!=null){try { conn.close(); } catch (SQLException e) { e.printStackTrace(); } } }/* * 获取连接池方法 * */ public static DataSource getDataSource(){return ds; }}
转载于:https://www.cnblogs.com/newcityboy/p/11366983.html
相关资源：JDBC线程安全的Druid数据库连接池工具类
