这篇“java怎么使用Jco连接SAP”文章的知识点大部分人都不太理解,所以小编给大家总结了以下内容,内容详细,步骤清晰,具有一定的借鉴价值,希望大家阅读完这篇文章能有所收获,下面我们一起来看看这篇“java怎么使用Jco连接SAP”文章吧。
java使用Jco连接SAP
JCO为我们提供了另外一种连接的方法:
DestinationDataProvider,通过它我们就可以将一个连接变量信息存放在内存里。
import java.util.HashMap; import java.util.Properties; import com.sap.conn.jco.JCoDestination; import com.sap.conn.jco.JCoDestinationManager; import com.sap.conn.jco.JCoException; import com.sap.conn.jco.ext.DataProviderException; import com.sap.conn.jco.ext.DestinationDataEventListener; import com.sap.conn.jco.ext.DestinationDataProvider; public class CustomDestinationDataProvider { /** * 配置生成连接 * qj */ static class MyDestinationDataProvider implements DestinationDataProvider { private DestinationDataEventListener eL; private HashMap<String, Properties> secureDBStorage = new HashMap<String, Properties>(); // 实现接口:获取连接配置属性 public Properties getDestinationProperties(String destinationName) { try { //read the destination from DB Properties p = secureDBStorage.get(destinationName); if(p!=null) { //check if all is correct, for example if(p.isEmpty()) throw new DataProviderException(DataProviderException.Reason.INVALID_CONFIGURATION, "destination configuration is incorrect", null); return p; } return null; } catch(RuntimeException re) { throw new DataProviderException(DataProviderException.Reason.INTERNAL_ERROR, re); } } public void setDestinationDataEventListener(DestinationDataEventListener eventListener) { this.eL = eventListener; } public boolean supportsEvents() { return true; } //implementation that saves the properties in a very secure way 添加连接配置属性 void changeProperties(String destName, Properties properties) { synchronized(secureDBStorage) { if(properties==null) { if(secureDBStorage.remove(destName)!=null) eL.deleted(destName); } else { secureDBStorage.put(destName, properties); eL.updated(destName); // create or updated } } } } // end of MyDestinationDataProvider //business logic void executeCalls(String destName) { JCoDestination dest; try { dest = JCoDestinationManager.getDestination(destName); dest.ping(); System.out.println("Destination " + destName + " works"); } catch(JCoException e) { e.printStackTrace(); System.out.println("Execution on destination " + destName+ " failed"); } } /** * 配置连接信息 * @return */ static Properties getDestinationPropertiesFromUI() { //adapt parameters in order to configure a valid destination Properties connectProperties = new Properties(); connectProperties.setProperty(DestinationDataProvider.JCO_ASHOST, "***********"); //IP connectProperties.setProperty(DestinationDataProvider.JCO_SYSNR, "01"); //系统编号 connectProperties.setProperty(DestinationDataProvider.JCO_CLIENT, "620"); //客户端编号 connectProperties.setProperty(DestinationDataProvider.JCO_USER, "user"); //用户名 connectProperties.setProperty(DestinationDataProvider.JCO_PASSWD, "123456"); //密码 connectProperties.setProperty(DestinationDataProvider.JCO_LANG, "ZH"); //语言 return connectProperties; } public static void main(String[] args) { //初始化配置信息 MyDestinationDataProvider myProvider = new MyDestinationDataProvider(); //register the provider with the JCo environment; //catch IllegalStateException if an instance is already registered try { com.sap.conn.jco.ext.Environment.registerDestinationDataProvider(myProvider); } catch(IllegalStateException providerAlreadyRegisteredException) { //somebody else registered its implementation, //stop the execution throw new Error(providerAlreadyRegisteredException); } //连接池名,名字随意取 String destName = "ABAP_AS"; CustomDestinationDataProvider test = new CustomDestinationDataProvider(); //set properties for the destination and ... myProvider.changeProperties(destName, getDestinationPropertiesFromUI()); //... work with it //连接测试 test.executeCalls(destName); } }
然后可以用如下的代码来 call rfc。
import java.util.concurrent.CountDownLatch; import com.sap.conn.jco.*; import static com.chunqiu.modules.sap.CustomDestinationDataProvider.getDestinationPropertiesFromUI; /** * basic examples for Java to ABAP communication * qj */ public class StepClient { static String ABAP_AS = "ABAP_AS"; static String ABAP_AS_POOLED = "ABAP_AS"; static String ABAP_MS = "ABAP_AS"; /** * This example demonstrates the destination concept introduced with JCO 3. * The application does not deal with single connections anymore. Instead * it works with logical destinations like ABAP_AS and ABAP_MS which separates * the application logic from technical configuration. * 测试连接 * @throws JCoException */ public static void step1Connect() throws JCoException { JCoDestination destination = JCoDestinationManager.getDestination(ABAP_AS); System.out.println("Attributes:"); System.out.println(destination.getAttributes()); System.out.println(); destination = JCoDestinationManager.getDestination(ABAP_MS); System.out.println("Attributes:"); System.out.println(destination.getAttributes()); System.out.println(); } /** * This example uses a connection pool. However, the implementation of * the application logic is still the same. Creation of pools and pool management * are handled by the JCo runtime. * 使用连接池连接 * @throws JCoException */ public static void step2ConnectUsingPool() throws JCoException { JCoDestination destination = JCoDestinationManager.getDestination(ABAP_AS_POOLED); destination.ping(); System.out.println("Attributes:"); System.out.println(destination.getAttributes()); System.out.println(); } /** * The following example executes a simple RFC function STFC_CONNECTION. * In contrast to JCo 2 you do not need to take care of repository management. * JCo 3 manages the repository caches internally and shares the available * function metadata as much as possible. * 使用getExportParameterList() 设置参数 * @throws JCoException */ public static void step3SimpleCall() throws JCoException { //JCoDestination is the logic address of an ABAP system and ... JCoDestination destination = JCoDestinationManager.getDestination(ABAP_AS_POOLED); // ... it always has a reference to a metadata repository //从对象仓库中获取 RFM 函数 JCoFunction function = destination.getRepository().getFunctionTemplate("ZFM_FI_TAXPLATFORM_PRICE").getFunction(); System.out.println("function================="+function); if(function == null) throw new RuntimeException("ZFM_FI_TAXPLATFORM_PRICE not found in SAP."); //JCoFunction is container for function values. Each function contains separate //containers for import, export, changing and table parameters. //To set or get the parameters use the APIS setValue() and getXXX(). // 设置import 参数 JCoParameterList importParam = function.getExportParameterList(); importParam.setValue("ZFIS_MBLNR", "123456789"); try { //execute, i.e. send the function to the ABAP system addressed //by the specified destination, which then returns the function result. //All necessary conversions between Java and ABAP data types //are done automatically. function.execute(destination); } catch(AbapException e) { //System.out.println(e.toString()); return; } System.out.println("STFC_CONNECTION finished:"); System.out.println(" Echo: " + function.getExportParameterList().getString("ECHOTEXT")); System.out.println(" Response: " + function.getExportParameterList().getString("RESPTEXT")); System.out.println(); } /** * ABAP APIs often uses complex parameters. This example demonstrates 访问结构 (Structure) * how to read the values from a structure. * 构造访问 * @throws JCoException */ public static void step3WorkWithStructure() throws JCoException { JCoDestination destination = JCoDestinationManager.getDestination(ABAP_AS_POOLED); JCoFunction function = destination.getRepository().getFunctionTemplate("ZFM_FI_TAXPLATFORM_PRICE").getFunction(); if(function == null) throw new RuntimeException("ZFM_FI_TAXPLATFORM_PRICE not found in SAP."); try { function.execute(destination); } catch(AbapException e) { System.out.println(e.toString()); return; } //从返回数据中解析 JCoStructure exportStructure = function.getExportParameterList().getStructure("RFCSI_EXPORT"); System.out.println("System info for " + destination.getAttributes().getSystemID() + ": "); //*********也可直接通过结构中的字段名或字段所在的索引位置来读取某个字段的值 System.out.println("RFCPROTO: "+exportStructure.getString(0)); System.out.println("RFCPROTO: "+exportStructure.getString("RFCPROTO")); //The structure contains some fields. The loop just prints out each field with its name. for(int i = 0; i < exportStructure.getMetaData().getFieldCount(); i++) { System.out.println(exportStructure.getMetaData().getName(i) + ": " + exportStructure.getString(i)); } System.out.println(); //JCo still supports the JCoFields, but direct access via getXXX is more efficient as field iterator // efficient as field iterator 也可以使用下面的方式来遍历 System.out.println("The same using field iterator: System info for " + destination.getAttributes().getSystemID() + ": "); for(JCoField field : exportStructure) { System.out.println(field.getName() + ": " + field.getString()); } System.out.println(); } /** * A slightly more complex example than before. Query the companies list 访问表 * returned in a table and then obtain more details for each company. * 表结构访问 * @throws JCoException */ public static void step4WorkWithTable() throws JCoException { JCoDestination destination = JCoDestinationManager.getDestination(ABAP_AS_POOLED); JCoFunction function = destination.getRepository().getFunction("ZFM_FI_TAXPLATFORM_PRICE"); if(function == null) throw new RuntimeException("ZFM_FI_TAXPLATFORM_PRICE not found in SAP."); try { function.execute(destination); } catch(AbapException e) { System.out.println(e.toString()); return; } JCoStructure returnStructure = function.getExportParameterList().getStructure("RETURN"); if (! (returnStructure.getString("TYPE").equals("")||returnStructure.getString("TYPE").equals("S")) ) { throw new RuntimeException(returnStructure.getString("MESSAGE")); } JCoTable codes = function.getTableParameterList().getTable("COMPANYCODE_LIST"); for (int i = 0; i < codes.getNumRows(); i++) { codes.setRow(i); System.out.println(codes.getString("COMP_CODE") + ' ' + codes.getString("COMP_NAME")); } //move the table cursor to first row codes.firstRow(); for (int i = 0; i < codes.getNumRows(); i++, codes.nextRow()) { function = destination.getRepository().getFunction("BAPI_COMPANYCODE_GETDETAIL"); if (function == null) throw new RuntimeException("BAPI_COMPANYCODE_GETDETAIL not found in SAP."); function.getImportParameterList().setValue("COMPANYCODEID", codes.getString("COMP_CODE")); //We do not need the addresses, so set the corresponding parameter to inactive. //Inactive parameters will be either not generated or at least converted. function.getExportParameterList().setActive("COMPANYCODE_ADDRESS",false); try { function.execute(destination); } catch (AbapException e) { System.out.println(e.toString()); return; } returnStructure = function.getExportParameterList().getStructure("RETURN"); if (! (returnStructure.getString("TYPE").equals("") || returnStructure.getString("TYPE").equals("S") || returnStructure.getString("TYPE").equals("W")) ) { throw new RuntimeException(returnStructure.getString("MESSAGE")); } JCoStructure detail = function.getExportParameterList().getStructure("COMPANYCODE_DETAIL"); System.out.println(detail.getString("COMP_CODE") + ' ' + detail.getString("COUNTRY") + ' ' + detail.getString("CITY")); }//for } /** * this example shows the "simple" stateful call sequence. Since all calls belonging to one * session are executed within the same thread, the application does not need * to take into account the SessionReferenceProvider. MultithreadedExample.java * illustrates the more complex scenario, where the calls belonging to one session are * executed in different threads. * * Note: this example uses Z_GET_COUNTER and Z_INCREMENT_COUNTER. Most ABAP systems * contain function modules GET_COUNTER and INCREMENT_COUNTER that are not remote-enabled. * Copy these functions to Z_GET_COUNTER and Z_INCREMENT_COUNTER (or implement as wrapper) * and declare them to be remote enabled. * 多线程 构造访问 * @throws JCoException */ public static void step4SimpleStatefulCalls() throws JCoException { final JCoFunctionTemplate incrementCounterTemplate, getCounterTemplate; JCoDestination destination = JCoDestinationManager.getDestination(ABAP_MS); incrementCounterTemplate = destination.getRepository().getFunctionTemplate("Z_INCREMENT_COUNTER"); getCounterTemplate = destination.getRepository().getFunctionTemplate("Z_GET_COUNTER"); if(incrementCounterTemplate == null || getCounterTemplate == null) throw new RuntimeException("This example cannot run without Z_INCREMENT_COUNTER and Z_GET_COUNTER functions"); final int threadCount = 5; final int loops = 5; final CountDownLatch startSignal = new CountDownLatch(threadCount); final CountDownLatch doneSignal = new CountDownLatch(threadCount); Runnable worker = new Runnable() { public void run() { startSignal.countDown(); try { //wait for other threads startSignal.await(); JCoDestination dest = JCoDestinationManager.getDestination(ABAP_MS); JCoContext.begin(dest); try { for(int i=0; i < loops; i++) { JCoFunction incrementCounter = incrementCounterTemplate.getFunction(); incrementCounter.execute(dest); } JCoFunction getCounter = getCounterTemplate.getFunction(); getCounter.execute(dest); int remoteCounter = getCounter.getExportParameterList().getInt("GET_VALUE"); System.out.println("Thread-" + Thread.currentThread().getId() + " finished. Remote counter has " + (loops==remoteCounter?"correct":"wrong") + " value [" + remoteCounter + "]"); } finally { JCoContext.end(dest); } } catch(Exception e) { System.out.println("Thread-" + Thread.currentThread().getId() + " ends with exception " + e.toString()); } doneSignal.countDown(); } }; for(int i = 0; i < threadCount; i++) { new Thread(worker).start(); } try { doneSignal.await(); } catch(Exception e) { } } /** * 内表结构访问 * @throws JCoException */ public static void rfcCall() throws JCoException { //JCoDestination is the logic address of an ABAP system and ... JCoDestination destination = JCoDestinationManager.getDestination(ABAP_AS_POOLED); // ... it always has a reference to a metadata repository //从对象仓库中获取 RFM 函数 JCoFunction function = destination.getRepository().getFunctionTemplate("ZFM_FI_TAXPLATFORM_PRICE").getFunction(); if(function == null) throw new RuntimeException("ZFM_FI_TAXPLATFORM_PRICE not found in SAP."); try { //如果传如参数是内表的形式的话就以如下代码传入sap系统 JCo