MyBatis #{} and ${} in the Mapper.xml configuration file

#{} represents a placeholder symbol ,through#{}can achievePreparedStatementset a value in the placeholderautomatically madeJavaTypes andJDBCType Conversions。 #{}can beeffectively preventSqlinjected. #{}you can receive a simple type value orPojoProperty Value. ifParameterTypeTransfer a single simple type value,#{} in parentheses can be valueor other name.

${} is a concatenation of SQL strings , through ${} can be parametertype The incoming content is spliced in SQL without a jdbc type conversion , ${} can receive simple type values or Pojo property value, if ParameterType Transfer a single simple type value, ${} can only be value in parentheses .

MyBatis #{} and ${} in the Mapper.xml configuration file