2019-08-13 1 分钟读完 (大约 112 个字)

mybatis

batch update

批量更新
eg:

update table_post p
inner join (
    SELECT u.user_id,u.post_count
    FROM table_user u
) as c_u on p.user_id = c_u.user_id
set u.post_count=c_u.post_count;

mapper中batch update写法：

<update id="batchUpdate"  parameterType="java.util.List">
    <foreach collection="list" item="item" index="index" open="" close="" separator=";">
        update test
            <set>
                test=${item.test}+1
            </set>
        where id = ${item.id}
    </foreach>
</update>