天天看点

mybatis的sql语句list中插入list

<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;
}