<select id="check" resultType="java.util.Map">
SELECT
p.address_name AS `name`
FROM
pm_rules_items r
LEFT JOIN pm_mountain_address p ON p.mountain_id = r.mountains_id
<where>
<if test="id!=null">
r.rules_id <> #{id}
</if>
<if test="items!=null">
AND r.mountains_id IN
<foreach collection="items" item="item" open="(" close=")" separator=",">
#{item.mountainsId}
</foreach>
</if>
</where>
</select>
List<Map<String, String>> check(@Param("id") Integer id, @Param("items") List<RulesItemParam> items);
resultMap.removeAll(Collections.singleton(null));
原文:https://www.cnblogs.com/pengyifeng/p/15160697.html