ylrz_saas_pharmacy/java/scripts/VerifyLobsterAdminMenus.java

import java.sql.*;

public class VerifyLobsterAdminMenus {
    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"
                + "?useSSL=false&characterEncoding=utf8&serverTimezone=GMT%2B8";
        try (Connection c = DriverManager.getConnection(url, "root", "Ylrz_1q2w3e4r5t6y");
             Statement st = c.createStatement()) {
            System.out.println("=== sys_menu admin-only ===");
            try (ResultSet rs = st.executeQuery(
                    "SELECT menu_id, menu_name, HEX(menu_name) hx, path FROM sys_menu "
                            + "WHERE parent_id=29900 AND menu_id IN (29925,29963,29964,29951,29907,29908,29909) "
                            + "ORDER BY order_num")) {
                while (rs.next()) {
                    System.out.println(rs.getLong(1) + " | " + rs.getString(2) + " | "
                            + rs.getString(3) + " | " + rs.getString(4));
                }
            }
            try (ResultSet rs = st.executeQuery(
                    "SELECT COUNT(*) FROM sys_menu WHERE menu_id IN (29947,29938,29944,29936,29946)")) {
                rs.next();
                System.out.println("dropped in sys_menu=" + rs.getInt(1));
            }
            try (ResultSet rs = st.executeQuery(
                    "SELECT COUNT(*) FROM company_menu WHERE menu_id IN (29925,29951,29963,29964,29907,29908,29909)")) {
                rs.next();
                System.out.println("admin in company_menu=" + rs.getInt(1));
            }
        }
    }
}