mysql jdbc怎么设置编码

String url = "jdbc:mysql://localhost:3306/mydatabase?useUnicode=yes&characterEncoding=UTF-8";
String user = "username";
String password = "password";

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

HikariConfig config = new HikariConfig();
config.setJdbcUrl("jdbc:mysql://localhost:3306/mydatabase");
config.setUsername("username");
config.setPassword("password");
config.addDataSourceProperty("useUnicode", "yes");
config.addDataSourceProperty("characterEncoding", "UTF-8");

HikariDataSource dataSource = new HikariDataSource(config);

try (Connection conn = dataSource.getConnection()) {
    // 连接成功后的操作
} catch (SQLException e) {
    e.printStackTrace();
}