import java.sql.*;
public class InspectExisting {
  public static void main(String[] args) throws Exception {
    try (Connection c = DriverManager.getConnection("jdbc:mysql://127.0.0.1:8134/talent_card?useSSL=false&allowPublicKeyRetrieval=true", "root", "123456")) {
      c.setReadOnly(true);
      String sql = "select a.id,a.merchant_id,a.store_id,a.application_no,a.status,a.subject_type,a.provider_huifu_id,a.provider_apply_no,a.provider_response_code,a.provider_response_message,a.wechat_config_status,a.wechat_config_request_no,a.wechat_config_response_code,a.wechat_config_response_message,a.business_open_status,a.business_open_request_no,a.business_open_apply_no,a.business_open_response_code,a.business_open_response_message,a.initial_bank_card_id,a.created_at,b.status as card_status,b.card_tail,m.merchant_type from merchant_onboarding_application a left join merchant_bank_card b on b.id=a.initial_bank_card_id left join merchant m on m.id=a.merchant_id where a.provider_huifu_id='6666000241335656'";
      try (ResultSet r=c.createStatement().executeQuery(sql)) { while(r.next()) for(int i=1;i<=r.getMetaData().getColumnCount();i++) System.out.println(r.getMetaData().getColumnLabel(i)+"="+r.getString(i)); }
    }
  }
}