2021-02-03 mybatis-plus中使用list查询

mapper

/**
     * 获取全局检索列表数据
     * @param globalSearchDTO
     * @return
     */
    List<GlobalSearchDTO> selectGlobalSearchDTOList(@Param("globalSearchDTO") GlobalSearchDTO globalSearchDTO);

xml

 SELECT
            ...
          <where>
            <if test="globalSearchDTO.floorList != null and globalSearchDTO.floorList.size > 0 ">
                AND s.biz_floor_id in
                <foreach item="item" collection="globalSearchDTO.floorList" separator="," open="(" close=")" index="">
                    #{item}
                </foreach>
            </if>
          </where>
...

实体类

public class GlobalSearchDTO implements Serializable {
...   
    @ApiModelProperty(value = "楼层(多)")
    private List<Integer> floorList = new CopyOnWriteArrayList<>();
...
}