ylrz_saas_pharmacy/java/scripts/QueryAdminMenus9.java

import java.sql.*;
import java.nio.file.*;
import java.util.*;

public class QueryAdminMenus9 {
    public static void main(String[] args) throws Exception {
        String url = "jdbc:mysql://cq-cdb-8fjmemkb.sql.tencentcdb.com:27220/ylrz_saas?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8";
        try (Connection c = DriverManager.getConnection(url, "root", "Ylrz_1q2w3e4r5t6y");
             Statement st = c.createStatement()) {

            System.out.println("=== menus with tenantUpgrade or upgrade in path/component ===");
            try (ResultSet rs = st.executeQuery(
                    "SELECT menu_id, menu_name, parent_id, path, component, menu_type, icon, visible "
                            + "FROM sys_menu WHERE path LIKE '%tenantUpgrade%' OR path LIKE '%upgrade%' "
                            + "OR component LIKE '%tenant/upgrade%' "
                            + "ORDER BY menu_id")) {
                while (rs.next()) {
                    System.out.printf("%s | %s | parent=%s | path=%s | comp=%s | type=%s | icon=%s | vis=%s%n",
                            rs.getString(1), rs.getString(2), rs.getString(3), rs.getString(4),
                            rs.getString(5), rs.getString(6), rs.getString(7), rs.getString(8));
                }
            }

            System.out.println("\n=== duplicate menu_name under same parent (type C/M visible) ===");
            try (ResultSet rs = st.executeQuery(
                    "SELECT parent_id, menu_name, COUNT(*) cnt, GROUP_CONCAT(menu_id) ids "
                            + "FROM sys_menu WHERE menu_type IN ('C','M') AND visible='0' AND status='0' "
                            + "GROUP BY parent_id, menu_name HAVING cnt > 1 ORDER BY parent_id")) {
                while (rs.next()) {
                    System.out.printf("parent=%s name=%s cnt=%s ids=%s%n",
                            rs.getString(1), rs.getString(2), rs.getString(3), rs.getString(4));
                }
            }

            System.out.println("\n=== menus with empty/null icon (visible C/M) ===");
            try (ResultSet rs = st.executeQuery(
                    "SELECT menu_id, menu_name, parent_id, path, component, icon "
                            + "FROM sys_menu WHERE menu_type IN ('C','M') AND visible='0' AND status='0' "
                            + "AND (icon IS NULL OR icon='' OR icon='#') ORDER BY menu_id")) {
                while (rs.next()) {
                    System.out.printf("NO_ICON %s | %s | parent=%s | path=%s | comp=%s | icon=[%s]%n",
                            rs.getString(1), rs.getString(2), rs.getString(3),
                            rs.getString(4), rs.getString(5), rs.getString(6));
                }
            }

            System.out.println("\n=== children of 32850 ===");
            try (ResultSet rs = st.executeQuery(
                    "SELECT menu_id, menu_name, menu_type, path, component, visible FROM sys_menu WHERE parent_id=32850")) {
                while (rs.next()) {
                    System.out.printf("%s | %s | type=%s | path=%s | comp=%s | vis=%s%n",
                            rs.getString(1), rs.getString(2), rs.getString(3),
                            rs.getString(4), rs.getString(5), rs.getString(6));
                }
            }

            System.out.println("\n=== shezhi(2820) children ===");
            try (ResultSet rs = st.executeQuery(
                    "SELECT menu_id, menu_name, path, component, menu_type, icon FROM sys_menu "
                            + "WHERE parent_id=2820 AND visible='0' AND status='0' ORDER BY order_num")) {
                while (rs.next()) {
                    System.out.printf("%s | %s | path=%s | comp=%s | type=%s | icon=%s%n",
                            rs.getString(1), rs.getString(2), rs.getString(3),
                            rs.getString(4), rs.getString(5), rs.getString(6));
                }
            }
        }
    }
}