ylrz_saas_pharmacy/java/tmp/CheckNewMenus.java

import java.sql.*;

public class CheckNewMenus {
    static final String URL = "jdbc:mysql://cq-cdb-8fjmemkb.sql.tencentcdb.com:27220/ylrz_saas?useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai&useSSL=false";
    static final String USER = "root";
    static final String PASS = "Ylrz_1q2w3e4r5t6y";

    public static void main(String[] args) throws Exception {
        Class.forName("com.mysql.cj.jdbc.Driver");
        try (Connection conn = DriverManager.getConnection(URL, USER, PASS);
             Statement stmt = conn.createStatement()) {

            // Check master templates
            System.out.println("=== MASTER tenant_company_menu ===");
            check(stmt, "tenant_company_menu", 29941, 29950);

            System.out.println("\n=== TOP 3 tenent DBs ===");
            int n=0;
            ResultSet rs = stmt.executeQuery("SHOW DATABASES LIKE 'fs_tenant_%'");
            while (rs.next() && n<3) {
                String db = rs.getString(1);
                System.out.println("\n" + db + ":");
                try { check(stmt, db+".sys_menu", 29941, 29950); } catch (Exception e) {}
                try { check(stmt, db+".company_menu", 29941, 29950); } catch (Exception e) { System.out.println("  company_menu: client menu"); }
                n++;
            }
        }
    }

    static void check(Statement stmt, String table, int... ids) throws SQLException {
        System.out.print("  " + table + ":");
        for (int id : ids) {
            ResultSet rs = stmt.executeQuery("SELECT menu_id, menu_name FROM "+table+" WHERE menu_id="+id);
            if (rs.next()) System.out.print(" " + rs.getString(1)+"("+rs.getString(2)+")");
            else System.out.print(" ["+id+" MISSING]");
            rs.close();
        }
        System.out.println();
    }
}