实体类代码:
public class AlarmConditionDTO {
private List<String> orgIds;
private List<String> tagIds;
private String alertType;
private Long startTime;
private Long endTime;
private int pageNum;
private int pageSize;
private String deviceName;
private String searchConditionTime;
}
mapper,dao层:
List<Map<String,String>> selectDeviceCountByCondition(AlarmConditionDTO alarmConditionDTO);
错误写法上图解释:
在xml中想遍历list<String>这个值,写成
<foreach collection="orgIds" open="(" close=")" separator="," item="item">
#{orgIds}
</foreach>
这样会报错,list类型参数无法正确解析。
解决办法有两种:
第一:
<select id="selectDeviceCountByCondition" resultType="java.util.Map">
SELECT
device_type deviceType,count(device_type) count
FROM
(select DISTINCT obj_id obj_id from md_tag_target_relation_device where 1=1
<if test="tagIds != null and tagIds.size()>0">
and tag_id IN
<foreach collection="tagIds" index="index" open="(" close=")" separator="," item="item">
#{tagIds[${index}],jdbcType=VARCHAR}
</foreach>
</if>
) td
LEFT JOIN
md_resource_device d ON td.obj_id = d.uuid
where 1=1 and device_name is not null
<if test="orgIds != null and orgIds.size()>0">
and d.region_code IN
<foreach collection="orgIds" index="index" open="(" close=")" separator="," item="item">
#{orgIds[${index}],jdbcType=VARCHAR}
</foreach>
</if>
group by
d.device_type
</select>
这中写法意思是,取这个数组中的每一个,因为字段是List<String>。
第二种:
修改mapper接口方法的参数,增加注解 @Param("aa") AlarmConditionDTO alarmConditionDTO
param中名字随便起,这里起aa,xml中写:
<if test="aa.orgIds!= null and aa.orgIds.size()>0">
and d.region_code IN
<foreach collection="aa.orgIds" index="index" open="(" close=")" separator="," item="item">
#{item}
</foreach>
</if>
转载作者:楼兰King
转载链接:https://www.jianshu.com/p/4b9fbc047d56