ylrz_saas_pharmacy/java/scripts/FindTenantId.java

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class FindTenantId {
    private static final String URL = "jdbc:mysql://cq-cdb-8fjmemkb.sql.tencentcdb.com:27220/ylrz_saas?useSSL=false&serverTimezone=GMT%2B8";
    private static final String USER = "root";
    private static final String PWD = "Ylrz_1q2w3e4r5t6y";

    public static void main(String[] args) throws Exception {
        try (Connection c = DriverManager.getConnection(URL, USER, PWD);
             Statement st = c.createStatement()) {
            String q = "SELECT id, tenant_name, db_url, status FROM tenant_info ORDER BY id";
            try (ResultSet rs = st.executeQuery(q)) {
                while (rs.next()) {
                    System.out.println(rs.getLong("id") + "\t" + rs.getString("tenant_name") + "\t"
                            + rs.getString("db_url") + "\tstatus=" + rs.getInt("status"));
                }
            } catch (Exception e) {
                System.out.println("tenant_info failed: " + e.getMessage());
                try (ResultSet rs = st.executeQuery("SHOW TABLES LIKE '%tenant%'")) {
                    while (rs.next()) System.out.println("table: " + rs.getString(1));
                }
            }
        }
    }
}