ylrz_saas_pharmacy/java/scripts/WriteMenuNameReport.java

import java.nio.charset.StandardCharsets;
import java.nio.file.*;
import java.sql.*;
public class WriteMenuNameReport {
  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&useUnicode=true&characterEncoding=UTF-8&serverTimezone=GMT%2B8";
    StringBuilder sb = new StringBuilder();
    try (Connection c = DriverManager.getConnection(url, "root", "Ylrz_1q2w3e4r5t6y"); Statement st = c.createStatement();
         ResultSet rs = st.executeQuery("SELECT menu_id, menu_name, path FROM sys_menu WHERE menu_id IN (29925,29963,29964,29951,29907,29908,29909) ORDER BY order_num")) {
      while (rs.next()) sb.append(rs.getLong(1)).append(" | ").append(rs.getString(2)).append(" | ").append(rs.getString(3)).append("\n");
    }
    url = url.replace("fs_tenant_cs1", "ylrz_saas");
    try (Connection c = DriverManager.getConnection(url, "root", "Ylrz_1q2w3e4r5t6y"); Statement st = c.createStatement();
         ResultSet rs = st.executeQuery("SELECT menu_id, menu_name, path FROM tenant_sys_menu WHERE menu_id IN (29925,29963,29964,29951,29907,29908,29909) ORDER BY order_num")) {
      sb.append("\n--- master tenant_sys_menu ---\n");
      while (rs.next()) sb.append(rs.getLong(1)).append(" | ").append(rs.getString(2)).append(" | ").append(rs.getString(3)).append("\n");
    }
    Files.write(Path.of("output/fix-sys-only-menu-names-report.txt"), sb.toString().getBytes(StandardCharsets.UTF_8));
    System.out.println(sb);
  }
}