共享mysql数据库连接

// 示例代码：使用HikariCP连接池
HikariConfig config = new HikariConfig();
config.setJdbcUrl("jdbc:mysql://localhost:3306/mydb");
config.setUsername("user");
config.setPassword("password");
HikariDataSource dataSource = new HikariDataSource(config);

try (Connection conn = dataSource.getConnection();
     PreparedStatement stmt = conn.prepareStatement("SELECT * FROM mytable")) {
    ResultSet rs = stmt.executeQuery();
    // 处理结果集
} catch (SQLException e) {
    e.printStackTrace();
}

// 示例代码：配置HikariCP连接超时
HikariConfig config = new HikariConfig();
config.setConnectionTimeout(30000); // 30秒
config.setIdleTimeout(600000); // 10分钟
config.setMaxLifetime(1800000); // 30分钟

// 示例代码：使用Spring事务管理
@Transactional
public void updateUser(User user) {
    try (Connection conn = dataSource.getConnection();
         PreparedStatement stmt = conn.prepareStatement("UPDATE users SET name = ? WHERE id = ?")) {
        stmt.setString(1, user.getName());
        stmt.setInt(2, user.getId());
        stmt.executeUpdate();
    } catch (SQLException e) {
        e.printStackTrace();
    }
}