1、大小写转义符
在项目中查询时间段的sql语句(时间类型为datetime或date):
<if test="createdTimeStart != null">
AND a.createdTime >= #{createdTimeStart}
</if>
<if test="createdTimeEnd != null">
AND a.createdTime <= #{createdTimeEnd}
</if>
<小于号 < > 大于号>
2、mybatis部分版本异常invalid comparison: java.util.Date and java.lang.String
严重: Servlet.service() for servlet [spring] in context with path [] threw exception [Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: java