ibatis 动态SQL相关

  <dynamic>

              <isNotEqual prepend="AND" property="accountType" compareValue="2">

                r.shop_keeper_id = #shopKeeperId#

               </isNotEqual>

              <isNotEmpty prepend="and" property="campaignId">

                  r.campaign_id=#campaignId#

              </isNotEmpty>

              <isNotNull prepend="and" property="campaignList">

                   r.campaign_id in

                    <iterate property="campaignList" open="("  close=")" conjunction=",">

                             #campaignList[].campaignId#

                    </iterate>

              </isNotNull>

  </dynamic>    

 与isNot相对的is可以相反的替换以上逻辑。