< | < |
<= | <= |
> | > |
>= | >= |
& | & |
' | ' |
" | " |
转义
//转义前
<if test="beginTimeA != null">
o.begin_time > #{beginTimeA}
</if>
//转义后
<if test="beginTimeA != null">
o.begin_time > #{beginTimeA}
</if>
//转义前
select f.* from hw_consumer c LEFT JOIN hw_user_formid f ON f.openid = c.openid WHERE c.id = #{id} AND f.`status` = 0 and f.frequency <= 3 GROUP BY create_date LIMIT 1
//转义后
select f.* from hw_consumer c LEFT JOIN hw_user_formid f ON f.openid = c.openid WHERE c.id = #{id} AND f.`status` = 0 and f.frequency <= 3 GROUP BY create_date LIMIT 1
CDATA
//使用前
<if test="beginTimeA != null">
o.begin_time > #{beginTimeA}
</if>
//使用后
<if test="beginTimeA != null">
<![CDATA[
o.begin_time > #{beginTimeA}
]]>
</if>
//使用前
select f.* from hw_consumer c LEFT JOIN hw_user_formid f ON f.openid = c.openid WHERE c.id = #{id} AND f.`status` = 0 and f.frequency <= 3 GROUP BY create_date LIMIT 1
//使用后
select f.* from hw_consumer c LEFT JOIN hw_user_formid f ON f.openid = c.openid WHERE c.id = #{id} AND f.`status` = 0 and f.frequency <![CDATA[ <= ]]> 3 GROUP BY create_date LIMIT 1