<if test="begintime != null and begintime != ''">
and DATE_FORMAT(public_time,'%Y-%m-%d %H:%i:%S') >
DATE_FORMAT(#{begintime},'%Y-%m-%d %H:%i:%S')
</if>
<if test="endtime != null and endtime != ''">
and DATE_FORMAT(public_time,'%Y-%m-%d %H:%i:%S') <
DATE_FORMAT(#{endtime},'%Y-%m-%d %H:%i:%S')
</if>
<if test="begintime != null and begintime != ''">
and DATE_FORMAT(public_time,'%Y-%m-%d %H:%i:%S') >
DATE_FORMAT(#{begintime},'%Y-%m-%d %H:%i:%S')
</if>
<if test="endtime != null and endtime != ''">
and DATE_FORMAT(public_time,'%Y-%m-%d %H:%i:%S') <
DATE_FORMAT(#{endtime},'%Y-%m-%d %H:%i:%S')
</if>
xml中的大于小于号 > < 需要特殊处理
原符号 | < | <= | > | >= | & | ' | " |
替换符号 | < | <= | > | >= | & | ' | " |
LT GT