一、修改,批量更新(借助case函数)
<update id="updateNQCode">
UPDATE ${tableName}
<trim prefix="set" suffixOverrides=",">
<trim prefix="dataMap =case" suffix="end;">
<foreach collection="samples" index="index" item="item" >
when dataMap->'$.${field}'=#{item}
then json_replace(dataMap,'$.${field}', #{index} + 1 )
</foreach>
else dataMap
</trim>
</trim>
</update>
二、利用foreach循环map
<update id="updateQCode">
UPDATE ${tableName}
<trim prefix="set" suffixOverrides=",">
<trim prefix="dataMap =case" suffix="end;">
<foreach collection="tags.entrySet()" item="value" index="key">
when dataMap->'$.${field}'= ${key}
then json_replace( dataMap,'$.${field}', #{value})
</foreach>
else dataMap
</trim>
</trim>
</update>