MyBatis processing of special symbols in XML files (greater-than-number less-than-number methods)

should be used in SQL for business requirements >=,<=, such as symbols, think of mybatis XML write discovery also need to do, especially the following method:

The first: replace > and < with escape characters

SELECT * FROM Test WHERE 1 = 1 and start_date &lt;= current_date and end_date &gt;= current_date

Attachment: XML escape characters

&lt;	&nbs P                    <	less than
&gt;	>	Greater-than sign
&amp;	&	And
&apos;	’	Single quotation mark
&quot;	"	Double quotes

The second type:

Because this is in XML format, characters such as ">" are not allowed, but you can use the <![ cdata[]]> symbols are described, such symbols are not parsed   Your can write this:   Mapper File Sample code:  <![ Cdata[ when min (starttime) <= ' 12:00 '  and max (endtime) <= ' 12:00 '  ]]>