import java.sql.*;

public class ListLobster {
    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_company_menu (saas-companyui) ==========");
            print(stmt, "SELECT menu_id, menu_name, component, CASE visible WHEN '0' THEN 'SHOW' ELSE 'HIDE' END AS vis FROM tenant_company_menu WHERE menu_id BETWEEN 29900 AND 29999 AND menu_type IN ('M','C') ORDER BY order_num, menu_id");

            System.out.println("\n========== tenant_sys_menu (saas-mgnui) ==========");
            print(stmt, "SELECT menu_id, menu_name, component, CASE visible WHEN '0' THEN 'SHOW' ELSE 'HIDE' END AS vis FROM tenant_sys_menu WHERE menu_id BETWEEN 29900 AND 29999 AND menu_type IN ('M','C') ORDER BY order_num, menu_id");
        }
    }
    static void print(Statement s, String sql) throws SQLException {
        try (ResultSet rs = s.executeQuery(sql)) {
            System.out.printf("%-8s %-20s %-50s %s\n", "ID","Name","Component","Vis");
            System.out.println("-------- -------------------- -------------------------------------------------- ----");
            while (rs.next()) {
                System.out.printf("%-8s %-20s %-50s %s\n",
                    rs.getString(1), rs.getString(2), nvl(rs.getString(3)), rs.getString(4));
            }
        }
    }
    static String nvl(String s) { return s==null||s.isEmpty()?"(Dir)":s; }
}