import java.io.*;
import java.sql.*;

public class Verify {
    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";
        PrintWriter out = new PrintWriter(new OutputStreamWriter(
                new FileOutputStream("d:/ylrz_saas_new/java/logs/lobster-menu-verify.txt"), "UTF-8"));
        try (Connection c = DriverManager.getConnection(url, "root", "Ylrz_1q2w3e4r5t6y");
             Statement s = c.createStatement()) {
            out.println("=== sys_menu ===");
            ResultSet rs = s.executeQuery(
                    "SELECT menu_id, menu_name, order_num, path FROM sys_menu "
                            + "WHERE parent_id=29900 AND visible='0' AND menu_type='C' ORDER BY order_num");
            while (rs.next()) {
                out.printf("%d\t%s\t%s%n", rs.getLong(1), rs.getString(2), rs.getString(4));
            }
            out.println("\n=== company_menu (338 or NULL) ===");
            rs = s.executeQuery(
                    "SELECT menu_id, menu_name, order_num, company_id FROM company_menu "
                            + "WHERE parent_id=29900 AND visible='0' AND menu_type='C' "
                            + "AND (company_id=338 OR company_id IS NULL) ORDER BY order_num");
            while (rs.next()) {
                out.printf("%d\t%s\tord=%d\tco=%s%n",
                        rs.getLong(1), rs.getString(2), rs.getInt(3), rs.getString(4));
            }
        }
        out.close();
        System.out.println("written logs/lobster-menu-verify.txt");
    }
}