Error querying database. Cause: java.lang.IllegalArgumentException: invalid comparison: java.util.Date and java.lang.String
<select id="test" resultType="java.util.Date">
<if test="date != null and date !=''" >
SELECT
#{date} AS now
FROM dual
</if>
<if test=" date== null">
SELECT
date_add(now(), INTERVAL 1 DAY_HOUR) AS now
FROM dual
</if>
</select>
因为本身判断 != null 就不应该再判断 !=’’