ibatisand和or联合查询

最近遇到拼接ibatis中的sql语句的问题，想要得到的sql如下形式：

select * from table where xxx = "xxx" and (xxx="xxx" or xx1="xx1")

开始对于括号怎么加也确实不太明白，后面参考别人的博客

http://lyfei022.blog.163.com/blog/static/82558312009313104138320/才改正确

 

<select id="condition">

        <![CDATA[

select * from table where 1=1

]]>

        <dynamic prepend="and">
      <isNotEmpty prepend="and" property="starttime">
       <![CDATA[    starttime >= #starttime# ]]>
      </isNotEmpty>
      <isNotEmpty prepend="and" property="endtime">
       <![CDATA[    starttime <= #endtime# ]]>
      </isNotEmpty>
      <isNotEmpty prepend="and" property="rentcompany">
       <![CDATA[    rentcompany like '%$rentcompany$%' ]]>
      </isNotEmpty>
     </dynamic>
     <dynamic prepend="and" open="(" close=")">
      <isNotNull prepend="or" property="bilkcar">
       <![CDATA[    bilkcar = 1 ]]>
      </isNotNull>
      <isNotNull prepend="or" property="guarantycar">
       <![CDATA[    guarantycar = 1 ]]>
      </isNotNull>
      <isNotNull prepend="or" property="filchpart">
       <![CDATA[    filchpart = 1 ]]>
      </isNotNull>
      <isNotNull prepend="or" property="causetrouble">
       <![CDATA[    causetrouble = 1 ]]>
      </isNotNull>
      <isNotNull prepend="or" property="nohandle">
       <![CDATA[    nohandle = 1 ]]>
      </isNotNull>
      <isNotNull prepend="or" property="inarrears">
       <![CDATA[    inarrears = 1 ]]>
      </isNotNull>
     </dynamic>
    </select>

 

<dynamic prepend="and">这个and不能少