import java.sql.*;

public class QSysMenu {
    public static void main(String[] a) throws Exception {
        String url = "jdbc:mysql://cq-cdb-8fjmemkb.sql.tencentcdb.com:27220/fs_tenant_cs1?useSSL=false&serverTimezone=GMT%2B8&characterEncoding=utf8";
        try (Connection c = DriverManager.getConnection(url, "root", "Ylrz_1q2w3e4r5t6y");
             Statement s = c.createStatement()) {
            System.out.println("=== fs_tenant_cs1.sys_menu lobster ===");
            ResultSet rs = s.executeQuery(
                    "SELECT menu_id, menu_name, parent_id, order_num, path, component, visible, status "
                            + "FROM sys_menu WHERE menu_id=29900 OR parent_id=29900 OR parent_id=29901 "
                            + "ORDER BY parent_id, order_num, menu_id");
            while (rs.next()) {
                System.out.printf("%d | %s | pid=%d ord=%d | %s | %s | vis=%s st=%s%n",
                        rs.getLong(1), rs.getString(2), rs.getLong(3), rs.getInt(4),
                        rs.getString(5), rs.getString(6), rs.getString(7), rs.getString(8));
            }
            rs = s.executeQuery(
                    "SELECT COUNT(*) FROM sys_menu WHERE parent_id=29900 AND menu_type='C' AND visible='0' AND status='0'");
            rs.next();
            System.out.println("visible leaf under 29900: " + rs.getInt(1));
        }
    }
}