date类型参数绑定:
报错
### Error querying database. Cause: java.lang.IllegalArgumentException: invalid comparison: java.util.Date and java.lang.String
### Cause: java.lang.IllegalArgumentException: invalid comparison: java.util.Date and java.lang.String
<if test="theLastTime != null and theLastTime != ''" >
and date(jb_order.update_time) <=date( #{theLastTime})
</if>
把mapper中的sql改为:
<if test="theLastTime != null" >
and jb_order.update_time <= #{theLastTime}
</if>