OAF_开发系列27_实现OAF中Java类型并发程式开发调用XML Publisher(案例)

20150814 Created By BaoXinjian

一、摘要


通过Java Concurrent Program导入XML文件和RTF文件导出PDF报表,一种官方的源码解读,通过以下三个关键程序实现

1. 通过DataProcess设定XML数据来源

2. 通过RtfProcess设定RTF模板来源

3. 通过FoProcess产生PDF文件

 

二、方案设计 - 代码


Step1. 创建XML数据定义文件(EmpDataTemplate.xml),并上传至服务器的/u2/VIS/visappl/gavin/concprog/目录

<?xml version="1.0" encoding="UTF-8" ?>   
 <dataTemplate name="EmpData" description="Employee Details" Version="1.0">  
    <parameters>  
        <parameter name="p_DeptNo" dataType="character" />   
    </parameters>  
 <dataQuery>  
    <sqlStatement name="Q1">  
    <![CDATA[   
    SELECT d.DEPTNO DEPTNO
          ,d.DNAME DNAME  
          ,d.LOC LOC  
          ,e.EMPNO EMPNO  
          ,e.ENAME ENAME  
          ,e.JOB JOB  
          ,e.MGR MGR  
          ,TO_CHAR(e.HIREDATE,'YYYY/MM/DD') HIREDATE
          ,e.SAL SAL  
          ,nvl(e.COMM, 0) COMM  
      FROM scott.dept d  
          ,scott.emp  e  
     WHERE d.deptno = e.deptno  
       AND d.deptno = nvl( :p_DeptNo, d.deptno)  
    ]]>   
    </sqlStatement>  
  </dataQuery>  
  <dataStructure>  
    <group name="G_DEPT" source="Q1">  
        <element name="DEPT_NUMBER"      value="DEPTNO" />   
        <element name="DEPT_NAME"        value="DNAME" />   
        <element name="LOCATION"     value="LOC" />   
        <element name="EMPLOYEE_NUMBER" value="EMPNO" />   
        <element name="NAME"         value="ENAME" />   
        <element name="JOB"              value="JOB" />   
        <element name="MANAGER"          value="MGR" />   
        <element name="HIREDATE"     value="HIREDATE" />   
        <element name="SALARY"           value="SAL" />   
        <element name="COMMISSION"       value="COMM" />   
    </group>  
  </dataStructure>  
 </dataTemplate>

Step2. 创建rtf模板(EmpDataTemplate.rtf)并上传至服务器的/u2/VIS/visappl/gavin/concprog/目录:

Step3. 创建java concurrent程序(EmpDataTemplate.java)。如果不能编译通过,需到服务器上的$JAVA_TOP目录下载相关类文件(可使用zip命令打包下载: zip -r ~/conclib ./oracle/apps/fnd/cp/*):

package bxj.oracle.apps.ap.java;

import java.sql.Connection;  
import oracle.apps.fnd.cp.request.CpContext;  
import oracle.apps.fnd.cp.request.JavaConcurrentProgram;  
import oracle.apps.xdo.dataengine.DataProcessor;  
import oracle.apps.fnd.util.ParameterList;  
import oracle.apps.fnd.cp.request.ReqCompletion;  
import oracle.apps.fnd.cp.request.OutFile;  
import oracle.apps.fnd.cp.request.LogFile;  
import oracle.apps.fnd.util.NameValueType;  
import oracle.apps.xdo.template.RTFProcessor;  
import oracle.apps.xdo.template.FOProcessor;  
import com.sun.java.util.collections.Hashtable;  
import java.io.File;  


public class runEmpXMLConcProg implements JavaConcurrentProgram {
    public runEmpXMLConcProg() {
    }
    
    String deptNo;

    public void runProgram(CpContext cpContext) {
                
        ParameterList params = cpContext.getParameterList();
        ReqCompletion compl = cpContext.getReqCompletion();
        OutFile outFile = cpContext.getOutFile();
        LogFile logFile = cpContext.getLogFile();
        logFile.writeln(">>1 start ..", LogFile.STATEMENT);

        while (params.hasMoreElements()) {
            NameValueType val = params.nextParameter();
            if (val.getName().equals("P_DEPTNO"))
                deptNo = val.getValue();
        }
        
        logFile.writeln(">>2 P_DEPTNO = " + deptNo, LogFile.STATEMENT);

        Connection jdbcConnection = cpContext.getJDBCConnection();
        try {
            //Initialization – instantiate the DataProcessor class//  
            DataProcessor dataProcessor = new DataProcessor();

            //Set Data Template to be executed     
            dataProcessor.setDataTemplate("/u2/VIS/visappl/gavin/concprog/EmpDataTemplate.xml");
logFile.writeln(">>3 dataProcessor.setDataTemplate", LogFile.STATEMENT); // Assign parameter Hashtable parameters = new Hashtable(); parameters.put("p_DeptNo", deptNo); dataProcessor.setParameters(parameters); logFile.writeln(">>4 dataProcessor.setParameters", LogFile.STATEMENT); // Set the jdbc connection dataProcessor.setConnection(jdbcConnection); logFile.writeln(">>5 dataProcessor.setConnection", LogFile.STATEMENT); // Specify the output directory and file for the data file dataProcessor.setOutput("/u2/VIS/visappl/gavin/concprog/EmpDetails.xml"); logFile.writeln(">>6 dataProcessor.setOutput", LogFile.STATEMENT); // Process the data template dataProcessor.processData(); logFile.writeln(">>6.1 dataProcessor.processData", LogFile.STATEMENT); // Convert rtf to xsl RTFProcessor rtfProcessor = new RTFProcessor("/u2/VIS/visappl/gavin/concprog/EmpDataTemplate.rtf");
logFile.writeln(">>7 new RTFProcessor()", LogFile.STATEMENT); rtfProcessor.setOutput("/u2/VIS/visappl/gavin/concprog/EmpDataTemplate.xsl"); rtfProcessor.process(); logFile.writeln(">>8 rtfProcessor.process()", LogFile.STATEMENT); // Geneate PDF FOProcessor foProcessor = new FOProcessor(); foProcessor.setData("/u2/VIS/visappl/gavin/concprog/EmpDetails.xml"); logFile.writeln(">>9 foProcessor.setData()", LogFile.STATEMENT); foProcessor.setTemplate("/u2/VIS/visappl/gavin/concprog/EmpDataTemplate.xsl"); logFile.writeln(">>10 foProcessor.setTemplate()", LogFile.STATEMENT); foProcessor.setOutput("/u2/VIS/visappl/gavin/concprog/EmpDetails001.pdf"); logFile.writeln(">>11 foProcessor.setOutput()", LogFile.STATEMENT); foProcessor.setOutputFormat(FOProcessor.FORMAT_PDF); foProcessor.generate(); logFile.writeln(">>12 foProcessor.generate() 001", LogFile.STATEMENT); compl.setCompletion(ReqCompletion.NORMAL, "Concurrent Normal Completed!"); } catch (Exception e) { logFile.writeln("Java Concurrent Program Error: "+e.toString(), LogFile.STATEMENT); compl.setCompletion(ReqCompletion.ERROR, e.toString()); } } }

 

三、方案设计 - 应用设定


Step1. 将XML文件和RTF文件上传至服务器相应目录

Step2.  将RunProgram Class包上传至相应目录

Step3. 设定并发可执行程序

 Step4. 设定并发程式及其参数

 

四、运行测试


Step1. 调用Request

Step2. 系统会自动依次产生三个文件xsl->xml->pdf

Step3. 查看xml data文件

Step4. 查看pdf

 

Thanks and Regards

参考:LiaoDunxia - http://blog.csdn.net/t0nsha/article/details/6336872

posted on 2015-07-23 20:16  东方瀚海  阅读(1050)  评论(0编辑  收藏  举报