如何使用jdbc驱动程序在java中正确执行`SET`查询

Class.forName("com.mysql.jdbc.Driver");

String url = "jdbc:mysql://localhost:3306/mydatabase";
String username = "root";
String password = "password";
Connection connection = DriverManager.getConnection(url, username, password);

Statement statement = connection.createStatement();

String setQuery = "SET NAMES 'utf8'";
int rowsAffected = statement.executeUpdate(setQuery);

String getQuery = "SHOW VARIABLES LIKE 'character_set_database'";
ResultSet resultSet = statement.executeQuery(getQuery);
while (resultSet.next()) {
    String variable = resultSet.getString("Variable_name");
    String value = resultSet.getString("Value");
    System.out.println(variable + ": " + value);
}

resultSet.close();
statement.close();
connection.close();