~~~ package demo2; import com.alibaba.druid.pool.DruidDataSourceFactory; import javax.sql.DataSource; import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.Properties; public class JDBCUtils { private static DataSource ds; static { try { //1. 加載配置 Properties properties = new Properties(); properties.load(JDBCUtils.class.getClassLoader().getResourceAsStream("druid.properties")); //2. 獲取DataSource ds = DruidDataSourceFactory.createDataSource(properties); }catch (Exception e){ e.printStackTrace(); } } /** * 獲取資源 * @return */ public static DataSource getDataSource(){ return ds; } /** * 獲取連接 * @return * @throws SQLException */ public static Connection getConnection() throws SQLException{ return ds.getConnection(); } /** * 釋放資源 */ public static void close(Statement stmt,Connection conn){ 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(); } } } } ~~~