先上代码:
- <choose>
- <when test="BEGINTIME != null and BEGINTIME != '' and ENDTIME != null and ENDTIME != ''">
- AND time BETWEEN #{BEGINTIME, jdbcType=VARCHAR} AND #{ENDTIME, jdbcType=VARCHAR}
- </when>
- <when test="BEGINTIME != null and BEGINTIME != ''">
- <![CDATA[ AND time > #{BEGINTIME, jdbcType=TIMESTAMP} ]]>
- </when>
- <when test="ENDTIME != null and ENDTIME != ''">
- <![CDATA[ AND time < #{ENDTIME, jdbcType=TIMESTAMP} ]]>
- </when>
- <otherwise></otherwise>
- </choose>
choose-switch
when-case
otherwise-default