MySQL xml if模板写法

           <!-- 验收状态  已签约-->
      <if test='projAcceptanceDateStatus!=null and projAcceptanceDateStatus=="1" '>
        and tp.PROJ_ACCEPTANCE_DATE is not null and tp.PROJ_ACCEPTANCE_DATE!=''
      </if>

      <!-- 	 验收状态 未签约 -->
      <if test='projAcceptanceDateStatus!=null and projAcceptanceDateStatus=="0"'>
        and ( tp.PROJ_ACCEPTANCE_DATE is null or tp.PROJ_ACCEPTANCE_DATE='')
      </if>

      <!-- 签约年份 （起始结束）-->
      <if test="busActContractSignDateYearStart!=null and busActContractSignDateYearStart!=''">
        and date_format( tb.BUS_ACT_CONTRACT_SIGN_DATE, '%Y' ) &gt;= #{busActContractSignDateYearStart}
      </if>
      <if test="busActContractSignDateYearEnd!=null and busActContractSignDateYearEnd!=''">
        and date_format( tb.BUS_ACT_CONTRACT_SIGN_DATE, '%Y' ) &lt;= #{busActContractSignDateYearEnd}
      </if>

参考文章：https://www.cnblogs.com/sxdcgaq8080/p/9443023.html