What is the correct format for MyBatis SQL xml to handle less-than and greater-than signs

This article introduces what is the correct format for MyBatis SQL xml to deal with less than sign and greater sign. The content is very detailed. Interested friends can use it for reference. I hope it will be helpful to you.

When we need to process sql statements in xml format, we often use

=, etc., but it is easy to cause errors in xml format, which will lead to background conversion of xml strings to xml document Times errors, resulting in program errors.

Such problems often need to be dealt with in iBatiS or in custom xml programs that deal with sql. In fact, it is very simple. We only need to make the following replacement to avoid the above mistakes:

Original symbol

= &'"replace symbol

= & & apos; "

Wrong xml format:

AND START_DATE > = to_date ('2013-01-01-01) AND START_DATE = to_date (' 2013-01-01-01) AND START_DATE