Mybatis.xml中的大于，小于等特殊符号的写法

最新推荐文章于 2024-07-26 14:25:56 发布

lyatf

最新推荐文章于 2024-07-26 14:25:56 发布

阅读量545

点赞数

分类专栏： java 文章标签： java

本文链接：https://blog.csdn.net/sinat_37812248/article/details/103120765

版权

java 专栏收录该内容

15 篇文章 0 订阅

订阅专栏

<	<
<=	<=
>	>
>=	>=
&	&
'	'
"	"

转义

//转义前
<if test="beginTimeA != null">
      o.begin_time > #{beginTimeA}
</if>


//转义后
<if test="beginTimeA != null">
      o.begin_time &gt; #{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 &lt;= 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