Detailed explanation of Mybatis special character processing

Preface:

Mybatis special character processing, processing of special characters in xml files in Mybatis, here are solutions and examples, you can refer to:

1. Problem description:

When querying, you need to obtain data within the time range, as follows:

<if test="startTime != null" > 
  and l.CREATE_TIME >= #{startTime} 
</if> 
<if test="endTime != null" > 
   and l.CREATE_TIME < #{endTime}  
</if> 

However, in the XML file in Mybatis, the query cannot use the less than sign (<) because it is a start tag and a special character.

2. Solution

In the query, you can avoid special characters by including them in CDATA. This method works for all special characters.

<![CDATA[ 
   
]]> 

Here is an example:

<if test="startTime != null" > 
  <![CDATA[ 
    and l.CREATE_TIME >= #{startTime} 
  ]]> 
</if> 
<if test="endTime != null" > 
  <![CDATA[ 
  and l.CREATE_TIME < #{endTime} 
  ]]> 
</if> 

MyBatis returns the primary key. MyBatis Insert operation returns the primary key:

Thank you for reading, I hope it can help you, thank you for your support of this site!