[JAVA]使用struts,ibaits和JSTL开发简便通用的文..
时间：2005-12-25 来源：blueday
使用struts,ibaits和JSTL开发简便通用的文件上传系统（4）
|
<!-- ============================================= mapped-statement delete ============================================= --> <dynamic-mapped-statement name="deleteattachmentDao" result-class="java.util.HashMap"> delete 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=# ATTACHFILEPATH# </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> |
|
<!-- ============================================= mapped-statement deleteByPrimaryKey ============================================= --> <mapped-statement name="deleteByPrimaryKeyattachmentDao" > delete from ATTACHMENT where ATTACHID=#ATTACHID# </mapped-statement> |
|
<!-- ============================================= mapped-statement find ============================================= --> <dynamic-mapped-statement name="findattachmentDao" result-class="java.util.HashMap"> select * 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=#ATTACHFILEPATH# </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 prepend="order by "> <isNotNull prepend="" property="sortOrder" > $sortOrder$ </isNotNull> <isNull prepend="" property="sortOrder" > </isNull> </dynamic> </dynamic-mapped-statement> |
相关阅读 更多 +
