<collection property="packageDetailList" ofType="com.jd.eclp.co.dto.PackageDetail" javaType="java.util.List">
<result column="li_package_name" property="packageName" jdbcType="VARCHAR"/>
<result column="li_package_no" property="packageNo" jdbcType="VARCHAR"/>
</collection>
select
li.package_no "li_package_no"
from lwb_main lm LEFT JOIN las_winter_olympic lwo ON lm.id = lwo.wb_id
LEFT JOIN lwb_item li ON lm.id = li.wb_id
where lm.lwb_no = 'JDLD10172606101' AND lwo.yn = 1
public class WinterOlympicDTO {
/**
* 包裹資訊list
*/
private List<PackageDetail> packageDetailList;
}
public class PackageDetail {
/**
* 包裹名稱
*/
private String packageName;
/**
* 包裹号
*/
private String packageNo;
}