java - 动态mybatis xml查询

Question

需要有关以下动态查询的帮助:

if country==null OR country != (spain || Peru)
select * from emp where country NOT IN (spain,Peru)
else
select * from emp where country=#{country}

我尝试过类似的方法，但没有帮助:

<when test="country ==null" or country !='spain' or country != 'Peru'">
            AND country NOT IN ('spain','peru')
            </when>
            <otherwise>
            AND country=#{country}
 </otherwise>

即使国家/地区=美国，也始终生成 NOT IN

Answer 1

试试这个test="country == null或country != '西类牙'或country != 'UK' "