动态sql

<select id="queryMarketingInfoList" parameterClass="java.util.HashMap" resultMap="queryMarketingInfoListForResult">
        <isEqual property="MarketingType" compareValue="1">
        SELECT D.USERNAME,D.MOBILEPHONE,TO_CHAR(AC.CREATETIME,'yyyy-MM-dd') createTime,
        D.REFERRNO,AC.ACSTATE,'' as referrUserName,'' as referrMobilePhone
        FROM ecusr d,ecacct ac
                        WHERE d.REFERRNO is not null  
                        AND d.CIFSEQ = ac.CIFSEQ
                        AND to_char(d.CREATETIME,'yyyy-mm-dd') &gt;= #Begindate#
                        AND to_char(d.CREATETIME,'yyyy-mm-dd') &lt;= #Enddate#
                        <isNotEmpty prepend=" AND " property="RefferType">d.REFFERTYPE=#RefferType#</isNotEmpty>
        </isEqual>
    </select>