1、trim
2、where 1 = 1
where 1=1
<if test="beginDate !=null and beginDate !='' ">
and to_date(to_char(t.rkrqdate,'yyyy-mm-dd'),'yyyy-mm-dd') <![CDATA[>=]]> to_date(#{beginDate},'yyyy-mm-dd')
</if>
转载于:https://www.cnblogs.com/ssbydk/p/9550284.html
相关资源：MyBatis拦截器分页与动态修改SQL及其参数值
