[JAVA]使用struts,ibaits和JSTL开发简便通用的文..
时间:2005-12-25 来源:blueday
使用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> |
相关阅读 更多 +