JCo3 调用简单SAP函数（Function）

本文阐述如何使用JCo调用简单SAP函数。

 

1. 创建一SAP用户：test01

 

关于如何创建用户，请参考我上一博客 JCo3 建立连接到SAP（1）- 直接连接

 

2. 编写代码：

import java.io.File; import java.io.FileOutputStream; import java.util.Properties; import com.sap.conn.jco.JCoException; import com.sap.conn.jco.ext.DestinationDataProvider; import com.sap.conn.jco.JCoDestination; import com.sap.conn.jco.JCoDestinationManager; import com.sap.conn.jco.AbapException; import com.sap.conn.jco.JCoFunction; public class ExecuteFunction { static String ABAP_AS_POOLED = "ABAP_AS_WITH_POOL"; static { Properties connectProperties = new Properties(); connectProperties.setProperty(DestinationDataProvider.JCO_ASHOST, "192.168.19.28"); connectProperties.setProperty(DestinationDataProvider.JCO_SYSNR, "00"); connectProperties.setProperty(DestinationDataProvider.JCO_CLIENT, "000"); connectProperties.setProperty(DestinationDataProvider.JCO_USER, "TEST01"); connectProperties.setProperty(DestinationDataProvider.JCO_PASSWD, "ADMIN123"); connectProperties.setProperty(DestinationDataProvider.JCO_LANG, "en"); //JCO_PEAK_LIMIT - Maximum number of idle connections kept open by the destination. connectProperties.setProperty(DestinationDataProvider.JCO_POOL_CAPACITY, "3"); //JCO_POOL_CAPACITY - Maximum number of active connections that //can be created for a destination simultaneously connectProperties.setProperty(DestinationDataProvider.JCO_PEAK_LIMIT, "10"); createDataFile(ABAP_AS_POOLED, "jcoDestination", connectProperties); } static void createDataFile(String name, String suffix, Properties properties) { File cfg = new File(name+"."+suffix); if(!cfg.exists()) { try { FileOutputStream fos = new FileOutputStream(cfg, false); properties.store(fos, "for tests only !"); fos.close(); } catch (Exception e) { throw new RuntimeException("Unable to create the destination file " + cfg.getName(), e); } } } public static void exeFunctionCall() throws JCoException { JCoDestination destination = JCoDestinationManager.getDestination(ABAP_AS_POOLED); JCoFunction function = destination.getRepository().getFunction("STFC_CONNECTION"); if(function == null) throw new RuntimeException("BAPI_COMPANYCODE_GETLIST not found in SAP."); //Get importPrameterList and set value function.getImportParameterList().setValue("REQUTEXT", "Hello SAP"); try { function.execute(destination); } catch(AbapException e) { System.out.println(e.toString()); return; } System.out.println("STFC_CONNECTION finished:"); //get export paramter and retrieve value System.out.println(" Echo: " + function.getExportParameterList().getString("ECHOTEXT")); System.out.println(" Response: " + function.getExportParameterList().getString("RESPTEXT")); System.out.println(); } public static void main(String[] args) throws JCoException { exeFunctionCall(); } }

 

3. 编译：

javac -classpath .;D:/Resources/Libraries/SAPJCo/JCO_304/sapjco3.jar -d classes ExecuteFunction.java

 

4.运行：

java -cp D:/Resources/Libraries/SAPJCo/JCO_304/sapjco3.jar;classes ExecuteFunction

 

运行结果：

STFC_CONNECTION finished: Echo: Hello SAP Response: SAP R/3 Rel. 620 Sysid: C11 Date: 20100615 Time: 212641 Logon_Data: 000/TEST01/E

 

本例调用SAP FUNCTION - ”STFC_CONNECTION“, 然后使用得到importParameterList, 然后再importParameter中设置属性“REQUTEXT”。调用FUNCTION之后，再得到exportParameterList，然后在得到属性“ECHOTEXT”和“RESPTEXT”的值， 其中

“RESPTEXT” 中包含的是FUNCITON "STFC_CONNECTION" 的返回值（RESPONSE）.

 

本节到此为止。

 

下节介绍如何访问SAP STRUCTURE.