DTO中需要传的参数
List<String> series;
Mapper:
List<OveRcdPartCodeSelDTO> selectChMessageByPartCode(Page page, @Param("oveRcdPartCodeSelectDTO") OveRcdPartCodeSelDTO oveRcdPartCodeSelDTO);
xml:
<select id="selectChMessageByPartCode" resultType="com.adc.da.ove.record.dto.OveRcdPartCodeSelDTO">
SELECT DISTINCT
part.PART_CODE,
orbl.BUS_NM PART_NM_CH,
syst.MODULE_CODE,
syst.SC_CODE_PREFIX
FROM OVE_RCD_COMPONENT_PUBLISH syst
LEFT JOIN OVE_RCD_COMPONENT_PUBLISH part ON syst.PART_CODE = part.PART_CODE
LEFT JOIN OVE_RCD_BUS_LAN orbl ON part.PART_CODE = orbl.BUS_CODE
LEFT JOIN OVE_RCD_SC_CONFIGURATION orsc ON syst.SC_CODE = orsc.SC_CODE
LEFT JOIN OVE_RCD_BUS_LAN thrBrand ON orsc.BRAND = thrBrand.BUS_CODE
LEFT JOIN OVE_RCD_BUS_LAN thrSeries ON orsc.SE