mybatis 里面的collection嵌套两层后，如果里面那层有两条数据，最后返回的是两个json字符串，目标是想得到1个json字符串。把类型改为List也不行，有没有大佬教一教我呀。
domain层：
public class Alltest extends BaseEntity {
private static final long serialVersionUID = 1L;
private List<Treatmentinfo> treatmentinfoList;
private List<Treatmentpciinfo> treatmentpciinfoList;
private List<Outcomeinfo> outcomeinfoList;
private List<Registerinfo> registerinfoList;
private List<Firstaidinfo> firstaidinfoList;
其他的几个嵌套就是在另外的class里面再嵌套一个List，代码太长就不展示了
因为全部数据太长了，我删除了中间的一些字段，保留前后数据和collection。
<resultMap id="AlltestResult" type="com.ruoyi.alltest.domain.Alltest">
<collection property="registerinfoList" javaType="java.util.List" resultMap="RegisterinfoResult"/>
<collection property="firstaidinfoList" javaType="java.util.List" resultMap="FirstaidinfoResult"/>
<collection property="outcomeinfoList" javaType="java.util.List" resultMap="OutcomeinfoResult"/>
<collection property="treatmentinfoList" javaType="java.util.List" resultMap="TreatmentinfoResult"/>
<collection property="treatmentpciinfoList" javaType="java.util.List" resultMap="TreatmentpciinfoResult"/>
</resultMap>
<!--人口信息表-->
<resultMap type="com.ruoyi.patientme.domain.Registerinfo" id="RegisterinfoResult">
<result property="patientId" column="patient_id" />
<result property="register_id" column="REGISTER_ID" />
<result property="hospital_id" column="HOSPITAL_ID" />
<result property="name" column="NAME" />
<result property="gender" column="GENDER" />
<result property="age" column="AGE" />
<result property="birthday" column="BIRTHDAY" />
<result property="nation" column="NATION" />
<result property="fillin_person" column="FILLIN_PERSON" />
<result property="submit_audit_person" column="SUBMIT_AUDIT_PERSON" />
<result property="auditor" column="AUDITOR" />
<result property="archiving_person" column="ARCHIVING_PERSON" />
</resultMap>
<!--急救信息表-->
<resultMap type="com.ruoyi.emergencyaid.domain.Firstaidinfo" id="FirstaidinfoResult">
<result property="patientId" column="patient_id" />
<result property="inpatient_id" column="INPATIENT_ID" />
<result property="outpatient_id" column="OUTPATIENT_ID" />
<result property="attack_time" column="ATTACK_TIME" />
<result property="is_null_attack_detail_time" column="IS_NULL_ATTACK_DETAIL_TIME" />
<result property="attack_zone" column="ATTACK_ZONE" />
<result property="province" column="PROVINCE" />
<result property="city" column="CITY" />
<result property="area" column="AREA" />
<result property="attack_address" column="ATTACK_ADDRESS" />
<result property="medical_insurance_type" column="MEDICAL_INSURANCE_TYPE" />
<result property="medical_insurance_no" column="MEDICAL_INSURANCE_NO" />
<result property="serious_illness_insurance" column="SERIOUS_ILLNESS_INSURANCE" />
<result property="consciousness_type" column="CONSCIOUSNESS_TYPE" />
<result property="respiration_rate" column="RESPIRATION_RATE" />
<result property="pulse_rate" column="PULSE_RATE" />
<result property="heart_rate" column="HEART_RATE" />
<result property="throm_end_time" column="THROM_END_TIME" />
<result property="throm_drug_type" column="THROM_DRUG_TYPE" />
<result property="throm_drug_code" column="THROM_DRUG_CODE" />
<result property="is_repatency" column="IS_REPATENCY" />
<result property="start_radiography_time" column="START_RADIOGRAPHY_TIME" />
<result property="is_repci" column="IS_REPCI" />
<result property="operation_time" column="OPERATION_TIME" />
<result property="hospital_position" column="HOSPITAL_POSITION" />
<result property="patient_remark" column="PATIENT_REMARK" />
</resultMap>
<resultMap type="com.ruoyi.outcomeme.domain.Outcomeinfo" id="OutcomeinfoResult">
<result property="patientId" column="patient_id" />
<result property="cp_diagnosis_code" column="CP_DIAGNOSIS_CODE" />
<result property="diagnosis_time" column="DIAGNOSIS_TIME" />
<result property="is_heart_failure" column="IS_HEART_FAILURE" />
<result property="pcsk9_name" column="PCSK9_NAME" />
<result property="pcsk9_dose" column="PCSK9_DOSE" />
<collection property="outdrugdetailsList" javaType="java.util.List" resultMap="OutdrugdetailsResult" />
</resultMap>
<resultMap type="Outdrugdetails" id="OutdrugdetailsResult">
<id property="myDrugId" column="my_drug_id" />
<result property="drug_id" column="DRUG_ID" />
<result property="patientId" column="patient_id" />
<result property="type" column="TYPE" />
<result property="name" column="sub_name" />
<result property="dose" column="DOSE" />
<result property="rete_count" column="RETE_COUNT" />
<result property="rete_time" column="RETE_TIME" />
<result property="other_drug_name" column="OTHER_DRUG_NAME" />
</resultMap>
<!--胸痛诊疗-->
<resultMap type="Treatmentinfo" id="TreatmentinfoResult">
<id property="patientId" column="patient_id" />
<result property="has_ecg_image" column="HAS_ECG_IMAGE" />
<result property="no_ecg_image_reason" column="NO_ECG_IMAGE_REASON" />
<result property="await_doctor_name" column="AWAIT_DOCTOR_NAME" />
<result property="await_treatment_type" column="AWAIT_TREATMENT_TYPE" />
<result property="await_patient_remark" column="AWAIT_PATIENT_REMARK" />
<collection property="ctntsList" javaType="java.util.List" resultMap="CtntsRrsult" />
<collection property="ecgsList" javaType="java.util.List" resultMap="EcgsResult" />
</resultMap>
<resultMap id="CtntsRrsult" type="Ctnts">
<id property="ctntsId" column="CTNTS_ID" />
<result property="ctntsPatientId" column="ctnts_patient_id" />
<result property="type" column="TYPE" />
<result property="value" column="VALUE" />
<result property="unit" column="UNIT" />
<result property="status" column="STATUS" />
<result property="blood_time" column="BLOOD_TIME" />
<result property="report_time" column="REPORT_TIME" />
</resultMap>
<resultMap id="EcgsResult" type="Ecgs">
<id property="ecgId" column="ECG_ID" />
<result property="patientId" column="patient_id" />
<result property="ecg_time" column="ECG_TIME" />
<result property="ecg_diagnose_time" column="ECG_DIAGNOSE_TIME" />
<result property="ecgimagefiles" column="ECGImageFiles" />
</resultMap>
<!--导管室-->
<resultMap type="com.ruoyi.cathlab.domain.Treatmentpciinfo" id="TreatmentpciinfoResult">
<result property="patientId" column="patient_id" />
<result property="activate_conduit_time" column="ACTIVATE_CONDUIT_TIME" />
<result property="patient_arrived_conduit_time" column="PATIENT_ARRIVED_CONDUIT_TIME" />
<result property="auxiliary_device" column="AUXILIARY_DEVICE" />
<result property="complication" column="COMPLICATION" />
<collection property="coronaryAngiographieList" javaType="java.util.List" resultMap="CoronaryAngiographieResult" />
</resultMap>
<resultMap id="CoronaryAngiographieResult" type="CoronaryAngiographie">
<id property="caId" column="CA_ID" />
<result property="caPatientId" column="ca_patient_id" />
<result property="position" column="POSITION" />
<result property="narrow_level" column="NARROW_LEVEL" />
<result property="preoperative_timi_leve" column="PREOPERATIVE_TIMI_LEVE" />
<result property="bracket_thrombus" column="BRACKET_THROMBUS" />
<result property="branching_sick" column="BRANCHING_SICK" />
<result property="cto" column="CTO" />
<result property="ca_sick" column="CA_SICK" />
<result property="criminal_sick" column="CRIMINAL_SICK" />
<result property="pci" column="PCI" />
<result property="intraoperative_handle" column="INTRAOPERATIVE_HANDLE" />
<result property="balloon_expansion_time" column="BALLOON_EXPANSION_TIME" />
<result property="timi" column="TIMI" />
<result property="bracket_num" column="BRACKET_NUM" />
<result property="bracket_type" column="BRACKET_TYPE" />
</resultMap>
<select id="selectAlltestByPatientId" parameterType="String" resultMap="AlltestResult">
SELECT
a.patient_id,
a.REGISTER_ID,
a.HOSPITAL_ID,
a.`NAME`,
a.GENDER,
a.AGE,
a.BIRTHDAY,
a.NATION,
a.CONTACT_PHONE,
a.CREDENTIALS_TYPE,
a.IDCARD,
a.JOB,
a.CULTUREDEGREE,
a.MARITALSTATUS,
a.HEIGHT,
a.WEIGHT,
a.`STATUS`,
a.FILLIN_PERSON,
a.SUBMIT_AUDIT_PERSON,
a.AUDITOR,
a.ARCHIVING_PERSON,
b.patient_id,
b.INPATIENT_ID,
b.OUTPATIENT_ID,
b.ATTACK_TIME,
b.IS_NULL_ATTACK_DETAIL_TIME,
b.ATTACK_ZONE,
b.PROVINCE,
b.CITY,
b.AREA,
b.ATTACK_ADDRESS,
b.MEDICAL_INSURANCE_TYPE,
b.MEDICAL_INSURANCE_NO,
b.SERIOUS_ILLNESS_INSURANCE,
b.CONSCIOUSNESS_TYPE,
b.RESPIRATION_RATE,
b.PULSE_RATE,
b.HEART_RATE,
b.BLOOD_PRESSURE,
b.TEMPERATURE,
b.DISTRESS_CASE,
b.DISTRESS_CASE_DETAIL,
b.CW_COMING_WAY_CODE,
b.CW_120_AMBULANCE_DEPARTMENT,
b.CW_120_HELP_TIME,
b.CW_120_ARRIVED_HOSPITAL_TIME,
b.CW_120_IS_TRANS_HOSPITAL,
b.CW_120_IS_DIRECT_CONDUIT_ROOM,
b.CW_120_FIRST_MC_TIME,
b.CW_120_FIRST_DOCTOR_TIME,
b.CW_120_FIRST_DOCTOR_NAME,
b.CW_ZY_TRANS_TYPE,
b.CW_ZY_TRANS_HOSPITAL_NAME,
b.CW_ZY_FIRST_MC_TIME,
b.CW_ZY_OUTHOSPITAL_VISIT_TIME,
b.CW_ZY_IS_TRANS_HOSPITAL,
b.CW_ZY_TRANSFER_TIME,
b.CW_ZY_LEAVE_OUTHOSPITAL_TIME,
b.CW_ZY_ARRIVED_HOSPITAL_TIME,
b.CW_ZY_ADMISSION_TIME,
b.CW_ZY_FIRST_DOCTOR_NAME,
b.CW_ZY_IS_DIRECT_CONDUIT_ROOM,
b.CW_ZXLY_ARRIVED_HOSPITAL_TIME,
b.CW_ZXLY_FIRST_MC_TIME,
b.CW_ZXLY_FIRST_DOCTOR_TIME,
b.CW_ZXLY_FIRST_DOCTOR_NAME,
b.CW_YNFB_ATTACK_DEPARTMENT,
b.CW_YNFB_FIRST_MC_TIME,
b.CW_YNFB_LEAVE_DEPARTMENT_TIME,
b.CW_YNFB_FIRST_DOCTOR_NAME,
b.SCREENING,
b.THROM_CONTRAINDICATION,
b.IS_THROMBOLYSIS,
b.IS_DIRECT,
b.THROM_TREATMENT_PLACE,
b.START_AGREE_TIME,
b.SIGN_AGREE_TIME,
b.THROM_START_TIME,
b.THROM_END_TIME,
b.THROM_DRUG_TYPE,
b.THROM_DRUG_CODE,
b.IS_REPATENCY,
b.START_RADIOGRAPHY_TIME,
b.IS_REPCI,
b.OPERATION_TIME,
b.HOSPITAL_POSITION,
b.PATIENT_REMARK,
c.patient_id,
c.CP_DIAGNOSIS_CODE,
c.DIAGNOSIS_TIME,
c.IS_HEART_FAILURE,
c.HEART_FAILURE_NYHA_LEVEL,
c.IS_ARNI,
c.ARNI_DOSE,
c.ARNI_FREQUENCY,
c.ARNI_FREQUENCY_RANGE,
c.COMPLICATION,
c.NACS_TYPE,
c.OTHER_NACS_TYPE,
c.FERITIN,
c.HYPERLIPEMIA,
c.DIABETES,
c.SMOKING,
c.SMOKING_STATUS,
c.OBESITY,
c.FAMILY_DISEASE,
c.CHD,
c.PREVIOUS_REVASCULARIZATION,
c.AF,
c.AF_TYPE,
c.SLOW_HEART_FAILURE,
c.NYHA_LEVEL,
c.AVHD,
c.BRIAN_VASCELLUM,
c.BRIAN_VASCELLUM_DESC,
c.PERIPHERAL_ARTERY_DISEASE,
c.AORTIC_ANEURYSM,
c.COPD,
c.CHRONIC_KIDNEY_DISEASE,
c.ANEMIA,
c.PEPTIC_ULCER,
c.THYROID_DISEASE,
c.THERIOMA,
c.TROPONIN_72H,
c.TROPONIN_72H_TYPE,
c.CTNI_MAX_VALUE,
c.CTNI_MAX_VALUE_UNIT,
c.BNP,
c.BNP_TYPE,
c.BNP_VALUE,
c.TC,
c.TC_VALUE,
c.TG,
c.TG_VALUE,
c.HDL_C,
c.HDL_C_VALUE,
c.LDL_C,
c.LDL_C_VALUE,
c.UCG,
c.LVEF,
c.VNTRICULAR_ANEURYSM,
c.PART_VNTRICULAR,
c.HOD,
c.TOTAL_COST,
c.OUTCOME_CODE,
c.LEAVE_TIME,
c.TREATMENT_RESULT_CODE,
c.OUT_DRUG_IS_DAPT,
c.OUT_DRUG_IS_ACEIORARB,
c.OUT_DRUG_IS_STATINS,
c.OUT_DRUG_IS_RETARDANT,
c.HAND_TIME,
c.HOSPITAL_NAME,
c.IS_NET_HOSPITAL,
c.IS_TRANS_PC,
c.IS_DIRECT_CATHETER,
c.DECISION_OPERATION_TIME,
c.BALLOON_EXPANSION_TIME,
c.REMOTE_ECG_TRANSMISSION,
c.TRANS_ECG_TIME,
c.TRANS_WAY,
c.AFTER_THROMBOLYSIS_RADIOGRAPHY,
c.START_RADIOGRAPHY_TIME,
c.TRANSFER_DATE,
c.ADMISSION_DEPT,
c.TRANSFER_REASON,
c.DEATH_TIME,
c.DEATH_CAUSE_CODE,
c.DEATH_CAUSE_DESC,
c.REMARK,
c.MISSION_EDUCATION,
c.COVID19,
c.IS_JTYW,
c.JTYWNAME,
c.IS_KNYW,
c.KNYWNAME,
c.IS_PCSK9,
c.PCSK9_NAME,
c.PCSK9_DOSE,
outdrugdetails.my_drug_id,
outdrugdetails.DRUG_ID,
outdrugdetails.patient_id,
outdrugdetails.TYPE,
outdrugdetails.`NAME` sub_name,
outdrugdetails.DOSE,
outdrugdetails.RETE_COUNT,
outdrugdetails.RETE_TIME,
outdrugdetails.OTHER_DRUG_NAME,
d.patient_id,
d.HAS_ECG_IMAGE,
d.NO_ECG_IMAGE_REASON,
d.REMOTE_ECG_TRANSMISSION,
d.TRAN_TIME,
d.IS_REMOTE_ECGTRAN,
d.IS_CTNT,
d.IS_CR,
d.CR_VALUE,
d.IS_Ddimer,
d.Ddimer_VALUE,
d.Ddimer_UNIT,
d.IS_BNP,
d.BNP_VALUE,
d.IS_NTproBNP,
d.NTproBNP_VALUE,
d.IS_MYO,
d.MYO_VALUE,
d.MYO_UNIT,
d.IS_CKMB,
d.CKMB_VALUE,
d.CKMB_UNIT,
d.IS_NOTICE_IMCD,
d.IMCD_TYPE,
d.NOTICE_IMCD_TIME,
d.CONSULTATION_TIME,
d.CP_DIAGNOSIS_CODE,
d.STEMI_GIVE_UP_TREATMENT,
d.STEMI_DIAGNOSIS_TIME,
d.STEMI_DOCTOR_NAME,
d.STEMI_KILLIP_LEVEL,
d.STEMI_IS_BYPASS_EMERGENCY,
d.STEMI_IS_BYPASS_CCU,
d.STEMI_IS_DRUG,
d.STEMI_ASPIRIN_DOSE,
d.STEMI_ASPIRIN_TIME,
d.STEMI_CLOPIDOGREL_DOSE,
d.STEMI_CLOPIDOGREL_TIME,
d.STEMI_TICAGRELOR_DOSE,
d.STEMI_TICAGRELOR_TIME,
d.STEMI_IS_ANTICOAGULATION,
d.STEMI_ANTICOAGULATION_DRUG,
d.STEMI_ANTICOAGULATION_DOSE,
d.STEMI_ANTICOAGULATION_UNIT,
d.STEMI_ANTICOAGULATION_TIME,
d.STEMI_INTENSIFY_STATINS_TREAT,
d.STEMI_RECEPTOR_RETARDANT_USING,
d.STEMI_IS_REPERFUSION,
d.EMI_NO_REPERFUSION_REASON,
d.STEMI_MEASURES,
d.STEMI_MEASURES_THROMBOLYSIS,
d.STEMI_MEASURES_DOCTOR_NAME,
d.STEMI_DECISION_OPERATION_TIME,
d.STEMI_START_CONDUIT_TIME,
d.STEMI_START_AGREE_TIME,
d.STEMI_SIGN_AGREE_TIME,
d.STEMI_START_RADIOGRAPHY_TIME,
d.STEMI_DECISION_CABG_TIME,
d.STEMI_START_CABG_TIME,
d.STEMI_TPCI_TYPE,
d.STEMI_SCREENING,
d.STEMI_THROM_CONTRAINDICATION,
d.STEMI_IS_THROMBOLYSIS,
d.STEMI_IS_DIRECT,
d.STEMI_DIAGNOSIS_UNIT_CODE_DT,
d.STEMI_THROM_START_AGREE_TIME,
d.STEMI_THROM_SIGN_AGREE_TIME,
d.STEMI_THROM_START_TIME_DT,
d.STEMI_THROM_END_TIME_DT,
d.STEMI_THROM_DRUG_TYPE_DT,
d.STEMI_THROM_DRUG_CODE_DT,
d.STEMI_IS_REPATENCY_DT,
d.NSTEMI_GIVE_UP_TREATMENT,
d.NSTEMI_DIAGNOSIS_TIME,
d.NSTEMI_DOCTOR_NAME,
d.NSTEMI_KILLIP_LEVEL,
d.NSTEMI_IS_BYPASS_EMERGENCY,
d.NSTEMI_IS_BYPASS_CCU,
d.NSTEMI_IS_DRUG,
d.NSTEMI_ASPIRIN_DOSE,
d.NSTEMI_ASPIRIN_TIME,
d.NSTEMI_CLOPIDOGREL_DOSE,
d.NSTEMI_CLOPIDOGREL_TIME,
d.NSTEMI_TICAGRELOR_DOSE,
d.NSTEMI_TICAGRELOR_TIME,
d.NSTEMI_IS_ANTICOAGULATION,
d.NSTEMI_ANTICOAGULATION_DRUG,
d.NSTEMI_ANTICOAGULATION_DOSE,
d.NSTEMI_ANTICOAGULATION_UNIT,
d.NSTEMI_ANTICOAGULATION_TIME,
d.NSTEMI_INTENSIFY_STATINS_TREAT,
d.NSTEMI_IS_BETA_BLOCKER,
d.NSTEMI_GRACE_ESTIMATE,
d.NSTEMI_GRACE_HR_CONDITION,
d.NSTEMI_GRACE_VALUE,
d.NSTEMI_RISK_LAMINATION,
d.NSTEMI_RISK_LAMINATION_AG,
d.NSTEMI_RISK_LAMINATION_AG_TIME,
d.NSTEMI_STRATEGY,
d.NSTEMI_INVASIVE_STRATEGY,
d.NSTEMI_STRATEGY_DOCTOR_NAME,
d.NSTEMI_DECISION_OPERATION_TIME,
d.NSTEMI_START_CONDUIT_TIME,
d.NSTEMI_START_AGREE_TIME,
d.NSTEMI_SIGN_AGREE_TIME,
d.NSTEMI_ACTUAL_INTERVENT_TIME,
d.UA_GIVE_UP_TREATMENT,
d.UA_DIAGNOSIS_TIME,
d.UA_DOCTOR_NAME,
d.UA_KILLIP_LEVEL,
d.UA_IS_BYPASS_EMERGENCY,
d.UA_IS_BYPASS_CCU,
d.UA_IS_DRUG,
d.UA_ASPIRIN_DOSE,
d.UA_ASPIRIN_TIME,
d.UA_CLOPIDOGREL_DOSE,
d.UA_CLOPIDOGREL_TIME,
d.UA_TICAGRELOR_DOSE,
d.UA_TICAGRELOR_TIME,
d.UA_IS_ANTICOAGULATION,
d.UA_ANTICOAGULATION_DRUG,
d.UA_ANTICOAGULATION_DOSE,
d.UA_ANTICOAGULATION_UNIT,
d.UA_ANTICOAGULATION_TIME,
d.UA_INTENSIFY_STATINS_TREAT,
d.UA_RECEPTOR_RETARDANT_USING,
d.UA_GRACE_ESTIMATE,
d.UA_GRACE_HR_CONDITION,
d.UA_GRACE_VALUE,
d.UA_RISK_LAMINATION,
d.UA_RISK_LAMINATION_AG,
d.UA_RISK_LAMINATION_AG_TIME,
d.UA_STRATEGY,
d.UA_INVASIVE_STRATEGY,
d.UA_STRATEGY_DOCTOR_NAME,
d.UA_DECISION_OPERATION_TIME,
d.UA_START_CONDUIT_TIME,
d.UA_START_AGREE_TIME,
d.UA_SIGN_AGREE_TIME,
d.UA_ACTUAL_INTERVENTION_TIME,
d.AD_GIVE_UP_TREATMENT,
d.AD_DIAGNOSIS_TIME,
d.AD_DOCTOR_NAME,
d.AD_IMG_EXAMINATION,
d.AD_CT_NOTICE_TIME,
d.AD_CT_FINISH_TIME,
d.AD_CT_SCAN_TIME,
d.AD_CT_REPORT_TIME,
d.AD_NOTICE_CDU_TIME,
d.AD_CDU_CHECK_TIME,
d.AD_CHECK_RESULT_TIME,
d.AD_IMCD_NOTICE_TIME,
d.AD_INTERLAYER_TYPE,
d.AD_ECC_CONSULTATION_TIME,
d.AD_TREATMENT_STRATEGY_CODE,
d.PE_GIVE_UP_TREATMENT,
d.PE_DIAGNOSIS_TIME,
d.PE_DOCTOR_NAME,
d.PE_IMG_EXAMINATION,
d.PE_CT_NOTICE_TIME,
d.PE_CT_FINISH_TIME,
d.PE_CT_SCAN_TIME,
d.PE_CT_REPORT_TIME,
d.PE_RISK_LAMINATION,
d.PE_ANTI_TREATMENT_TIME,
d.PE_SCREENING,
d.PE_THROM_CONTRAINDICATION,
d.PE_IS_THROMBOLYSIS,
d.NACS_GIVE_UP_TREATMENT,
d.NACS_DIAGNOSIS_TIME,
d.NACS_DOCTOR_NAME,
d.NACS_TYPE,
d.NACS_TREATMENT_TYPE,
d.NACS_PATIENT_REMARK,
d.OTHER_GIVE_UP_TREATMENT,
d.OTHER_DIAGNOSIS_TIME,
d.OTHER_DOCTOR_NAME,
d.OTHER_TYPE,
d.OTHER_TREATMENT_TYPE,
d.OTHER_PATIENT_REMARK,
d.AWAIT_GIVE_UP_TREATMENT,
d.AWAIT_DIAGNOSIS_TIME,
d.AWAIT_DOCTOR_NAME,
d.AWAIT_TREATMENT_TYPE,
d.AWAIT_PATIENT_REMARK,
ctnts.CTNTS_ID,
ctnts.ctnts_patient_id,
ctnts.TYPE,
ctnts.`VALUE`,
ctnts.UNIT,
ctnts.`STATUS`,
ctnts.BLOOD_TIME,
ctnts.REPORT_TIME,
ecgs.ECG_ID,
ecgs.patient_id,
ecgs.ECG_TIME,
ecgs.ECG_DIAGNOSE_TIME,
ecgs.ECGImageFiles,
e.patient_id,
e.ACTIVATE_CONDUIT_TIME,
e.PATIENT_ARRIVED_CONDUIT_TIME,
e.INTERVENTION_PERSON,
e.START_PUNCTURE_TIME,
e.START_RADIOGRAPHY_TIME,
e.PREOPERATIVE_TIMI_LEVEL,
e.ANTICOAGULATION_TIME,
e.ANTICOAGULATION_DRUG,
e.ANTICOAGULATION_DOSE,
e.ANTICOAGULATION_UNIT,
e.END_OPERATION_TIME,
e.DTWOB_TIME,
e.IS_DELAY,
e.DELAY_REASON,
e.ROUTE,
e.POSITION,
e.INTRACAVITY_IMAGE,
e.FUNCTION_TEST,
e.FUNCTION_TEST_VALUE,
e.IABP,
e.PACEMAKER,
e.ECMO,
e.AUXILIARY_DEVICE,
e.COMPLICATION,
coronary_angiographie.CA_ID,
coronary_angiographie.ca_patient_id,
coronary_angiographie.POSITION,
coronary_angiographie.NARROW_LEVEL,
coronary_angiographie.PREOPERATIVE_TIMI_LEVE,
coronary_angiographie.BRACKET_THROMBUS,
coronary_angiographie.BRANCHING_SICK,
coronary_angiographie.CTO,
coronary_angiographie.CA_SICK,
coronary_angiographie.CRIMINAL_SICK,
coronary_angiographie.PCI,
coronary_angiographie.INTRAOPERATIVE_HANDLE,
coronary_angiographie.BALLOON_EXPANSION_TIME,
coronary_angiographie.TIMI,
coronary_angiographie.BRACKET_NUM,
coronary_angiographie.BRACKET_TYPE
FROM
registerinfo a,
firstaidinfo b,
outcomeinfo c
LEFT JOIN outdrugdetails ON outdrugdetails.patient_id = c.patient_id,
treatmentinfo d
LEFT JOIN ctnts ON ctnts.ctnts_patient_id = d.patient_id
LEFT JOIN ecgs ON ecgs.patient_id = d.patient_id,
treatmentpciinfo e
LEFT JOIN coronary_angiographie ON coronary_angiographie.ca_patient_id = e.patient_id
WHERE
a.patient_id = #{paientId} and
a.patient_id = b.patient_id
AND a.patient_id = c.patient_id
AND a.patient_id = d.patient_id
AND a.patient_id = e.patient_id
</select>
如果这个Outdrugdetails表里面对应的patientId有两条数据，目标最后的返回的数据是1条，但是返回了两条。
我改了数据类型为list还是不行，sql语句我目前只知道这么写，我试过将select语句嵌套在collection中但是报错了。现在不知道怎么解决这个问题。
最后返回的结果可以正确的嵌套。
outcomeinfo c LEFT JOIN outdrugdetails ON outdrugdetails.patient_id = c.patient_id
你说了你的outdrugdetails对应的patientId 有两条数据，left join 的时候肯定会出现两条啊，不考虑使用哪条数据的话最后面加limit 1