How to use escape characters in MyBatis?

5 months ago

1 minute

In MyBatis, if special symbols or reserved words (such as $, #, etc.) need to be used in SQL statements, escape characters need to be used for escaping. In MyBatis, #{} is used to represent parameter placeholders, and $ represents text placeholders. If the $ symbol needs to be used in the SQL statement, the escape character \ needs to be used for escaping, like \$. Example code is as follows:

SELECT * FROM user WHERE name = #{name} AND age > \${age}

In the example above, #{name} uses the #{} placeholder, while ${age} is escaped using $. This allows handling special characters and reserved words correctly in MyBatis.