<choose>
<when test="partyStatus != null and partyStatus == '0'.toString()">
and cpmr.status = '-1' and cpmr.status = '0'
</when>
<when test="partyStatus != null and partyStatus == '1'.toString()">
and cpmr.status = '1'
</when>
</choose>
可用.tiString()
也可以换成双引号
<choose>
<when test='partyStatus != null and partyStatus == "0"'>
and cpmr.status = '-1' and cpmr.status = '0'
</when>
<when test='partyStatus != null and partyStatus == "1"'>
and cpmr.status = '1'
</when>
</choose>
具体可参考这个文档:mysql判断 单字符 不生效 if标签_圣英神士的博客-CSDN博客
case when的使用
case caur.status_audit
WHEN '-1' THEN '审核驳回' #如果caur.status_audit里面的值是-1那么就给他赋值审核驳回
WHEN '0' THEN '待审核'
WHEN '1' THEN '审核通过'
end status_audit,
#还有一种写法
case
WHEN cpmr.status = '-1' THEN '未认证'
WHEN cpmr.status = '0' THEN '未认证'
WHEN cpmr.status = '1' THEN '已认证'
WHEN cpmr.status is null THEN '未认证'
END psrtyStatus,