@Data
public class JdOrder implements Serializable{
private Long orderId;
private Long finishTime;
private Integer orderEmt;
private Long orderTime;
private Long parentId;
private String payMonth;
private Integer plus;
private Long popId;
private Long unionId;
private String ext1;
private Integer validCode;
private String hasMore;
//预估佣金
private Double estimateFee;
//商户名称
private String merchantName;
//顾客号码
private String customerId;
**//返回数据要包含的list**
private List<JdSkuList> jdSkuLists;
}
@Data
public class JdSkuList extends JdSkuListKey implements Serializable{
private Double actualCosPrice;
private Double actualFee;
private Double commissionRate;
private Double estimateCosPrice;
private Double estimateFee;
private Double finalRate;
private Long cid1;
private Long frozenSkuNum;
private String pid;
private Long positionId;
private Double price;
private Long cid2;
private Long siteId;
private String skuName;
private Long skuNum;
private Long skuReturnNum;
private Double subSideRate;
private Double subsidyRate;
private Long cid3;
private String unionAlias;
private String unionTag;
private Integer unionTrafficGroup;
private Integer validCode;
private String subUnionId;
private Integer traceType;
private Integer payMonth;
private Long popId;
private String ext1;
private String merchantName;
}
<resultMap id="BaseResultMap" type="com.luer.JD.bean.JdOrder">
<id column="order_id" property="orderId" jdbcType="BIGINT"/>
<result column="finish_time" property="finishTime" jdbcType="BIGINT"/>
<result column="order_emt" property="orderEmt" jdbcType="INTEGER"/>
<result column="order_time" property="orderTime" jdbcType="BIGINT"/>
<result column="parent_id" property="parentId" jdbcType="BIGINT"/>
<result column="pay_month" property="payMonth" jdbcType="VARCHAR"/>
<result column="plus" property="plus" jdbcType="INTEGER"/>
<result column="pop_id" property="popId" jdbcType="BIGINT"/>
<result column="union_id" property="unionId" jdbcType="BIGINT"/>
<result column="ext1" property="ext1" jdbcType="VARCHAR"/>
<result column="valid_code" property="validCode" jdbcType="INTEGER"/>
<result column="has_more" property="hasMore" jdbcType="VARCHAR"/>
//property="jdSkuLists" ,要与第一步对象中定义的list属性名称一样
<collection property="jdSkuLists" resultMap="JdSkuListResultMap"/>
</resultMap>
<resultMap id="JdSkuListResultMap" type="com.luer.JD.bean.JdSkuList">
<id column="order_id" property="orderId" jdbcType="BIGINT"/>
<id column="sku_id" property="skuId" jdbcType="BIGINT"/>
<result column="actual_cos_price" property="actualCosPrice" jdbcType="DOUBLE"/>
<result column="actual_fee" property="actualFee" jdbcType="DOUBLE"/>
<result column="commission_rate" property="commissionRate" jdbcType="DOUBLE"/>
<result column="estimate_cos_price" property="estimateCosPrice" jdbcType="DOUBLE"/>
<result column="estimate_fee" property="estimateFee" jdbcType="DOUBLE"/>
<result column="final_rate" property="finalRate" jdbcType="DOUBLE"/>
<result column="cid1" property="cid1" jdbcType="BIGINT"/>
<result column="frozen_sku_num" property="frozenSkuNum" jdbcType="BIGINT"/>
<result column="pid" property="pid" jdbcType="VARCHAR"/>
<result column="position_id" property="positionId" jdbcType="BIGINT"/>
<result column="price" property="price" jdbcType="DOUBLE"/>
<result column="cid2" property="cid2" jdbcType="BIGINT"/>
<result column="site_id" property="siteId" jdbcType="BIGINT"/>
<result column="sku_name" property="skuName" jdbcType="VARCHAR"/>
<result column="sku_num" property="skuNum" jdbcType="BIGINT"/>
<result column="sku_return_num" property="skuReturnNum" jdbcType="BIGINT"/>
<result column="sub_side_rate" property="subSideRate" jdbcType="DOUBLE"/>
<result column="subsidy_rate" property="subsidyRate" jdbcType="DOUBLE"/>
<result column="cid3" property="cid3" jdbcType="BIGINT"/>
<result column="union_alias" property="unionAlias" jdbcType="VARCHAR"/>
<result column="union_tag" property="unionTag" jdbcType="VARCHAR"/>
<result column="union_traffic_group" property="unionTrafficGroup" jdbcType="INTEGER"/>
<result column="valid_code" property="validCode" jdbcType="INTEGER"/>
<result column="sub_union_id" property="subUnionId" jdbcType="VARCHAR"/>
<result column="trace_type" property="traceType" jdbcType="INTEGER"/>
<result column="pay_month" property="payMonth" jdbcType="INTEGER"/>
<result column="pop_id" property="popId" jdbcType="BIGINT"/>
<result column="ext1" property="ext1" jdbcType="VARCHAR"/>
</resultMap>
<sql id="JdSkuList_Column_List" >
jsl.order_id, jsl.sku_id, jsl.actual_cos_price, jsl.actual_fee, jsl.commission_rate, jsl.estimate_cos_price,
jsl.estimate_fee, jsl.final_rate, jsl.cid1, jsl.frozen_sku_num, jsl.pid, jsl.position_id, jsl.price, jsl.cid2, jsl.site_id,
jsl.sku_name, jsl.sku_num, jsl.sku_return_num, jsl.sub_side_rate, jsl.subsidy_rate, jsl.cid3, jsl.union_alias,
jsl.union_tag, jsl.union_traffic_group, jsl.valid_code, jsl.sub_union_id, jsl.trace_type, jsl.pay_month,
jsl.pop_id, jsl.ext1
</sql>
<select id="selectOrder" resultMap="BaseResultMap">
SELECT j.*,<include refid="JdSkuList_Column_List"/> FROM jd_order j
left join jd_sku_list jsl on jsl.order_id=j.order_id
order by j.order_time desc
</select>
<select id="selectOrder" resultMap="BaseResultMap">
SELECT j.*,
jsl.order_id, jsl.sku_id, jsl.actual_cos_price, jsl.actual_fee, jsl.commission_rate, jsl.estimate_cos_price,
jsl.estimate_fee, jsl.final_rate, jsl.cid1, jsl.frozen_sku_num, jsl.pid, jsl.position_id, jsl.price, jsl.cid2, jsl.site_id,
jsl.sku_name, jsl.sku_num, jsl.sku_return_num, jsl.sub_side_rate, jsl.subsidy_rate, jsl.cid3, jsl.union_alias,
jsl.union_tag, jsl.union_traffic_group, jsl.valid_code, jsl.sub_union_id, jsl.trace_type, jsl.pay_month,
jsl.pop_id, jsl.ext1
FROM jd_order j
left join jd_sku_list jsl on jsl.order_id=j.order_id
order by j.order_time desc
</select>