Mybatis之动态sql语句中时间判断（if）的应用

<if test='params.dkbz ==null or params.dkbz ==""'>
<if test='params.startDate !=null and params.startDate !=""'>
   and (t.createtime<![CDATA[ >=  ]]>to_date(#{params.startDate,jdbcType=VARCHAR},'yyyy-MM-dd')
    or t.DKSJ<![CDATA[ >=  ]]>to_date(#{params.startDate,jdbcType=VARCHAR},'yyyy-MM-dd')
   )
</if> 
<if test='params.endDate !=null and params.endDate !=""'>
and (t.createtime <![CDATA[ <  ]]>to_date(#{params.endDate,jdbcType=VARCHAR},'yyyy-MM-dd')+1
or t.DKSJ <![CDATA[ <  ]]>to_date(#{params.endDate,jdbcType=VARCHAR},'yyyy-MM-dd')+1
)
</if> 
</if>
<if test='params.dkbz !=null and params.dkbz !=""'>
and t.dkbz = #{params.dkbz}
<if test='params.dkbz =="Y"'>
<if test='params.startDate !=null and params.startDate !=""'>
   and t.DKSJ<![CDATA[ >=  ]]>to_date(#{params.startDate,jdbcType=VARCHAR},'yyyy-MM-dd')
</if> 
<if test='params.endDate !=null and params.endDate !=""'>
and t.DKSJ <![CDATA[ <  ]]>to_date(#{params.endDate,jdbcType=VARCHAR},'yyyy-MM-dd')+1
</if> 
</if>
<if test='params.dkbz =="N"'>
<if test='params.startDate !=null and params.startDate !=""'>
   and (t.createtime<![CDATA[ >=  ]]>to_date(#{params.startDate,jdbcType=VARCHAR},'yyyy-MM-dd')
    or t.DKSJ<![CDATA[ >=  ]]>to_date(#{params.startDate,jdbcType=VARCHAR},'yyyy-MM-dd')
   )
</if> 
<if test='params.endDate !=null and params.endDate !=""'>
and (t.createtime <![CDATA[ <  ]]>to_date(#{params.endDate,jdbcType=VARCHAR},'yyyy-MM-dd')+1
or t.DKSJ <![CDATA[ <  ]]>to_date(#{params.endDate,jdbcType=VARCHAR},'yyyy-MM-dd')+1
)
</if>
</if>
</if>