ylrz_saas_pharmacy/java/scripts/ProbeAllUsers.java

import java.sql.*;

public class ProbeAllUsers {
    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 db = args.length > 0 ? args[0] : "ylrz_saas_tenant_1";
        String jdbc = "jdbc:mysql://cq-cdb-8fjmemkb.sql.tencentcdb.com:27220/" + db
                + "?useSSL=false&serverTimezone=GMT%2B8";
        try (Connection c = DriverManager.getConnection(jdbc, USER, PWD);
             Statement st = c.createStatement();
             ResultSet rs = st.executeQuery(
                     "SELECT user_id, user_name, phonenumber, status, login_date FROM sys_user "
                             + "WHERE del_flag='0' ORDER BY login_date DESC LIMIT 15")) {
            System.out.println("=== sys_user in " + db + " ===");
            while (rs.next()) {
                System.out.println("id=" + rs.getLong(1) + "\tuser=" + rs.getString(2)
                        + "\tphone=" + rs.getString(3) + "\tstatus=" + rs.getString(4)
                        + "\tlastLogin=" + rs.getString(5));
            }
        }
    }
}