批量更新
<!--批量更新-->
<update id="updateBatch" parameterType="java.util.List">
<foreach collection="list" item="item" separator=";">
update pr_tabletwo
set DXGCID = #{item.dxgcid,jdbcType=INTEGER},
XH = #{item.xh,jdbcType=VARCHAR},
FYMC = #{item.fymc,jdbcType=VARCHAR},
FYID = #{item.fyid,jdbcType=INTEGER},
KZLX = #{item.kzlx,jdbcType=INTEGER},
GS = #{item.gs,jdbcType=VARCHAR},
YJHJSFF = #{item.yjhjsff,jdbcType=VARCHAR},
HJ = #{item.hj,jdbcType=DOUBLE},
XGFL = #{item.xgfl,jdbcType=DOUBLE},
JSSX = #{item.jssx,jdbcType=INTEGER}
where id = #{item.id,jdbcType=INTEGER}
</foreach>
</update>
批量新增
<!--批量插入-->
<insert id="insertBatch" parameterType="java.util.List">
<foreach collection="list" item="item" separator=";">
insert into pr_tabletwo (id, DXGCID, XH,
FYMC, FYID, KZLX, GS,
YJHJSFF, HJ, XGFL, JSSX
)
values (#{item.id,jdbcType=INTEGER}, #{item.dxgcid,jdbcType=INTEGER},
#{item.xh,jdbcType=VARCHAR},#{item.fymc,jdbcType=VARCHAR},
#{item.fyid,jdbcType=INTEGER}, #{item.kzlx,jdbcType=INTEGER},
#{item.gs,jdbcType=VARCHAR},#{item.yjhjsff,jdbcType=VARCHAR},
#{item.hj,jdbcType=DOUBLE}, #{item.xgfl,jdbcType=DOUBLE},
#{item.jssx,jdbcType=INTEGER}
)
</foreach>
</insert>