java连接mysql 字符集

String url = "jdbc:mysql://localhost:3306/mydatabase?useUnicode=yes&characterEncoding=UTF-8";
Connection conn = DriverManager.getConnection(url, "username", "password");

Properties props = new Properties();
props.setProperty("user", "username");
props.setProperty("password", "password");
props.setProperty("useUnicode", "yes");
props.setProperty("characterEncoding", "UTF-8");

String url = "jdbc:mysql://localhost:3306/mydatabase";
Connection conn = DriverManager.getConnection(url, props);

[client]
default-character-set=UTF-8

[mysql]
default-character-set=UTF-8

[mysqld]
character-set-server=UTF-8
collation-server=UTF-8_general_ci

ALTER TABLE mytable CONVERT TO CHARACTER SET UTF-8 COLLATE UTF8_general_ci;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;

public class MySQLConnectionExample {
    public static void main(String[] args) {
        String url = "jdbc:mysql://localhost:3306/mydatabase?useUnicode=yes&characterEncoding=UTF-8";
        Properties props = new Properties();
        props.setProperty("user", "username");
        props.setProperty("password", "password");

        try (Connection conn = DriverManager.getConnection(url, props)) {
            System.out.println("Connected to the database!");
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}