1.foreach中传入list参数,便利查询
2.贴上错误代码
<if test="searchMap.date != null and searchMap.date != ''">
AND
<foreach collection="searchMap.date" item="item" open="(" separator="or" close=")">
POSITION(#{item} IN other_fee_history)
</foreach>
</if>
因为searchMap.date != '' 造成集合和字符串类型的比较,故报错
3 解决:
将searchMap.date != '' 改成 searchMap.date.size() > 0