Error querying database. Cause: java.lang.IllegalArgumentException: invalid comparison: java.time.LocalDateTime and java.lang.String
<if test="startDate != null and startDate != '' and endDate != null and endDate != '' ">
and creation_time between #{startDate} and #{endDate}
</if>
错误原因:
startDate和startEnd是LocalDateTime类型但是startDate != ''和endDate != ''进行了和字符串进行比较,就会报错,需要将其去掉。
<if test="startDate != null and endDate != null ">
and creation_time between #{startDate} and #{endDate}
</if>