MySQL在xml文件中处理大于号小于号

一, 用转义字符替换 > 和 <。

SELECT * FROM commodity  

                 WHERE 1 = 1 

                 AND createdBy  &lt; = commodity.createdBy  

                 AND updated  &gt;= commodity.updated;

&lt;	<	小于号
&gt;	>	大于号
&amp;	&	和
&apos;	’	单引号
&quot;	"	双引号

二,  

xml格式的不允许出现类似“>”这样的字符，可以使用 < ![ CDATA[     ] ] >  符号进行说明，  写成如下： SupplierCommodityMapper.xml <!--查询商品列表（简易查询）--> < select  id ="findSimple"  resultType ="so.sao.shop.supplier.pojo.vo.SuppCommSearchVo"> SELECT < include  refid ="searchColumns"/> FROM supplier_commodity sc  INNER JOIN ( commodity c  LEFT JOIN comm_brand cb on c.brand_id = cb.id )  on sc.code69 = c.code69 LEFT JOIN comm_measure_spec cms on sc.measure_spec_id = cms.id  LEFT JOIN comm_unit cu on sc.unit_id = cu.id WHERE sc.deleted = 0 AND sc.supplier_id = #{supplierId} < if  test ="@so.sao.shop.supplier.util.Ognl@isNotEmpty(inputvalue)"> AND (sc.code69 = #{inputvalue} OR c.name LIKE CONCAT ('%',#{inputvalue},'%')) </ if> < if  test ="@so.sao.shop.supplier.util.Ognl@isNotEmpty(beginCreateAt) and @so.sao.shop.supplier.util.Ognl@isEmpty(endCreateAt)"> AND Date(sc.created_at)<![CDATA[ >= #{beginCreateAt}]]> </ if> < if  test ="@so.sao.shop.supplier.util.Ognl@isNotEmpty(endCreateAt) and @so.sao.shop.supplier.util.Ognl@isEmpty(beginCreateAt)"> AND Date(sc.created_at)<![CDATA[<= #{endCreateAt}]]> </ if> < if  test ="@so.sao.shop.supplier.util.Ognl@isNotEmpty(beginCreateAt) and @so.sao.shop.supplier.util.Ognl@isNotEmpty(endCreateAt)"> AND Date(sc.created_at) BETWEEN #{beginCreateAt} AND #{endCreateAt} </ if> ORDER BY sc.updated_at DESC </ select >