java mysql自动断连

// 示例代码：定期发送心跳包
public void keepConnectionAlive(Connection conn) throws SQLException {
    Statement stmt = conn.createStatement();
    stmt.executeQuery("SELECT 1");
    stmt.close();
}

# 示例配置：调整连接池参数
spring.datasource.hikari.maximum-pool-size=50
spring.datasource.hikari.connection-timeout=30000

// 示例代码：使用HikariCP连接池的自动重连功能
HikariConfig config = new HikariConfig();
config.setJdbcUrl("jdbc:mysql://localhost:3306/mydb");
config.setUsername("user");
config.setPassword("password");
config.addDataSourceProperty("cachePrepStmts", "true");
config.addDataSourceProperty("prepStmtCacheSize", "250");
config.addDataSourceProperty("prepStmtCacheSqlLimit", "2048");
config.setConnectionTimeout(30000);
config.setIdleTimeout(600000);
config.setMaxLifetime(1800000);
config.setMaximumPoolSize(50);
HikariDataSource ds = new HikariDataSource(config);