<update id="updateOrgPath">
update t_h_org set
org_path =
<foreach collection="list" item="org_code" index="index" separator=" " open="case org_code" close="end">
when #{org_code} then CONCAT(#{orgPath},',',id)
</foreach>
,
update_date = now()
where org_code in
<foreach item="item" index="index" collection="list" open="(" separator="," close=")">
#{item}
</foreach>
</update>
void updateOrgPath(@Param("orgPath") String orgPath, @Param("list") List<String> list);
批量根据条件更新