Mybatis 用于查询前端输出过来的时间段内的内容写法
<if test="beginDate != null"> and DATE(o.receiving_time) >= #{beginDate,jdbcType=VARCHAR} </if> <if test="endDate != null"> and DATE(o.receiving_time) <= #{endDate,jdbcType=VARCHAR} </if>
<if test="beginDate != null"> and DATE(o.receiving_time) >= #{beginDate,jdbcType=VARCHAR} </if> <if test="endDate != null"> and DATE(o.receiving_time) <= #{endDate,jdbcType=VARCHAR} </if>