ylrz_saas_pharmacy/java/scripts/CheckTables.java

import java.sql.*;
public class CheckTables {
  static final String URL = "jdbc:mysql://cq-cdb-8fjmemkb.sql.tencentcdb.com:27220/ylrz_saas?useSSL=false&serverTimezone=GMT%2B8";
  static final String USER = "root", PWD = "Ylrz_1q2w3e4r5t6y";
  public static void main(String[] a) throws Exception {
    try (Connection c = DriverManager.getConnection(URL, USER, PWD); Statement st = c.createStatement()) {
      for (String t : new String[]{"lobster_execution_config","company_lobster_tag_user_rel","lobster_e2e_run","lobster_test_scenario"}) {
        try (ResultSet rs = st.executeQuery("SELECT COUNT(*) FROM information_schema.TABLES WHERE TABLE_SCHEMA='ylrz_saas' AND TABLE_NAME='"+t+"'")) { rs.next(); System.out.println(t+": "+(rs.getInt(1)>0?"OK":"MISSING")); }
      }
    }
  }
}