[JAVA]使用struts,ibaits和JSTL开发简便通用的文..
时间:2005-12-25 来源:blueday
| 
        <!-- ============================================= mapped-statement findByPrimaryKey ============================================= --> <mapped-statement name="findByPrimaryKeyattachmentDao" result-class="java.util.HashMap"> select * from ATTACHMENT where ATTACHID=#ATTACHID# </mapped-statement>  | 
    
  <!-- =============================================
  mapped-statement findcount
  ============================================= -->
  <dynamic-mapped-statement name="findattachmentDaoCount" result-class="java.lang.Integer">
  select count(1) from ATTACHMENT
  <dynamic prepend="where">
  <isPropertyAvailable prepend="and" property="ATTACHID" >
  <isNotNull prepend="" property="ATTACHID" >
  ATTACHID=#ATTACHID#
  </isNotNull>
  </isPropertyAvailable>
  <isPropertyAvailable prepend="and" property="ATTACHFILENAME" >
  <isNotNull prepend="" property="ATTACHFILENAME" >
  ATTACHFILENAME=#ATTACHFILENAME#
  </isNotNull>
  </isPropertyAvailable>
  <isPropertyAvailable prepend="and" property="ATTACHFILEPATH" >
  <isNotNull prepend="" property="ATTACHFILEPATH" >
  ATTACHFILEPATH=#ATTACHFILENAME#
  </isNotNull>
  </isPropertyAvailable>
  <isPropertyAvailable prepend="and" property="ATTACHFILESIZE" >
  <isNotNull prepend="" property="ATTACHFILESIZE" >
  ATTACHFILESIZE=#ATTACHFILESIZE#
  </isNotNull>
  </isPropertyAvailable>
  <isPropertyAvailable prepend="and" property="ATTACHMIMETYPE" >
  <isNotNull prepend="" property="ATTACHMIMETYPE" >
  ATTACHMIMETYPE=#ATTACHMIMETYPE#
  </isNotNull>
  </isPropertyAvailable>
  <isPropertyAvailable prepend="and" property="ATTACHDESC" >
  <isNotNull prepend="" property="ATTACHDESC" >
  ATTACHDESC=#ATTACHDESC#
  </isNotNull>
  </isPropertyAvailable>
  <isPropertyAvailable prepend="and" property="ATTACHCREATIONIP" >
  <isNotNull prepend="" property="ATTACHCREATIONIP" >
  ATTACHCREATIONIP=#ATTACHCREATIONIP#
  </isNotNull>
  </isPropertyAvailable>
  <isPropertyAvailable prepend="and" property="ATTACHCREATIONDATE" >
  <isNotNull prepend="" property="ATTACHCREATIONDATE" >
  ATTACHCREATIONDATE=#ATTACHCREATIONDATE#
  </isNotNull>
  </isPropertyAvailable>
  <isPropertyAvailable prepend="and" property="ATTACHMODIFIEDDATE" >
  <isNotNull prepend="" property="ATTACHMODIFIEDDATE" >
  ATTACHMODIFIEDDATE=#ATTACHMODIFIEDDATE#
  </isNotNull>
  </isPropertyAvailable>
  </dynamic>
  </dynamic-mapped-statement>
  </sql-map>










