ylrz_saas_pharmacy/java/scripts/ProbeLoginUser.java

import java.sql.*;

public class ProbeLoginUser {
    private static final String USER = "root";
    private static final String PWD = "Ylrz_1q2w3e4r5t6y";

    public static void main(String[] args) throws Exception {
        Class.forName("com.mysql.cj.jdbc.Driver");
        String[] dbs = {"ylrz_saas_tenant_1", "fs_tenant_cs1"};
        for (String db : dbs) {
            String jdbc = "jdbc:mysql://cq-cdb-8fjmemkb.sql.tencentcdb.com:27220/" + db
                    + "?useSSL=false&serverTimezone=GMT%2B8";
            System.out.println("\n=== " + db + " ===");
            try (Connection c = DriverManager.getConnection(jdbc, USER, PWD);
                 Statement st = c.createStatement()) {
                try (ResultSet rs = st.executeQuery(
                        "SELECT user_id, user_name, password, company_id, status FROM sys_user WHERE del_flag='0' LIMIT 5")) {
                    while (rs.next()) {
                        String pw = rs.getString("password");
                        System.out.println("user=" + rs.getString("user_name")
                                + " company=" + rs.getObject("company_id")
                                + " status=" + rs.getString("status")
                                + " pw=" + (pw == null ? "null" : pw.substring(0, Math.min(20, pw.length())) + "..."));
                    }
                }
                try (ResultSet rs = st.executeQuery(
                        "SELECT user_id, user_name, password, status FROM company_user WHERE del_flag='0' AND user_name='admin' LIMIT 3")) {
                    while (rs.next()) {
                        String pw = rs.getString("password");
                        System.out.println("company_user admin pw="
                                + (pw == null ? "null" : pw.substring(0, Math.min(20, pw.length())) + "..."));
                    }
                } catch (Exception ignored) {
                }
            }
        }
        try (Connection c = DriverManager.getConnection(
                "jdbc:mysql://cq-cdb-8fjmemkb.sql.tencentcdb.com:27220/ylrz_saas?useSSL=false&serverTimezone=GMT%2B8",
                USER, PWD);
             Statement st = c.createStatement()) {
            System.out.println("\n=== tenant_info for test001/cs1 ===");
            try (ResultSet rs = st.executeQuery(
                    "SELECT tenant_code, db_name FROM tenant_info WHERE tenant_code IN ('test001','cs1')")) {
                while (rs.next()) {
                    System.out.println(rs.getString("tenant_code") + " -> " + rs.getString("db_name"));
                }
            }
        }
    }
}