MyBatis handles greater than, less than, greater than or equal to, and less than or equal to in sql-Tech Notes

MyBatis handles greater than, less than, greater than or equal to, and less than or equal to in sql

Technical otaku 2022-01-05

The reason for the problem:

Since the SQL of mybatis is configured in the mapper.xml file, all xml parsing <,> ,<= ,>= will go wrong, so how to solve it?

-------------------------------------------------- -Solution----------------------------------------------- -------------------------------

To escape:

Original symbol	<	<=	>	>=	&	'	"
Replacement symbol	<	<=	>	>=	&	'	"

eg:

Note: between does not include equals

Sought technology together