update批量根据条件更新

	<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);

批量根据条件更新