ylrz_saas_pharmacy/java/scripts/FindTenantManageMenu.java

import java.sql.*;

public class FindTenantManageMenu {
    static final String URL = "jdbc:mysql://cq-cdb-8fjmemkb.sql.tencentcdb.com:27220/fs_tenant_cs1?useSSL=false&serverTimezone=GMT%2B8";
    public static void main(String[] args) throws Exception {
        Class.forName("com.mysql.cj.jdbc.Driver");
        try (Connection c = DriverManager.getConnection(URL, "root", "Ylrz_1q2w3e4r5t6y")) {
            try (Statement st = c.createStatement();
                 ResultSet rs = st.executeQuery(
                         "SELECT menu_id, parent_id, menu_name, path, component, visible, status "
                                 + "FROM sys_menu WHERE menu_name LIKE '%租户%' OR path LIKE '%tenant%' OR menu_name LIKE '%管理%' ORDER BY menu_id LIMIT 80")) {
                while (rs.next()) {
                    System.out.printf("id=%d p=%d vis=%s name=%s path=%s comp=%s%n",
                            rs.getLong(1), rs.getLong(2), rs.getString(6),
                            rs.getString(3), rs.getString(4), rs.getString(5));
                }
            }
        }
    }
}