ylrz_saas_pharmacy/java/scripts/VerifyMenus.java

import java.sql.*;
public class VerifyMenus {
  public static void main(String[] a) throws Exception {
    Class.forName("com.mysql.cj.jdbc.Driver");
    String u="jdbc:mysql://cq-cdb-8fjmemkb.sql.tencentcdb.com:27220/fs_tenant_cs1?useSSL=false&characterEncoding=utf8&serverTimezone=GMT%2B8";
    try (Connection c=DriverManager.getConnection(u,"root","Ylrz_1q2w3e4r5t6y"); Statement s=c.createStatement();
         ResultSet r=s.executeQuery("SELECT menu_id, menu_name, order_num, path FROM company_menu WHERE parent_id=29900 AND visible='0' AND menu_type='C' ORDER BY order_num")) {
      while(r.next()) System.out.println(r.getInt(1)+"\t"+r.getString(2)+"\t"+r.getString(4));
    }
  }
}