mybatis批量插入和批量更新

港控/mmm° 2022-05-28 07:00 292阅读 0赞

一、批量插入

![70][]

![70 1][]

二、批量更新——单条件

<update id="update" parameterType="java.util.List">
            update nt_menu
            <trim prefix="set" suffixOverrides=",">  
    	        <trim prefix="breakfast =case" suffix="end,">  
    	            <foreach collection="list" item="cus">  
    	                <if test="cus.breakfast != null">  
    	                    when menuId=#{cus.menuId} then #{cus.breakfast}  
    	                </if>  
    	            </foreach>  
    	        </trim>  
    	        <trim prefix="lunch =case" suffix="end,">  
    	            <foreach collection="list" item="cus">  
    	                <if test="cus.lunch != null">  
    	                    when menuId=#{cus.menuId} then #{cus.lunch}  
    	                </if>  
    	            </foreach>  
    	        </trim>  
    	        <trim prefix="dinner =case" suffix="end,">  
    	            <foreach collection="list" item="cus">  
    	                <if test="cus.dinner != null">  
    	                    when menuId=#{cus.menuId} then #{cus.dinner}  
    	                </if>  
    	            </foreach>  
    	        </trim>  
    	        <trim prefix="modifier =case" suffix="end,">  
    	            <foreach collection="list" item="cus">  
    	                <if test="cus.modifier != null">  
    	                    when menuId=#{cus.menuId} then #{cus.modifier}  
    	                </if>  
    	            </foreach>  
    	        </trim>  
        	</trim>  
    	    <where>  
    	        <foreach collection="list" separator="or" item="cus">  
    	            menuId=#{cus.menuId}  
    	        </foreach>  
    	    </where>  
        </update>

批量更新——多条件

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0xRUWlhbkxlZQ_size_16_color_FFFFFF_t_70][]

[70]: /images/20220528/26525f6c58324c578f7e9ec3ba099dbf.png
[70 1]: /images/20220528/8bad0931f68243e084a1d94e55477b14.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0xRUWlhbkxlZQ_size_16_color_FFFFFF_t_70]: /images/20220528/7399f74300874768b8153037007f514a.png