invalid comparison: java.util.Arrays$ArrayList and java.lang.String

mybatis报错:invalid comparison: java.util.Arrays$ArrayList and java.lang.String

传入参数为数组判断时当字符串处理了


 <if test="operationNo!=''">
                and o.operation_no in
                <foreach collection="operationNo" item="operationNo" separator="," open="(" close=")">
                    #{operationNo,jdbcType=VARCHAR}
                </foreach>
 </if>

正确写法

   <if test="operationNo!=null">
                and o.operation_no in
                <foreach collection="operationNo" item="operationNo" separator="," open="(" close=")">
                    #{operationNo,jdbcType=VARCHAR}
                </foreach>
 </if>

 

 
posted @ 2020-12-16 08:57  海绵-宝宝  阅读(172)  评论(0编辑  收藏  举报