import java.sql.*;

public class ListMenus {
    static final String URL = "jdbc:mysql://cq-cdb-8fjmemkb.sql.tencentcdb.com:27220/ylrz_saas?useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai&useSSL=false";
    static final String USER = "root";
    static final String PASS = "Ylrz_1q2w3e4r5t6y";

    public static void main(String[] args) throws Exception {
        Class.forName("com.mysql.cj.jdbc.Driver");
        try (Connection conn = DriverManager.getConnection(URL, USER, PASS);
             Statement stmt = conn.createStatement()) {

            System.out.println("========== tenant_sys_menu (mgnui: admin end) ==========");
            String sql = "SELECT menu_id, menu_name, component, visible, " +
                "CASE WHEN menu_type='M' THEN 'Dir' WHEN menu_type='C' THEN 'Page' ELSE menu_type END AS tp " +
                "FROM tenant_sys_menu WHERE parent_id=29900 ORDER BY order_num, menu_id";
            dump(stmt, sql);

            System.out.println("\n========== tenant_company_menu (companyui: tenant end) ==========");
            sql = "SELECT menu_id, menu_name, component, visible, " +
                "CASE WHEN menu_type='M' THEN 'Dir' WHEN menu_type='C' THEN 'Page' ELSE menu_type END AS tp " +
                "FROM tenant_company_menu WHERE parent_id=29900 ORDER BY order_num, menu_id";
            dump(stmt, sql);
        }
    }
    static void dump(Statement s, String sql) throws SQLException {
        try (ResultSet rs = s.executeQuery(sql)) {
            System.out.printf("%-6s %-20s %-45s %-6s %s\n", "ID", "Name", "Component", "Vis", "Type");
            System.out.println("------ -------------------- --------------------------------------------- ------ ----");
            while (rs.next()) {
                String vis = "0".equals(rs.getString("visible")) ? "show" : "HIDE";
                System.out.printf("%-6s %-20s %-45s %-6s %s\n",
                    rs.getString("menu_id"),
                    rs.getString("menu_name"),
                    nvl(rs.getString("component")),
                    vis,
                    rs.getString("tp"));
            }
        }
    }
    static String nvl(String s) { return s==null||s.isEmpty()?"(Dir)":s; }
}