iBATIS问题，动态添加字段的问题？请大家帮忙

Question

select
        IAdId,
SCityCode,
SRegUserName,
SExtendTypeCode,
SParentTypeCode,
    SAdTitle,
    SAdKeyword,
    SAdDesc,
    SAdPicture,
SAdPicture2,
SAdOrganize,
    SAdLinkMan,
    SAdAddress,
    SAdRoute,
    SAdEmail,
    SAdPhone,
    SAdFax,
    SAdWebSite,
SAdEffiDate,
    SAdEditDate,
    IAdFlag
  from TADVERTISEMENT
  where IAdFlag=2
  <dynamic prepend="AND">     
<isNotEmpty prepend="AND" property="SAdTitle">
  (TADVERTISEMENT.SAdTitle like '%$SAdTitle$%')
</isNotEmpty>
<isNotEmpty prepend="AND" property="SParentTypeCode">
  (TADVERTISEMENT.SParentTypeCode=#SParentTypeCode#)
</isNotEmpty>
<isNotEmpty prepend="AND" property="SExtendTypeCode">
  (TADVERTISEMENT.SExtendTypeCode=#SExtendTypeCode#)
</isNotEmpty>
  </dynamic> 
  order by SAdEditDate desc
</select><resultMap class="adType" id="adTypeResult">
<result property="IAdId" column="IAdId"/>
<result property="SCityCode" column="SCityCode"/>
<result property="SRegUserName" column="SRegUserName"/>
<result property="SExtendTypeCode" column="SExtendTypeCode"/>
<result property="SParentTypeCode" column="SParentTypeCode"/>
<result property="SAdTitle" column="SAdTitle"/>
<result property="SAdKeyword" column="SAdKeyword"/>
<result property="SAdDesc" column="SAdDesc"/>
<result property="SAdPicture" column="SAdPicture"/>
<result property="SAdPicture2" column="SAdPicture2"/>
<result property="SAdOrganize" column="SAdOrganize"/>
<result property="SAdLinkMan" column="SAdLinkMan"/>
<result property="SAdAddress" column="SAdAddress"/>
<result property="SAdRoute" column="SAdRoute"/>
<result property="SAdEmail" column="SAdEmail"/>
<result property="SAdPhone" column="SAdPhone"/>
<result property="SAdFax" column="SAdFax"/>
<result property="SAdWebSite" column="SAdWebSite"/>
<result property="SAdEffiDate" column="SAdEffiDate"/>
<result property="SAdEditDate" column="SAdEditDate"/>
<result property="IAdFlag" column="IAdFlag"/>
</resultMap>

Answer 1

<select id="getAdTypeListByAdmin" resultMap="adTypeResult" parameterClass="adType">
select
        IAdId,
SCityCode,
SRegUserName,
SExtendTypeCode,
SParentTypeCode,
    SAdTitle,
    SAdKeyword,
    SAdDesc,
    SAdPicture,
SAdPicture2,
SAdOrganize,
    SAdLinkMan,
    SAdAddress,
    SAdRoute,
    SAdEmail,
    SAdPhone,
    SAdFax,
    SAdWebSite,
SAdEffiDate,
    SAdEditDate,
    IAdFlag
  from TADVERTISEMENT
 <dynamic prepend="Where">     
<isNotEmpty prepend="AND" property="SAdTitle">
  (TADVERTISEMENT.SAdTitle like '%$SAdTitle$%')
</isNotEmpty>
<isNotEmpty prepend="AND" property="SParentTypeCode">
  (TADVERTISEMENT.SParentTypeCode=#SParentTypeCode#)
</isNotEmpty>
<isNotEmpty prepend="AND" property="SExtendTypeCode">
  (TADVERTISEMENT.SExtendTypeCode=#SExtendTypeCode#)
</isNotEmpty>
  </dynamic> 
  order by SAdEditDate desc
</select>