mybatis批量修改

    <update id="updateTotalState" parameterType="java.util.List">
        <foreach collection="list" item="item" index="index" open="" close="" separator=";">
        UPDATE sp_stock
        <set>
          `total_state` = 2
        </set>
        WHERE `id` = #{item}
        </foreach>
    </update>