阅读背景:

mybaties比较大小查询数据

来源:互联网 
<if test="needPublish.beforeDate != null"> <![CDATA[ and DATE_FORMAT(#{needPublish.beforeDate}, '%Y-%m-%d %H:%M:%S') <= DATE_FORMAT(n_create_time, '%Y-%m-%d %H:%M:%S') ]]> </if> <if test="needPublish.timeFlag == 0"> <![CDATA[ and DATE_FORMAT(now(), '%Y-%m-%d %H:%M:%S')<= DATE_FORMAT(end_time, '%Y-%m-%d %H:%M:%S') ]]> </if> <if test="needPublish.timeFlag == 1"> <![CDATA[ and DATE_FORMAT(now(), '%Y-%m-%d %H:%M:%S') > DATE_FORMAT(end_time, '%Y-%m-%d %H:%M:%S') ]]> </if> <if test="needPublish.beforeDate != null"> <![CDA



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: