mybitse 批量更新

  <update id="updateSortbyid" parameterType="java.util.List">
    update 表
    set  sort=
    <foreach collection="list" item="item" index="index"
        separator=" " open="case id" close="end">
        when #{item.id} then #{item.sort}
    </foreach>
    where id in
    <foreach collection="list" index="index" item="item"
        separator="," open="(" close=")">
        #{item.id}
    </foreach>
</update>




   /**
* @param list
* @return
*/
Integer updateSortbyid(@Param("list") List<Course> list);