时间段获取的例子
<if test="startDate !=null and startDate !=''">AND tp.create_date >#{startDate}</if>
<if test="endDate !=null and endDate !=''">AND tp.create_date <#{endDate}</if>
或者
<if test="startDate !=null and startDate !=''">AND datediff(day,#{startDate},tp.create_date)>=0</if>
或者
<if test="beginDate != null">
AND JL.TIME <![CDATA[ >= ]]> #{beginDate}
</if>
<if test="endDate != null">
AND JL.TIME <![CDATA[ <= ]]> #{endDate}
</if>
//模糊查询的配置
<if test="account != null">AND A.ACCOUNT LIKE '%'||#{account}||'%' </if>
<if test="startDate !=null and startDate !=''">AND tp.create_date >#{startDate}</if>
<if test="endDate !=null and endDate !=''">AND tp.create_date <#{endDate}</if>
或者
<if test="startDate !=null and startDate !=''">AND datediff(day,#{startDate},tp.create_date)>=0</if>
或者
<if test="beginDate != null">
AND JL.TIME <![CDATA[ >= ]]> #{beginDate}
</if>
<if test="endDate != null">
AND JL.TIME <![CDATA[ <= ]]> #{endDate}
</if>
//模糊查询的配置
<if test="account != null">AND A.ACCOUNT LIKE '%'||#{account}||'%' </if>