在 Mybatis 中 如果见到以下表示,不要慌张,她们代表一些特殊字符。
< | < | 小于号 |
> | > | 大于号 |
& | & | 与 |
' | ' | 单引号 |
" | " | 双引号 |
Ex:
<select id="listDevice" resultMap="Map" >
select DISTINCT t.Token,t.Type,t.UserId
from Notific n
left join Provider s on s.Code=n.Receiver
left join User t on t.UserId=s.UserId
where n.Receiver=#{receiver} AND t.Token IS NOT NULL AND t.Token<![CDATA[ <> ]]> ''
</select>
上述中最后的特殊字符即 ‘ ’ ,也可以翻译成
<select id="listDevice" resultMap="Map" >
select DISTINCT t.Token,t.Type,t.UserId
from Notific n
left join Provider s on s.Code=n.Receiver
left join User t on t.UserId=s.UserId
where n.Receiver=#{receiver} AND t.Token IS NOT NULL AND t.Token != '';
</select>