springmvc mysql断线重连

jdbc:mysql://localhost:3306/mydatabase?autoReconnect=true&failOverReadOnly=false

@Controller
public class MyController {

    @Autowired
    private DataSource dataSource;

    @RequestMapping("/test")
    public String test() {
        Connection conn = null;
        try {
            conn = dataSource.getConnection();
            // 执行数据库操作
        } catch (SQLException e) {
            if (isCommunicationsException(e)) {
                // 尝试重新建立连接
                conn = retryGetConnection();
            }
            // 处理其他类型的异常
        } finally {
            if (conn != null) {
                try {
                    conn.close();
                } catch (SQLException e) {
                    // 忽略关闭连接时的异常
                }
            }
        }
        return "success";
    }

    private boolean isCommunicationsException(SQLException e) {
        return "08S01".equals(e.getSQLState()) || "通信链路故障".equals(e.getMessage());
    }

    private Connection retryGetConnection() {
        int retryCount = 3;
        while (retryCount > 0) {
            try {
                return dataSource.getConnection();
            } catch (SQLException e) {
                retryCount--;
                if (retryCount == 0) {
                    throw new RuntimeException("无法重新建立数据库连接", e);
                }
                try {
                    Thread.sleep(1000); // 等待一秒后重试
                } catch (InterruptedException ie) {
                    Thread.currentThread().interrupt();
                }
            }
        }
        return null; // 实际上不会执行到这里
    }
}