mybatis在xml文件中处理大于号小于号的方法

迷南。 2022-06-07 05:10 140阅读 0赞

第一种方法：

用了转义字符把>和<替换掉，然后就没有问题了。

SELECT \* FROM test WHERE 1 = 1 AND start\_date <= CURRENT\_DATE AND end\_date >= CURRENT\_DATE

附：XML转义字符

第二种方法：

<table style="font-family:Arial; font-size:14px; line-height:26px; widows:1; margin:0px; padding:0px; color:rgb(50,62,50); table-layout:fixed; width:954px"> 
 <tbody> 
  <tr> 
   <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word; word-break:break-all; visibility:visible!important; zoom:1!important"> 
    <div style="font-family:Arial; word-wrap:break-word; word-break:break-all; overflow:hidden; visibility:visible!important; zoom:1!important; position:relative!important"> 
     <p style="margin-top:0px; margin-bottom:5px; padding-top:0px; padding-bottom:0px; border:0px; list-style:none; word-wrap:normal; word-break:normal; line-height:normal"> <span style="font-size:14px">因为这个是xml格式的，所以不允许出现类似“&gt;”这样的字符，但是都可以使用&lt;![CDATA[ ]]&gt;符号进行说明，将此类符号不进行解析&nbsp;<br> 你的可以写成这个：&nbsp;<br> </span></p> 
     <div style="word-wrap:break-word; word-break:break-all; line-height:normal; visibility:visible!important; zoom:1!important"> 
      <div style="word-wrap:break-word; word-break:break-all; visibility:visible!important; zoom:1!important"> 
       <div style="word-wrap:break-word; word-break:break-all; visibility:visible!important; zoom:1!important"> 
        <span style="font-size:14px">mapper文件示例代码</span> 
       </div> 
      </div> 
      <div style="font-family:Consolas,&quot;Courier New&quot;,Courier,mono,serif; width:940.5px; overflow-x:auto; overflow-y:hidden; padding-top:1px; position:relative; background-color:rgb(231,229,220); margin:18px 0px!important"> 
       <div style="padding-left:45px"> 
        <div style="padding:3px 8px 10px 10px; font-size:9px; line-height:normal; font-family:Verdana,Geneva,Arial,Helvetica,sans-serif; color:silver; border-left:3px solid rgb(108,226,108); border-right:1px solid rgb(231,229,220); background-color:rgb(248,248,248)"> 
         <strong>[html]</strong> &nbsp; 
         <a href="http://blog.csdn.net/zheng0518/article/details/10449549#" title="view plain" style="color:rgb(160,160,160); border:none; padding:1px; margin:0px 10px 0px 0px; font-size:9px; display:inline-block; width:16px; height:16px; text-indent:-2000px; background-color:inherit" rel="nofollow">view plain</a> &nbsp; 
         <a href="http://blog.csdn.net/zheng0518/article/details/10449549#" title="copy" style="color:rgb(160,160,160); border:none; padding:1px; margin:0px 10px 0px 0px; font-size:9px; display:inline-block; width:16px; height:16px; text-indent:-2000px; background-color:inherit" rel="nofollow">copy</a> 
         <div style="position:absolute; left:401px; top:881px; width:18px; height:18px; z-index:99"> 
         </div> 
        </div> 
       </div> 
       <ol style="padding:0px; border-style:none solid none none; border-right-width:1px; border-right-color:rgb(231,229,220); list-style-position:initial; color:rgb(92,92,92); background-color:rgb(255,255,255); margin:0px 0px 1px 45px!important"> 
        <li style="border-style:none none none solid; border-left-width:3px; border-left-color:rgb(108,226,108); list-style:decimal-leading-zero outside; color:inherit; line-height:18px; margin:0px!important; padding:0px 3px 0px 10px!important"> <span style="margin:0px; padding:0px; border:none; color:black; background-color:inherit"><span style="margin:0px; padding:0px; border:none; color:rgb(255,20,147); background-color:inherit">&lt;![CDATA[&nbsp;when&nbsp;min(starttime)&lt;='12:00'&nbsp;and&nbsp;max(endtime)&lt;='12:00'&nbsp;]]&gt;</span><span style="margin:0px; padding:0px; border:none; background-color:inherit">&nbsp; &nbsp; &nbsp;</span></span></li> 
       </ol> 
      </div> 
     </div> 
    </div> </td> 
  </tr> 
 </tbody> 
</table>