Question

mybatis 使用foreach 遇到的问题

<select id="queryDetailByMobile" parameterType="map"
resultType="MessageJobDetail">
SELECT *
FROM message_job_detail m,
(SELECT MOBILE
FROM (SELECT COUNT(MOBILE) AS COUNT, MOBILE
FROM message_job_detail d
WHERE d.SUBMIT_TIME <=
TO_DATE(#{submitDateEnd}, 'yyyy-mm-dd hh24:mi:ss')
AND d.SUBMIT_TIME >=
TO_DATE(#{submitDateStart}, 'yyyy-mm-dd hh24:mi:ss')
GROUP BY MOBILE)
WHERE COUNT > 8
<if test="mobiles!=null and mobiles!=''">
and MOBILE not in
<foreach collection="list" item="mobiles" open="(" separator="," close=")">
#{mobiles}
</foreach>
</if>
) warndetail
WHERE m.MOBILE = warndetail.mobile
AND m.SUBMIT_TIME <=
TO_DATE(#{submitDateEnd}, 'yyyy-mm-dd hh24:mi:ss')

AND m.SUBMIT_TIME >=
TO_DATE(#{submitDateStart}, 'yyyy-mm-dd hh24:mi:ss')
</select>

运行时一直报

Caused by: org.apache.ibatis.mapping.SqlMapperException: The expression 'list' evaluated to a null value.

求解什么问题呢？能解决的话 给高分啊，求高手解答

若以下回答无法解决问题，邀请你更新回答

Answer 1

应该是你传进来的参数的问题

追问

List lists = new ArrayList();
lists.add("1111");
Map paramMap = new HashMap();
paramMap.put("mobiles", lists);