请教ibatis中多条件查询！

Question

<!--      -->
<select id="selectAllAgentbooksbypage" resultClass="Agentbooks" parameterClass="java.util.Map">  
          select * from Agentbooks 
          <dynamic prepend="WHERE">               
<isParameterPresent>
     <isEqual prepend="AND" property="addtime" >
         addtime between #stime# and #etime#
     </isEqual>
</isParameterPresent>               
                <isNotEmpty prepend="AND" property="agprovince">  
                      agprovince=#agprovince# 
                </isNotEmpty>  
<isNotEmpty prepend="AND" property="agcity" >
 agcity=#agcity#
</isNotEmpty>
<isNotEmpty prepend="AND" property="probigtype">
 probigtype=#probigtype#
</isNotEmpty>
                <isNotEmpty prepend="AND" property="proname">  
                      (proname like '%$proname$%')   
                </isNotEmpty>  
         order by addtime desc limit #index#,#pagesize# 
             </dynamic>
         </select>  在配置： <isParameterPresent>
     <isEqual prepend="AND" property="addtime" >
         addtime between #stime# and #etime#
     </isEqual>
</isParameterPresent>               
时出了问题！
请问各位高手该如何更改？

Answer 1

property="addtime"要和#之间的占位符对应
2个参数需要定义一个参数类
建议between改为>=和<

Answer 2

<select id="getPageRecord" parameterClass="RequestMapping"
resultClass="ResultMapping">
<![CDATA[
    select
      a.ai_id,
      a.ai_code,
      a.ai_name,
      a.ai_price,
      a.ai_amount,
      a.ai_unit,
      a.ai_usamount,
      a.ai_isbuy,
      a.ai_re ,
      a.ac_id,
      b.ac_name
      from bs_assets_info a
      inner join  bs_assets_category b  on b.ac_id=a.ac_id
          ]]>
<dynamic prepend="where">
<isNotEmpty prepend="and" property="ai_name">
<![CDATA[ a.ai_name like concat('%',#ai_name#,'%')]]>
</isNotEmpty>
<isNotEmpty prepend="and" property="ai_code">
<![CDATA[ a.ai_code = #ai_code# ]]>
</isNotEmpty>
<isNotEmpty prepend="and" property="ac_id">
<![CDATA[ a.ac_id = #ac_id#]]>
</isNotEmpty>
</dynamic>
<dynamic prepend="order by">
<isNotEmpty property="fieldOrder">
<![CDATA[ $fieldOrder$ ]]></isNotEmpty>
</dynamic> <![CDATA[ $foot$ ]]>
</select>我看到的一个动态查询例子

Answer 3

应该这样可以： <select id="selectMyAgentbooksbypage" resultClass="Agentbooks" parameterClass="java.util.Map">
select * from Agentbooks 
                <dynamic prepend="WHERE">  
                <isNotEmpty prepend="AND" property="stime">
                 addtime >= #stime#
                </isNotEmpty >
                <isNotEmpty prepend="AND" property="etime">
                <![CDATA[
                 addtime < #etime#
                ]]>
                </isNotEmpty >
                <isNotNull prepend="AND">
                 stat = 1
                </isNotNull >
                <isNotNull prepend="AND">
                 auditing=0
                </isNotNull >
                <isNotEmpty prepend="AND" property="userid">
  userid = #userid#
                 </isNotEmpty >
</dynamic>
order by #orderby# #rule# limit #index#,#pagesize#
</select>