ylrz_saas_pharmacy/java/scripts/ScanGarbledMenus.java

import java.sql.*;

public class ScanGarbledMenus {
    public static void main(String[] args) throws Exception {
        String url = "jdbc:mysql://cq-cdb-8fjmemkb.sql.tencentcdb.com:27220/"
                + (args.length > 0 ? args[0] : "fs_tenant_cs1")
                + "?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8";
        try (Connection c = DriverManager.getConnection(url, "root", "Ylrz_1q2w3e4r5t6y");
             Statement s = c.createStatement()) {
            ResultSet rs = s.executeQuery(
                    "SELECT menu_id, menu_name, HEX(menu_name) hex FROM company_menu "
                            + "WHERE parent_id=29900 AND menu_id IN (32481,29949,29950)");
            while (rs.next()) {
                System.out.println(rs.getLong(1) + "\t" + rs.getString(2) + "\t" + rs.getString(3));
            }
            rs = s.executeQuery("SELECT menu_id, menu_name FROM company_menu WHERE menu_name LIKE 'u5de5%'");
            while (rs.next()) System.out.println("GARBLED " + rs.getLong(1) + " " + rs.getString(2));
            rs = s.executeQuery("SELECT menu_id, menu_name, path FROM company_menu WHERE parent_id=29900 AND visible='0' ORDER BY order_num LIMIT 5");
            while (rs.next()) System.out.println("VIS " + rs.getLong(1) + " " + rs.getString(2) + " " + rs.getString(3));
        }
    }
}