IBatis 常用XML

 

<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

原文：http://www.cnblogs.com/chencidi/p/4028316.html