方式一:(没有定时器,比较时间来判断活动状态)
<![CDATA[ and NOW()< t.startDate ]]>
<![CDATA[ and NOW() >= t.startDate and NOW() <= t.endDate ]]>
<![CDATA[ and NOW()>t.endDate ]]>
方式二:(用定时器更新状态字段,然后直接比较)
<if test="activityStatus != null and activityStatus != '' ">
t.activityStatus = activityStatus
</if>