import java.sql.*;

/** 只读：读指定进件记录里实名认证可能用得到的字段。 */
public class InspectRealnameInputs {
  public static void main(String[] args) throws Exception {
    String applicationNo = args.length > 0 ? args[0] : "MO202609141804572521";
    try (Connection c = DriverManager.getConnection(
        "jdbc:mysql://127.0.0.1:8134/talent_card?useSSL=false&allowPublicKeyRetrieval=true", "root", "123456")) {
      c.setReadOnly(true);
      try (ResultSet r = c.createStatement().executeQuery(
          "select * from merchant_onboarding_application where application_no='" + applicationNo + "'")) {
        ResultSetMetaData meta = r.getMetaData();
        while (r.next()) {
          for (int i = 1; i <= meta.getColumnCount(); i++) {
            String label = meta.getColumnLabel(i);
            String value = r.getString(i);
            if (value != null && !value.isBlank()) System.out.println(label + "=" + value);
          }
        }
      }
      System.out.println("=== merchant 侧 ===");
      try (ResultSet r = c.createStatement().executeQuery(
          "select m.* from merchant m join merchant_onboarding_application a on a.merchant_id=m.id"
              + " where a.application_no='" + applicationNo + "'")) {
        ResultSetMetaData meta = r.getMetaData();
        while (r.next()) {
          for (int i = 1; i <= meta.getColumnCount(); i++) {
            String label = meta.getColumnLabel(i);
            String value = r.getString(i);
            if (value != null && !value.isBlank() && !value.startsWith("MII")) System.out.println(label + "=" + value);
          }
        }
      }
    }
  }
}