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

来源：互联网发布：midas有限元分析软件编辑：程序博客网时间：2024/06/05 13:28

<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')+1or 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')+1or t.DKSJ <![CDATA[ <  ]]>to_date(#{params.endDate,jdbcType=VARCHAR},'yyyy-MM-dd')+1)</if></if></if>

0 0