两个list合并并去重AND mabatis中foreach的简单用法

        List<Integer> collect = Stream.of(list1, list2)
                .flatMap(Collection::stream)
                .distinct()
                .collect(Collectors.toList());

list转为字节流并进行distinct 去重

<select id="selectAllMenuIdButNotEmployParentIdEqualsZero" resultType="java.lang.Integer"
            parameterType="java.util.List">
        select parent_id from sys_menu where parent_id!=0 and menu_id in
        <foreach collection="menuIds" index="index" item="item"
                 open="("  separator="," close=")">
            #{item}
        </foreach>
    </select>

包含了foreach的简单用法

    <insert id="insertMenuIds">
        insert into sys_role_menu (role_id,menu_id) values
        <foreach collection="MenuIds" index="index" item="item" separator=",">
            (#{roleId},#{item})
        </foreach>
    </insert>

上面为insert中 foreach的用法 separator代表删除最后一个,号