order实体类:
package com.text.entity;
import java.util.Date; import java.util.List; import lombok.Data; /** * 快递下单 * @author renhaisong * */ @Data public class Order { /**订单商品集合(必填)*/ private List<OrderItem> orderItemList; /** 电子商务物流交易号(等同于订单号) (必填)*/ private String orderNo; /** 付款方ID (必填)*/ private Integer paySideId; /** 支付方式ID (必填)*/ private Integer payModeId; /** 包装说明(必填) */ private String packageDesc; /**订单种类**/ private int order_type; /** 寄件联系人(必填) */ private String sendLinkMan; /** 寄件手机 (必填)*/ private String sendPhoneSms; /** 寄件地址 (必填)*/ private String sendAddress; /** 收件联系人 (必填)*/ private String dispatchLinkMan; /** 收件手机(必填)*/ private String dispatchPhoneSms; /** 收件地址 (必填)*/ private String dispatchAddress; /** 寄件省份 */ private String sendProvince; /** 寄件城市 */ private String sendCity; /** 寄件区县 */ private String sendCounty; /** 收件省份 */ private String dispatchProvince; /** 收件城市*/ private String dispatchCity; /** 收件区县*/ private String dispatchCounty; |
OrderItem实体类: package com.text.entity; import lombok.Data; @Data public class OrderItem { /** 订单ID */ private Integer orderId; /** 物品排序 */ private Integer goodsOrder; /** 物品类型 */ private Integer goodsType; /** 物品名称 */ private String goodsName; /** 件数 */ private Integer piece; /** 备注 */ private String remark; } |
保存order 的sql语句: <?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" > <mapper namespace="com.text.dao.OrderDao"> <insert id="save" parameterType="com.text.entity.Order"> insert into tb_s_order (orderNo,sendName,sendPhone,sendProvince,sendCity, sendCounty,sendAddress,dispatchName, dispatchPhone,dispatchProvince,dispatchCity,dispatchCity, dispatchAddress,goodsName,goodsType,piece,remark) values <foreach collection="orderItemList" item="item" index="index" separator=","> (#{orderNo,jdbcType=VARCHAR}, #{sendLinkMan,jdbcType=VARCHAR}, #{sendPhone,jdbcType=VARCHAR}, #{sendProvince,jdbcType=VARCHAR}, #{sendCity,jdbcType=VARCHAR}, #{sendRegion,jdbcType=VARCHAR}, #{sendAddress,jdbcType=VARCHAR}, #{dispatchLinkMan,jdbcType=VARCHAR}, #{dispatchPhone,jdbcType=VARCHAR}, #{dispatchProvince,jdbcType=VARCHAR}, #{dispatchCity,jdbcType=VARCHAR}, #{dispatchAddress,jdbcType=VARCHAR}, #{item.goodsName,jdbcType=VARCHAR}, #{item.goodsType,jdbcType=INTEGER}, #{item.piece,jdbcType=INTEGER}, #{item.remark,jdbcType=VARCHAR},) </foreach> </insert> </mapper> |