java父子表_mybatis父子表批量插入

begin

insert into TB_JF_ORDER

ORDER_ID,

EXT_ORDER_ID,

DEVICE_CHANNEL,

BIZ_CHANNEL,

ORDER_TYPE,

USER_ID,

ORDER_DATE,

ORDER_AMOUNT,

PRODUCT_AMOUNT,

PAY_AMOUNT,

FEE,

SALES,

FREIGHT,

DELIVERY_STATE,

ORDER_STATE,

ORDER_DESC,

REMARK,

CREATE_DATE,

PAY_DATE,

FINISH_DATE,

RETURN_DATE,

CLOSE_DATE,

DELIVERY_DATE,

#{orderId,jdbcType=VARCHAR},

#{extOrderId,jdbcType=VARCHAR},

#{deviceChannel,jdbcType=VARCHAR},

#{bizChannel,jdbcType=VARCHAR},

#{orderType,jdbcType=CHAR},

#{userId,jdbcType=VARCHAR},

#{orderDate,jdbcType=CHAR},

#{orderAmount,jdbcType=VARCHAR},

#{productAmount,jdbcType=VARCHAR},

#{payAmount,jdbcType=VARCHAR},

#{fee,jdbcType=VARCHAR},

#{sales,jdbcType=VARCHAR},

#{freight,jdbcType=VARCHAR},

#{deliveryState,jdbcType=CHAR},

#{orderState,jdbcType=CHAR},

#{orderDesc,jdbcType=VARCHAR},

#{remark,jdbcType=VARCHAR},

#{createDate,jdbcType=DATE},

#{payDate,jdbcType=DATE},

#{finishDate,jdbcType=DATE},

#{returnDate,jdbcType=DATE},

#{closeDate,jdbcType=DATE},

#{deliveryDate,jdbcType=DATE},

;

insert into TB_JF_ORDER_VIP

ORDER_ID,

ACCOUNT_NAME,

CARD_NO,

BANK_NAME,

PROVINCE,

CITY,

BRANCH,

CP_TRADING_STATUS,

BANK_CARD_ID,

#{orderId,jdbcType=VARCHAR},

#{accountName,jdbcType=VARCHAR},

#{cardNo,jdbcType=VARCHAR},

#{bankName,jdbcType=VARCHAR},

#{province,jdbcType=VARCHAR},

#{city,jdbcType=VARCHAR},

#{branch,jdbcType=VARCHAR},

#{cpTradingStatus,jdbcType=CHAR},

#{bankCardId,jdbcType=CHAR},

;

end;