深入浅出oracle ebs之从jsp到

OracleERPE-BusinessOracle应用技术 Creation February23,Last May1, ReferenceNumber> DRAFT1A<Approver <Approver Copy ControlChange3DraftNoPrevious Copy1LibraryProject2Project34NoteToIfyoureceiveanelectroniccopyofthis andprintitout,pleasewriteyournameontheequivalentofthecoverpage,for controlpurposes.Ifyoureceiveahardcopyofthis,pleasewriteyournameonthefrontcover,forcontrolpurposes. DevelopmentConfiguration开发配置和验 配置JDeveloperOA 小 开发准 定义业务逻辑类、数据 在Applet中使用Apache 了解Apache 编写 测试 OpenandClosedIssuesforthis Open Closed $OA_HTML是所有EBSWeb文件所在 ，最常见的是HTML文件、文件、JSP $COMMON_TOP/_pages/_oa$COMMON_TOP/_pages/_oahtml下，当然如果jsp放在$OA_HTML的子 JSP中可以标准Java类库，也可以其他Java类库，客户化开发的类库统一放 $OA_MEDIA通常存放N:InmostcasesunlessspecifiedotherwisetheTomcatcontextissettoautoreloadclasseswhichhavebeenmodified.Howeverfollowingthingsneedtobekeptinmindaboutautoreload-OnlyclassesinthefolderWEB-INF/classeswillbeTheseclasseswillbereloadedonlyifaservletoraJSPfileusingthemiscalled.Inparticular,changestoclassesotherthantheservletyouarerequestingdonottriggerclassreloads--youwillneedtorestartTomcattoreflectchangesinthoseclasses.Beansdonotgetreloaded.Ifyouhavebeansthatyoucallinservletsthebeanswillnotgetreloadedunlessyourestarttomcat.TheonlyotherwayIfiguretogetthemtoreloadistobuildinfunctionalitytoallowthemtobecalledasservletsantheneverytimeyouchangethebeancallitatleastonceasaservletSetthisflagtofalsetoinstructtheOracleJSPcontainertonotroutinelycomparethetimestampofthepageimplementationclasstothetimestampofthe.jspsourcefilewhenapageisrequested.Withdeveloper_modesettotrue,theOracleJSPcontainercheckseverytimetoseeifthesourcehasbeenmodifiedsincethepageimplementationclasswasgenerated.Ifthatisthecase,theJSPcontainerretranslatesthepage.Withdeveloper_modesettofalse,theJSPcontainerwillcheckonlyupontheinitialrequestforthepageorapplication.Forsubsequentrequests,itwillsimplyre-executethegeneratedpageimplementationclass.ThisflagalsoaffectsdynamicclassreloadingforJavaBeansandothersupportclassescalledbyaJSPpage.Withdeveloper_modesettotrue,theOracleJSPcontainercheckstoseeifsuchclasseshavebeenmodifiedsincebeingloadedbytheOracleJSPclassloaderN:配置JDeveloperOA推荐直接使用开发OAF的JDeveloper版本：Oracle9iJDeveloperwithOAExtension。 以这个为基础。OAFrameworkJavaAOL/JJavaBC4JJavaUIXJavaOAFrameworkToolBox指南/OAFramework扩展的Oracle9iJDeveloper可执行和OAFrameworkOAFrameworkToolBoxN:我的电脑/右键/属性/高级/环境变量/用户变量的新建为了方便快速启动，为jdevbin\jdev\bin\jdevw.exeN:认取这个值，如<%@pagecontentType="text/html;charset=GB2312"%>。N:Project/DefaultProjectSettings…/Common/OracleApplications/Run添加OA设置默认Project属性：ForgiveDuplicateDirectiveN:Project/DefaultProject 该JSP页面会报“Error(XXX):错误,属性定义了两次:language”。解决办法是选中ForgiveDuplicateDirectiveAttributes(HelpsJSP1.1Compatability)。启动Oracle9iN:File/New/General/WorkspaceConfiguredforOracle我们选择WorkspaceConfiguredforOracleApplications N:File/New/General/ProjectConfiguredforOracle由于上一步选中了AddaNewOAProject，接下来会自动出现Project 这个Project仅仅是为了练习，下面正式创建GITIProject因为我们实际不是基于OracleApplicationFramework开发的，下面的步骤都跳过。有的可以参考联机帮助《OAFrameworkToolBoxTutorial》，这个有Arone整理、N:File/New/General/Java该类名 N:右键 N:File/New/WebTier/JavaServerPages(JSP)/JSP <%@page <%@<%@page N:右键 N:右键 对应包 对应服务器$COMMON_TOP/_pages/_oa …………_oWorld$ 可以看到，没有用到，仅需发布两个文件夹的内容Type选择“SSWAjspHTMLCall输入$OA_HTML下的相对路径“cux/ com.hand.giti（为与当前实际的开发一致，不用cux；此外，page名也不用cux而的 JAVA_TOP/oracle/apps/csf→JAVA_TOP/oracle/apps/jtf/aom→JAVA_TOP/oracle/apps/jtf/base→JAVA_TOP/oracle/apps/jtf/coreservices→. N:File/New/WebTier/JavaServerPages(JSP)/JSP<%@page<%@includefile="csfwhead.jsp"<%@includefile="header.jsp"<%@includefile="footer.jsp"<%@includefile="csfwfoot.jsp"tX和etXDSQLRsltSt。packagepublicclass{privateintprivateStringprivateStringpublic}publicintgetOrganizationID()returnpublicvoidsetOrganizationID(intthis.mOrganizationID=publicStringgetOrganizationCode()returnpublicvoidsetOrganizationCode(Stringthis.mOrganizationCode=publicStringgetOrganizationName()returnpublicvoidsetOrganizationName(Stringthis.mOrganizationName=}packageimportjava.sql.Connection;importjava.sql.PreparedStatement;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.util.Collection;importjava.util.Vector;publicclass{publicpublicstaticCollectionqueryOrganization(Connectionconn)throwsSQLException StringstrSql= +"SELECTanization_id +"FROMorg_access_v +"WHEREoa.responsibility_id= +"ANDoa.resp_application_id=PreparedStatementps=ResultSetrs=Collectionvc=newMfgOrganizationDTOtry ps= rs= 循环记录，把数据放入 while(rs.next()) dto=new finally if(rs!=null) if(ps!=null) //返回一个dto的return}N:File/New/WebTier/JavaServerPages(JSP)/JSP <%@page<%@includefile="csfwhead.jsp" <tablecellpadding="0"cellspacing="0"border="0"<tr><td><%@includefile="header.jsp"<tr><tdheight="20"valign="bottom"><%@includefile="footer.jsp" <%@includefile="csfwfoot.jsp"<%@page<%@page系统<linkrel="stylesheet"charset="UTF-8" -ie-6- Collectionorg=org=if(org!=null) toriter=org.i while(iter.hasNext()){MfgOrganizationDTOdto=(MfgOrganizationDTO)}}if out.println("}%<inputtype="text"name="itemCode"size="20"写成标准class，用import指令，如上面例子中的MfgOrganization在JSP内部写class，即innerclass。该方式是为了不重启Apache但又想保留1的风<%@pageclass{privateint}改写fgaization.a成Manizatio.jsptemDO.jav成SstemtmT.jspteme.jaa成temte.js<%@pageimport="Java类<%@includefileJSP文件 归BillyChi，我的工作仅仅是理解并整理。了解Apache有关ApacheFOP的内容，请参看《深入浅出OracleEBS之条码打印》的“Apache 4.JavaApplet中调用3.JavaApplet中用实际编写LabelPrintAgentN:File/New/General/JavaN:File/New/General/JavaN:Project由于代码中了大量FOP类，所以LabelPrintAgent.java无法Build成功，需要avalon.jar、