如何从JDBC连接中获取max_allocated_packets从到MySQL的平滑DB连接

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

String url = "jdbc:mysql://localhost:3306/your_database_name";
String username = "your_username";
String password = "your_password";

try {
    Connection connection = DriverManager.getConnection(url, username, password);
    // 连接成功后的操作
} catch (SQLException e) {
    e.printStackTrace();
}

try {
    Statement statement = connection.createStatement();
    ResultSet resultSet = statement.executeQuery("SHOW VARIABLES LIKE 'max_allocated_packets'");
    if (resultSet.next()) {
        int maxAllocatedPackets = resultSet.getInt("Value");
        System.out.println("max_allocated_packets: " + maxAllocatedPackets);
    }
} catch (SQLException e) {
    e.printStackTrace();
}

try {
    if (resultSet != null) {
        resultSet.close();
    }
    if (statement != null) {
        statement.close();
    }
    if (connection != null) {
        connection.close();
    }
} catch (SQLException e) {
    e.printStackTrace();
}