db2 sql 语句格式

  	<select id="getArcGrant" resultClass="java.lang.String" parameterClass="java.util.HashMap">
			SELECT 
			RESOURCE_CODE as resourceCode
		    FROM TF2M_ARC_GRANT_PROXY g 
			left join TF_PROXY_RELATION p
			on p.AGENT_ID=g.PRINCIPAL_CODE
			WHERE p.PROXY_STATUS='1'
		 <dynamic prepend="and">
			 <isNotEmpty prepend="and" property="staffId">
             	<![CDATA[g.PRINCIPAL_CODE = '$staffId$']]>
             </isNotEmpty>
              <isNotEmpty prepend="and" property="currentTime">
             	<![CDATA[p.PROXY_START_TIME <= #currentTime#]]>
             </isNotEmpty>
              <isNotEmpty prepend="and" property="currentTime">
             	<![CDATA[p.PROXY_END_TIME >= #currentTime#]]>
             </isNotEmpty>
         </dynamic>
	</select>