以批量插入订单号、订单金额为例
<insert id="insertBatch" parameterType="java.util.List">
insert into order_info (id, order_no, amount)
values
<foreach collection="dataList" index="index" item="item" separator=",">
(
#{item.id},
#{item.orderNo},
#{item.amt}
)
</foreach>
</insert>
需要改为
<insert id="insertBatch" parameterType="java.util.List">
insert into order_info (id, order_no, amount)
values
<foreach collection="dataList" index="index" item="item" separator=",">
(
#{item.id},
#{item.orderNo},
cast(#{item.amt, jdbcType=DECIMAL} as decimal(18,2))
)
</foreach>
</insert>