ylrz_saas_pharmacy/java/scripts/ApplyIdentityConfigMenu.java

import java.nio.charset.StandardCharsets;
import java.nio.file.Files;
import java.nio.file.Path;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.Statement;

public class ApplyIdentityConfigMenu {
    public static void main(String[] args) throws Exception {
        Class.forName("com.mysql.cj.jdbc.Driver");
        String db = args.length > 0 ? args[0] : "fs_tenant_cs1";
        Path sqlPath = Path.of("d:/ylrz_saas_new/java/fs-agent/src/main/resources/db/migration/tenant/V20260723_02__lobster_add_identity_config_menu.sql");
        byte[] bytes = Files.readAllBytes(sqlPath);
        String sql = new String(bytes, StandardCharsets.UTF_8);
        if (!sql.isEmpty() && sql.charAt(0) == '\uFEFF') {
            sql = sql.substring(1);
        }
        String url = "jdbc:mysql://cq-cdb-8fjmemkb.sql.tencentcdb.com:27220/" + db
                + "?useSSL=false&characterEncoding=utf8&serverTimezone=GMT%2B8&allowMultiQueries=true";
        String name = "\u5bf9\u5916\u89d2\u8272\u914d\u7f6e";
        try (Connection c = DriverManager.getConnection(url, "root", "Ylrz_1q2w3e4r5t6y");
             Statement st = c.createStatement()) {
            st.execute(sql);
            try (PreparedStatement ps1 = c.prepareStatement("UPDATE sys_menu SET menu_name=? WHERE menu_id=29934");
                 PreparedStatement ps2 = c.prepareStatement("UPDATE company_menu SET menu_name=? WHERE menu_id=29934")) {
                ps1.setString(1, name);
                ps1.executeUpdate();
                ps2.setString(1, name);
                ps2.executeUpdate();
            }
            System.out.println("Added menu 29934 (" + name + ") to " + db);
        }
    }
}