java让mysql存入表情

ALTER DATABASE database_name CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
ALTER TABLE table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE table_name MODIFY column_name VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

jdbc:mysql://localhost:3306/database_name?useUnicode=yes&characterEncoding=UTF-8&useSSL=false&serverTimezone=UTC&characterSetResults=utf8mb4

System.setProperty("file.encoding", "UTF-8");

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class EmojiExample {
    public static void main(String[] args) {
        String url = "jdbc:mysql://localhost:3306/database_name?useUnicode=yes&characterEncoding=UTF-8&useSSL=false&serverTimezone=UTC&characterSetResults=utf8mb4";
        String user = "username";
        String password = "password";

        try (Connection conn = DriverManager.getConnection(url, user, password)) {
            String sql = "INSERT INTO table_name (column_name) VALUES (?)";
            try (PreparedStatement pstmt = conn.prepareStatement(sql)) {
                pstmt.setString(1, "😊");
                pstmt.executeUpdate();
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}