| <!-- ============================================= 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> |
相关文章
Copyright © 2003-2006 iTePub Online Services. All Rights Reserved.
Template Designed by iTePub. Optimized For 1024x768 to Firefox,Opera And MS-IE6.
