java mvc 批量插入_springmvc 批量插入，更新

insert into user(name,age，createTime,createBy,modifyTime,modifyBy)

values

( #{item.name},#{item.age},#{item.createTime},#{item.createBy},#{item.modifyTime},#{item.modifyBy} )

update test

s_type = #{item.type},

status = #{item.status}

old_path = #{item.oldPath},

b_path = #{item.breviaryPath},

big_path = #{item.bigImagePath},

s_bigType = #{item.bigType},

s_userId = #{item.userId},

old_fileName = #{item.oldName},

b_fileName = #{item.breviaryName},

s_remark = #{item.remark},

where id = ${item.id}