如何在MySQL中使用连接池来优化连接性能？

 mysql mysql-connector-java 8.0.23   com.zaxxer HikariCP 4.0.3 

# 数据库连接配置 spring.datasource.url=jdbc:mysql://localhost:3306/mydatabase spring.datasource.username=root spring.datasource.password=123456 # 连接池配置 spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver spring.datasource.hikari.maximum-pool-size=10 spring.datasource.hikari.minimum-idle=5 spring.datasource.hikari.idle-timeout=30000

import com.zaxxer.hikari.HikariDataSource; // 创建连接池对象 HikariDataSource dataSource = new HikariDataSource(); dataSource.setJdbcUrl("jdbc:mysql://localhost:3306/mydatabase"); dataSource.setUsername("root"); dataSource.setPassword("123456"); dataSource.setMaximumPoolSize(10); dataSource.setMinimumIdle(5); dataSource.setIdleTimeout(30000);

import java.sql.Connection; import java.sql.SQLException; // 获取连接对象 Connection connection = dataSource.getConnection();

import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; // 查询操作示例 String sql = "SELECT * FROM user"; try (PreparedStatement statement = connection.prepareStatement(sql); ResultSet resultSet = statement.executeQuery()) { while (resultSet.next()) { // 处理查询结果 int id = resultSet.getInt("id"); String name = resultSet.getString("name"); // ... } } catch (SQLException e) { // 异常处理 e.printStackTrace(); }

// 关闭连接对象 if (connection != null) { try { connection.close(); } catch (SQLException e) { e.printStackTrace(); } }