阅读背景:

浅谈 mybaties 的 表达式(if 或 choose...when) 判断(String,Integer,Boolean)的一些坑_scos_sxb的博客

来源:互联网 

最近遇到了mybaties的一些坑如下

示例mybatis语句

select * from test1
<where>
    <choose>
        <when test='name!=null and name=="l"'>
            name = '李四'
        </when>
        <when test="name!=null and name=='z'">
            name = '张三'
        </when>
        <when test='name!=null and name=="ls"'>
            name = '李四1'
        </when>
        <when test="name!=null and name=='zs'">
            name = '张三1'
        </when>
    </choose>
    <choose>
        <when test="age!=null and age == 1">
            and age = 1
        </when>
        <when test="age!=null and age =='2'">
            and age = 2
        </when>
        <when test="age!=null and age =='03'">
            and age = 3
        </when>
        <when test="age!=null and age =='10'">
            and age = 10
        </when>
        <when test="age!=null and age =='a'">
            and age = 97
        </when>
        <when test='age!=null and age =="20"'>
            and age = 20
        </when>
        <when test='age!=null and age =="4"'>
            and age = 4
        </when>
    </choose>
    <choose>
        <when test="sex!=null and sex==false">
            and age = 0
        </when>
        <when test="sex!=null and sex=='true'">
            and age =-9
        </when>
    </choose>

</where>select * fr



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: