import java.sql.*;

public class QueryAdminMenus6 {
    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()) {
            String[] keys = {"\u540c\u6b65", "\u6a21\u677f", "\u5347\u7ea7", "\u5b57\u5178", "\u79df\u6237\u5e93"};
            for (String k : keys) {
                System.out.println("\n=== menu_name LIKE %" + k + "% (type C/M) ===");
                try (ResultSet rs = st.executeQuery(
                        "SELECT menu_id, menu_name, parent_id, path, component, icon FROM sys_menu "
                                + "WHERE menu_name LIKE '%" + k + "%' AND menu_type IN ('C','M') "
                                + "AND visible='0' ORDER BY menu_id")) {
                    while (rs.next()) {
                        System.out.printf("%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=== icons using el-icon- prefix (may not render in sidebar) ===");
            try (ResultSet rs = st.executeQuery(
                    "SELECT menu_id, menu_name, icon FROM sys_menu "
                            + "WHERE visible='0' AND status='0' AND menu_type IN ('C','M') "
                            + "AND icon LIKE 'el-icon-%' ORDER BY menu_id LIMIT 40")) {
                while (rs.next()) {
                    System.out.printf("%s | %s | icon=%s%n",
                            rs.getString(1), rs.getString(2), rs.getString(3));
                }
            }
        }
    }
}