dynamic mybatis xml query

Question

Need help with following dynamic query:

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

I tried something like this but its not helping:

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

Always generate NOT IN even if country=us

Code_Ninja · Accepted Answer · 2018-08-16 05:04:53Z

1

try this test="country == null or country != 'spain' or country != 'UK' "

edited Aug 16, 2018 at 5:04

Code_Ninja

1,8771 gold badge19 silver badges39 bronze badges

answered Aug 16, 2018 at 3:12

Luke Luo

243 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Tnadev Over a year ago

always generating NOT IN

CheolHoJung · Accepted Answer · 2018-08-16 05:27:40Z

0

Use double quotation to string.

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

edited Aug 16, 2018 at 5:27

answered Aug 16, 2018 at 4:24

CheolHoJung

112 bronze badges

Comments

Tnadev · Accepted Answer · 2018-08-16 05:32:54Z

0

<when test="country !='spain' and country != 'uk'">

wrong condition, expected and instead of or

answered Aug 16, 2018 at 5:32

Tnadev

10.2k7 gold badges68 silver badges74 bronze badges

Collectives™ on Stack Overflow

dynamic mybatis xml query

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related