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

一时失言乱红尘 2022-06-05 05:30 155阅读 0赞

本文转自：http://blog.csdn.net/zheng0518/article/details/10449549

第一种方法：

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

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

附：XML转义字符

第二种方法：

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