今天在做一个多选操作时后台sql老是报错,但是查看sql又没错,后来发现是判断条件写的有问题!
之前的sql
<if test="currencyList != null and currencyList != ''">
and CURRENCY in
<foreach collection="currencyList" item="valueList" open="(" close=")" separator=",">
#{valueList}
</foreach>
</if>
之后的sql
<if test="currencyList != null and currencyList.size > 0">
and CURRENCY in
<foreach collection="currencyList" item="valueList" open="(" close=")" separator=",">
#{valueList}
</foreach>
</if>
因为该字段的类型为集合,所以如果使用
currencyList != ''
来进行判断,等于是让一个集合和String类型去比较,不同类型之间进行比较就会报错。
所以将条件判断改为
currencyList.size > 0 即可!