idea配置数据库连接池

package jdbc.dataSource.jdbcutils; ​ import com.alibaba.druid.pool.DruidDataSourceFactory; ​ import javax.sql.DataSource; import java.io.InputStream; idea配置数据库连接池import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.Properties; ​ / * Druid连接池工具类 */ public class JDBCUtils { // 定义成员变量-连接池对象DataSource private static DataSource dataSource; private JDBCUtils() {} // 通过静态代码块初始化连接池对象 static { try { // 加载配置文件 Properties properties = new Properties(); InputStream is = JDBCUtils.class.getClassLoader().getResourceAsStream("druid.properties"); BufferedReader br = new BufferedReader(new InputStreamReader(is)); properties.load(br); // 获取DataSource dataSource = DruidDataSourceFactory.createDataSource(properties); } catch (Exception e) { e.printStackTrace(); } } ​ / * 获取连接对象 * @return 连接对象 * @throws SQLException 异常 */ public static Connection getConnection() throws SQLException { return dataSource.getConnection(); } ​ / * 释放资源 * @param statement sql执行对象 * @param connection 连接对象 */ public static void close(Statement statement, Connection connection) { close(null, statement, connection); } ​ / * 释放资源 * @param resultSet 查询结果对象 * @param statement sql执行对象 * @param connection 连接对象 */ public static void close(ResultSet resultSet, Statement statement, Connection connection) { if (resultSet != null) { try { resultSet.close(); } catch (SQLException e) { e.printStackTrace(); } } if (statement != null) { try { statement.close(); } catch (SQLException e) { e.printStackTrace(); } } if (connection != null) { try { connection.close(); } catch (SQLException e) { e.printStackTrace(); } } } ​ / * 获取连接池对象 * @return 连接池对象 */ public static DataSource getDataSource() { return dataSource; } }

今天的文章
idea配置数据库连接池分享到此就结束了，感谢您的阅读。