使用struts,ibaits和JSTL开发简便通用的文件上传系统（3）
<!-- =============================================
mapped-statement update
============================================= -->
<dynamic-mapped-statement name="updateattachmentDao" >
update ATTACHMENT
<dynamic prepend="set">
<isPropertyAvailable prepend="," property="ATTACHID" >
ATTACHID=#ATTACHID#
</isPropertyAvailable>
<isPropertyAvailable prepend="," property="ATTACHFILENAME" >
ATTACHFILENAME=#ATTACHFILENAME:VARCHAR#
</isPropertyAvailable>
<isPropertyAvailable prepend="," property="ATTACHFILEPATH" >
ATTACHFILEPATH=#ATTACHFILEPATH:VARCHAR#
</isPropertyAvailable>
<isPropertyAvailable prepend="," property="ATTACHFILESIZE" >
ATTACHFILESIZE=#ATTACHFILESIZE#
</isPropertyAvailable>
<isPropertyAvailable prepend="," property="ATTACHMIMETYPE" >
ATTACHMIMETYPE=#ATTACHMIMETYPE:VARCHAR#
</isPropertyAvailable>
<isPropertyAvailable prepend="," property="ATTACHDESC" >
ATTACHDESC=#ATTACHDESC:VARCHAR#
</isPropertyAvailable>
<isPropertyAvailable prepend="," property="ATTACHCREATIONIP" >
ATTACHCREATIONIP=#ATTACHCREATIONIP:VARCHAR#
</isPropertyAvailable>
<isPropertyAvailable prepend="," property="ATTACHCREATIONDATE" >
ATTACHCREATIONDATE=#ATTACHCREATIONDATE#
</isPropertyAvailable>
<isPropertyAvailable prepend="," property="ATTACHMODIFIEDDATE" >
ATTACHMODIFIEDDATE=#ATTACHMODIFIEDDATE#
</isPropertyAvailable>
</dynamic>
<dynamic prepend="where">
<isPropertyAvailable prepend="and" property="ATTACHID" >
ATTACHID=#ATTACHID#
</isPropertyAvailable>
<isPropertyAvailable prepend="and" property="ATTACHFILENAME" >
ATTACHFILENAME=#ATTACHFILENAME:VARCHAR#
</isPropertyAvailable>
<isPropertyAvailable prepend="and" property="ATTACHFILEPATH" >
ATTACHFILEPATH=#ATTACHFILEPATH:VARCHAR#
</isPropertyAvailable>
<isPropertyAvailable prepend="and" property="ATTACHFILESIZE" >
ATTACHFILESIZE=#ATTACHFILESIZE#
</isPropertyAvailable>
<isPropertyAvailable prepend="and" property="ATTACHMIMETYPE" >
ATTACHMIMETYPE=#ATTACHMIMETYPE:VARCHAR#
</isPropertyAvailable>
<isPropertyAvailable prepend="and" property="ATTACHDESC" >
ATTACHDESC=#ATTACHDESC:VARCHAR#
</isPropertyAvailable>
<isPropertyAvailable prepend="and" property="ATTACHCREATIONIP" >
ATTACHCREATIONIP=#ATTACHCREATIONIP:VARCHAR#
</isPropertyAvailable>
<isPropertyAvailable prepend="and" property="ATTACHCREATIONDATE" >
ATTACHCREATIONDATE=#ATTACHCREATIONDATE#
</isPropertyAvailable>
<isPropertyAvailable prepend="and" property="ATTACHMODIFIEDDATE" >
ATTACHMODIFIEDDATE=#ATTACHMODIFIEDDATE#
</isPropertyAvailable>
</dynamic>
</dynamic-mapped-statement> |
<!-- =============================================
mapped-statement updateByPrimaryKey
============================================= -->
<dynamic-mapped-statement name="updateByPrimaryKeyattachmentDao" >
update ATTACHMENT
<dynamic prepend="set">
<isPropertyAvailable prepend="," property="ATTACHID" >
ATTACHID=#ATTACHID#
</isPropertyAvailable>
<isPropertyAvailable prepend="," property="ATTACHFILENAME" >
ATTACHFILENAME=#ATTACHFILENAME:VARCHAR#
</isPropertyAvailable>
<isPropertyAvailable prepend="," property="ATTACHFILEPATH" >
ATTACHFILEPATH=#ATTACHFILEPATH:VARCHAR#
</isPropertyAvailable>
<isPropertyAvailable prepend="," property="ATTACHFILESIZE" >
ATTACHFILESIZE=#ATTACHFILESIZE#
</isPropertyAvailable>
<isPropertyAvailable prepend="," property="ATTACHMIMETYPE" >
ATTACHMIMETYPE=#ATTACHMIMETYPE:VARCHAR#
</isPropertyAvailable>
<isPropertyAvailable prepend="," property="ATTACHDESC" >
ATTACHDESC=#ATTACHDESC:VARCHAR#
</isPropertyAvailable>
<isPropertyAvailable prepend="," property="ATTACHCREATIONIP" >
ATTACHCREATIONIP=#ATTACHCREATIONIP:VARCHAR#
</isPropertyAvailable>
<isPropertyAvailable prepend="," property="ATTACHCREATIONDATE" >
ATTACHCREATIONDATE=#ATTACHCREATIONDATE#
</isPropertyAvailable>
<isPropertyAvailable prepend="," property="ATTACHMODIFIEDDATE" >
ATTACHMODIFIEDDATE=#ATTACHMODIFIEDDATE#
</isPropertyAvailable>
</dynamic>
<dynamic prepend="where">
<isPropertyAvailable prepend="and" property="ATTACHID" >
ATTACHID=#ATTACHID#
</isPropertyAvailable>
</dynamic>
</dynamic-mapped-statement> | （未完待续）
|
当前位置：
