在xml中的判断条件不生效的问题

[Woshizz]

<if test="query.tenantId != null and query.tenantId != '' and query.tenantId != '0'">
                AND tenant_id = #{query.tenantId}
            </if>

当tenantId ="0"时判断条件为true 会加上这个查询条件。当吧判断条件写成

<if test="query.tenantId != null and query.tenantId != '' and query.tenantId != 0">
                AND tenant_id = #{query.tenantId}
            </if>

时判断条件为false 不会加上这个判断条件

[harawata]

Hello @Woshizz ,

If the type of query.tenantId is String, you have to use double quotes. i.e.

<if test='name != null and name != "" and name != "0"'>

In OGNL, a character enclosed in single quotes (e.g. '0') is recognized as a char, so query.tenantId != '0' will always be true.

---

If this is not what you mean, please provide a test case or small demo project with assertions.

[lidu-collect]

简单来说'0'是Character类型，“0”是String，0是Integer。mybatis源码中会对比较的值转换成double再比较，Stirng类型的转换是Double.parseDouble(s)，Character类型的是(double)(Character)value Character被转为double会被转为ascii码