ylrz_saas_pharmacy/java/scripts/CheckBindingTable.java

import java.sql.*;

public class CheckBindingTable {
    public static void main(String[] a) throws Exception {
        String host = "cq-cdb-8fjmemkb.sql.tencentcdb.com:27220";
        String user = "root";
        String pwd = "Ylrz_1q2w3e4r5t6y";
        for (String db : new String[]{"fs_tenant_cs1", "ylrz_saas_tenant_1", "ylrz_saas"}) {
            String url = "jdbc:mysql://" + host + "/" + db + "?useSSL=false&serverTimezone=GMT%2B8";
            try (Connection c = DriverManager.getConnection(url, user, pwd)) {
                try (ResultSet rs = c.createStatement().executeQuery(
                        "SELECT COUNT(*) FROM information_schema.TABLES WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='company_tag_template_binding'")) {
                    rs.next();
                    System.out.println(db + " has company_tag_template_binding: " + (rs.getInt(1) > 0));
                }
            }
        }
    }
}