mybatis传入值为map的foreach查询

最新推荐文章于 2024-08-05 09:32:09 发布

gaoklongzzz

最新推荐文章于 2024-08-05 09:32:09 发布

阅读量844

点赞数

分类专栏：总结

本文链接：https://blog.csdn.net/a1430490717/article/details/102929932

版权

总结专栏收录该内容

9 篇文章 0 订阅

订阅专栏

controller层：

 public R list(@RequestParam Map<String,Object> map){
        if(map.containsKey("propertyId")&&((String)map.get("propertyId"))!=""){
            if(((String)map.get("propertyId")).contains(",")){
                String[] propertyIdArr=((String)map.get("propertyId")).split(",");
                map.put("propertyId",propertyIdArr);
            }
            else {
                String propertyId = map.get("propertyId").toString();
                String[] array = { propertyId };
                map.put("propertyId", array);
            }
        }
        List<ApplyReleaseDTO> list = applyReleaseService.getList(map);
        return R.ok().put("list", list);

    }

sql语句：

<select id="getList" resultType="io.renren.modules.practice.dto.ApplyReleaseDTO" parameterType="map">
    select ff_apply_release.id,ff_apply_release.property_id propertyId,ff_apply_release.building_id buildingId,ff_apply_release.house_id houseId,ff_apply_release.time_range timeRange,ff_apply_release.price,ff_apply_release.status onlineStatus,
    ff_property.name propertyName,ff_building.code buildingNum,ff_house.name houseNo
    from ff_apply_release
    join ff_property on ff_property.id=ff_apply_release.property_id
    join ff_building on ff_building.id=ff_apply_release.building_id
    join ff_house on ff_house.id=ff_apply_release.house_id
    <where>
    ff_apply_release.is_delete=90
        <if test="propertyId != null and propertyId.length>0">
            and ff_apply_release.property_id IN
            <foreach collection="propertyId" open="(" close=")" item="arr" separator=",">
                #{arr}
            </foreach>
        </if>
    </where>
    </select>