Recently, I have used mybatis, and then used less than or equal to, and I used <= directly in XML. As a result, the XML file keeps displaying red errors, as follows:
sum(case when p.pool_year <= '2014' then p.pool_rmb else 0 end) as "one",
It is conjecture that it may be due to special characters, so it was replaced by escaped characters, as follows:
sum(case when p.pool_year <= '2014' then p.pool_rmb else 0 end) as "one",
Record it to prevent errors in the future.
Commonly used escape characters in xml:
•< < less than
•> > Greater than
•& & and
•' 'Single quotes
• "Double Quotes
The above is the escape of mybatis greater than less than that introduced by the editor. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to everyone in time. Thank you very much for your support to Wulin.com website!