ylrz_saas_pharmacy/java/scripts/QueryAdminMenus7.java

import java.sql.*;

public class QueryAdminMenus7 {
    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("=== ALL under parent 2864 (any visible) ===");
            try (ResultSet rs = st.executeQuery(
                    "SELECT menu_id, menu_name, path, component, icon, visible, menu_type, order_num "
                            + "FROM sys_menu WHERE parent_id=2864 ORDER BY order_num, menu_id")) {
                while (rs.next()) {
                    System.out.printf("%s | %s | path=%s | comp=%s | icon=%s | vis=%s | type=%s | ord=%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=== menus with icon share or warning ===");
            try (ResultSet rs = st.executeQuery(
                    "SELECT menu_id, menu_name, icon, component FROM sys_menu "
                            + "WHERE icon IN ('share','warning') AND visible='0'")) {
                while (rs.next()) {
                    System.out.printf("%s | %s | icon=%s | comp=%s%n",
                            rs.getString(1), rs.getString(2), rs.getString(3), rs.getString(4));
                }
            }
            System.out.println("\n=== duplicate 32850 id conflict check tenant_sys_menu ===");
            try (ResultSet rs = st.executeQuery(
                    "SELECT menu_id, menu_name, path, component FROM tenant_sys_menu WHERE menu_id=32850")) {
                while (rs.next()) {
                    System.out.printf("tenant_sys_menu %s | %s | path=%s | comp=%s%n",
                            rs.getString(1), rs.getString(2), rs.getString(3), rs.getString(4));
                }
            }
        }
    }
}