ylrz_saas_pharmacy/java/tmp/CheckDup2.java

import java.sql.*;

public class CheckDup2 {
    static final String U = "root"; static final String P = "Ylrz_1q2w3e4r5t6y";

    public static void main(String[] a) throws Exception {
        Class.forName("com.mysql.cj.jdbc.Driver");
        String url = "jdbc:mysql://cq-cdb-8fjmemkb.sql.tencentcdb.com:27220/fs_tenant_cs1?serverTimezone=Asia/Shanghai";

        try (Connection c = DriverManager.getConnection(url, U, P); Statement s = c.createStatement()) {
            // Check if sys_menu has lobster entries (cs1 should NOT have them if it's company-only)
            System.out.println("=== sys_menu lobster count ===");
            ResultSet r = s.executeQuery("SELECT COUNT(1) FROM sys_menu WHERE menu_id BETWEEN 29900 AND 29999");
            r.next(); System.out.println("sys_menu: " + r.getInt(1));

            System.out.println("\n=== company_menu lobster count ===");
            r = s.executeQuery("SELECT COUNT(1) FROM company_menu WHERE menu_id BETWEEN 29900 AND 29999");
            r.next(); System.out.println("company_menu: " + r.getInt(1));

            // Check sys_role_menu for lobster
            System.out.println("\n=== sys_role_menu lobster entries ===");
            r = s.executeQuery("SELECT COUNT(1) FROM sys_role_menu WHERE menu_id BETWEEN 29900 AND 29999");
            r.next(); System.out.println("sys_role_menu: " + r.getInt(1));

            // Check company_role_menu for lobster
            System.out.println("=== company_role_menu lobster entries ===");
            r = s.executeQuery("SELECT COUNT(1) FROM company_role_menu WHERE menu_id BETWEEN 29900 AND 29999");
            r.next(); System.out.println("company_role_menu: " + r.getInt(1));

            // Check roles
            System.out.println("\n=== Roles with lobster permissions ===");
            r = s.executeQuery("SELECT DISTINCT role_id FROM sys_role_menu WHERE menu_id BETWEEN 29900 AND 29999 UNION SELECT DISTINCT role_id FROM company_role_menu WHERE menu_id BETWEEN 29900 AND 29999");
            while (r.next()) System.out.println("  role_id=" + r.getInt(1));

            // Check if menu 29937 (Token消耗统计) exists in both
            System.out.println("\n=== 29937 (Token消耗统计) check ===");
            r = s.executeQuery("SELECT 'sys_menu' AS src, menu_name, visible FROM sys_menu WHERE menu_id=29937 UNION ALL SELECT 'company_menu', menu_name, visible FROM company_menu WHERE menu_id=29937");
            while (r.next()) System.out.println("  " + r.getString(1)+": "+r.getString(2)+" vis="+r.getString(3));

            // Check role_menu for 29937
            r = s.executeQuery("SELECT 'sys_role' AS src, role_id FROM sys_role_menu WHERE menu_id=29937 UNION ALL SELECT 'company_role', role_id FROM company_role_menu WHERE menu_id=29937");
            while (r.next()) System.out.println("  " + r.getString(1)+" role="+r.getString(2));
        }
    }
}