<select id="GetInfo">            <![CDATA[select * from vi_WaterStation             ]]>            <dynamic prepend="where">                <isParameterPresent>                          <isNotEqual prepend="and" property="MonitorType">                        <![CDATA[              AID=#AID#                  ]]>                    </isNotEqual >                                <isNotEmpty prepend="and" property="MonitorType" >                        <![CDATA[              AOBJID=#AOBJID#                  ]]>                    </isNotEmpty>                    <isNotEmpty prepend="and" property="AOBJTYPE" >                        <![CDATA[              AOBJTYPE=#AOBJTYPE#                  ]]>                    </isNotEmpty>                 </isParameterPresent>            </dynamic></select>

IBatis 常用XML