springmvc 批量插入，更新

最新推荐文章于 2021-06-05 14:55:36 发布

weixin_30576827

最新推荐文章于 2021-06-05 14:55:36 发布

阅读量248

点赞数

文章标签： java

原文链接：http://www.cnblogs.com/yangxu6069/p/6225274.html

版权

       <insert id="insertUser">  
       insert into user(name,age，createTime,createBy,modifyTime,modifyBy)  
     values  
       <foreach collection="list" item="item" index="index" separator=",">  
        ( #{item.name},#{item.age},#{item.createTime},#{item.createBy},#{item.modifyTime},#{item.modifyBy} )  
       </foreach>  
   </insert>  


<update id="batchUpdate"  parameterType="Java.util.List" >
          <foreach collection="list" item="item" index="index" open="" close="" separator=";">
                update test
                <set>
                <if test="item.type != null and item.type != ''">
s_type = #{item.type},
</if>
                <if test="item.status != null and item.status != ''">
status = #{item.status}
</if>
                <if test="item.oldPath != null and item.oldPath != ''"> 
               
old_path = #{item.oldPath},
</if>
<if test="item.breviaryPath != null and item.breviaryPath != ''">
b_path = #{item.breviaryPath},
</if>
<if test="item.bigImagePath != null and item.bigImagePath != ''">
big_path = #{item.bigImagePath},
</if>

<if test="item.bigType != null and item.bigType != ''">
s_bigType = #{item.bigType},
</if>
<if test="item.userId != null and item.userId != ''">
s_userId = #{item.userId},
</if>
<if test="item.oldName != null and item.oldName != ''">
old_fileName = #{item.oldName},
</if>
<if test="item.breviaryName != null and item.breviaryName != ''">
b_fileName = #{item.breviaryName},
</if>
<if test="item.remark != null and item.remark != ''">
s_remark = #{item.remark},
</if>
                </set>
                where id = ${item.id}
         </foreach>
    </update>

转载于:https://www.cnblogs.com/yangxu6069/p/6225274.html