01OAF客户化开发实例之FTP文件上传开发实例上册v10

AIMMD.070APPLICATIONEXTENSIONTECHNICALDESIGNFTP文件上传开发实例上册Author:Peng.YangCreationDate:January28,2010LastUpdated:April25,2013DocumentRef:Version:1.0Approvals:Approver1Peng.YangApprover2CopyNo._____MD.070ApplicationExtensionTechnicalDesignii/69DocRef:March18,2013DocumentControlChangeRecord3DateAuthorVersionChangeReference28-Jan-2010Peng.Yang1.0NoPreviousDocumentReviewersNamePositionDistributionCopyNo.NameLocation1LibraryMasterProjectLibrary2ProjectManager34NoteToHolders:Ifyoureceiveanelectroniccopyofthisdocumentandprintitout,pleasewriteyournameontheequivalentofthecoverpage,fordocumentcontrolpurposes.Ifyoureceiveahardcopyofthisdocument,pleasewriteyournameonthefrontcover,fordocumentcontrolpurposes.MD.070ApplicationExtensionTechnicalDesigniii/69DocRef:March18,2013ContentsDocumentControl..................................................................................................................ii开发介绍...................................................................................................................................1概述....................................................................................................................................1完成的目标........................................................................................................................2XP操作系统JDEV环境配置..............................................................................................3数据库表结构....................................................................................................................5步骤1：创建OA工作台和OA项目..............................................................................7步骤2：设置项目的运行选项...........................................................................................8步骤3：创建页面模型组件............................................................................................10步骤4：实现文件上传业务逻辑(声明式验证和初始化).............................................16步骤5：创建上传文件页................................................................................................17步骤6：创建上传后的结果页.........................................................................................50步骤7：程序部署到EBS应用服务器中..........................................................................60步骤8：OAF控制器中的日志查看................................................................................63步骤9：如何找到页面所对应的源文件.........................................................................64OpenandClosedIssuesforthisDeliverable....................................................................66OpenIssues.....................................................................................................................66ClosedIssues..................................................................................................................66MD.070ApplicationExtensionTechnicalDesign1/69DocRef:March18,2013开发介绍概述本文当讲述了如何实现OAFFTP文件上传页面功能。MD.070ApplicationExtensionTechnicalDesign2/69DocRef:March18,2013完成的目标完成此开发之后，需要掌握如下的课题：OAF开发环境搭建了解OAF框架的了解OAF开发规范遵循OAF页面的基本布局通过编写必要的程序实现页面直接的JSPForward启用WarnAboutChanges功能，帮助用户减少不必要的数据丢失工作实现实体对象、实体属性和行级的业务逻辑(包括抛出属性和行级的验证异常)在业务逻辑中使用视图对象验证和应用模块验证在基于实体对象的视图对象中添加一个新的行处理按钮的动作确保应用程序在使用浏览器中的Back按钮是安全的MD.070ApplicationExtensionTechnicalDesign3/69DocRef:March18,2013XP操作系统JDEV环境配置创建目录结构在jdev_install_dir\jdev目录下创建两个文件夹分别为myprojects和dbc_files，为了保持和ebs服务器一致，则在dbc_files下创建secure文件夹用于存放HostName_SID_Name.dbc文件，如下图所示。设置JDEV_USER_HOME环境变量1．选择我的电脑，右键选择属性2．在系统属性对话框中，选择tab高级页3．在高级tab页中选择环境变量按钮4．在环境变量对话框中，选择新建按钮创建用户变量5．在新建用户变量对话框中，输入变量名：JDEV_USER_HOME变量值：jdev_install_dir\jdev，例如：我在这里设置的变量值为：C:\ibm_young\JDeveloper9iCU3_R12\jdevhome\jdev6．保存设置MD.070ApplicationExtensionTechnicalDesign4/69DocRef:March18,2013从ebs服务器上下载dbc文件到本地并进行修改EBSR12服务器中dbc文件所在位置：$FND_SECURE/HostName_SID_Name.dbc将erpuat_uat.dbc下载下来，将里面APPS_JDBC_URL=后面的内容反斜杠全部去除，即如下：APPS_JDBC_URL=jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=erpuat.yangpeng.com)(PORT=1522)))(CONNECT_DATA=(SID=UAT)))然后将该dbc文件放到$JDEV_HOME\jdevhome\jdev\dbc_files\secure路径下，例如我当前路径如下：D:\JDeveloper9iCU3\jdevhome\jdev\dbc_files\secure创建快捷方式为了方便快速启动，为jdev_install_dir\jdev\bin\jdevw.exe创建桌面快捷方式添加下面两个职责给自己的ebs用户以便开发和测试1．OAFrameworkToolBoxTutorial(职责关键字：FWK_TBX_TUTORIAL)，即OAFramework工具教程2．OAFrameworkToolBoxTutorialLabs(职责关键字：FWK_TOOLBOX_TUTORIAL_LABS)，即OAFramework工具教程：练习。启动Jdeveloper，并配置数据库连接和用户打开Jdeveloper后，ConnectionsDatabaseNewConnection或更改已新建过的连接如下：Type下ConnectionType为Oracle(JDBC)Authentication下Username为apps，Password为apps，Role为NormalConnection下Driver为thin，HostName为erpuat.yangpeng.com，JDBCPort为1522，SID为UAT然后TestConnection看是否可以连上，如果连上则显示Success!MD.070ApplicationExtensionTechnicalDesign5/69DocRef:March18,2013数据库表结构创建数据库表脚本--CreatetableCREATETABLEcux.cux_upload_files(file_idNUMBERNOTNULL,file_nameVARCHAR2(360),--shell是没有文件名的file_typeVARCHAR2(100),upload_flagVARCHAR2(100),--仅上传ONLY_UPLOAD(默认),仅执行SHELL命令file_data_save_flagVARCHAR2(30)DEFAULT'N',--上传文件是否备份到数据库表中默认否old_file_bk_flagVARCHAR2(30)DEFAULT'N',--原始文件备份标记