根据日期区间查询sql

select  FINA_ID                 AS finaId,
        START_DATE              AS startDate,
        END_DATE                AS endDate,
        REMIND_DAYS             AS remindDays       
from t09_zj_fina_prod_info fina
where fina.VALID_STATUS = "1"
<if test="startDate != null and endDate == null" >
    and fina.START_DATE &gt;= #{beginDate}
    //区间[startDate,+无穷]
</if>
<if test="startDate == null and endDate != null">
    and fina.END_DATE &lt;= #{finishDate}
    //区间[负无穷，endDate]
</if>
<if test="startDate != null and endDate != null">
    and fina.START_DATE &gt;= #{beginDate} and fina.END_DATE &lt;= #{finishDate}
    //[startDate,endDate]
</if>