JAVA调用RFC访问数据表查询数据

1、创建RFC函数ZRFC_TEST_JCO_SELECT

 

IMPORT参数：

 

Tables：

源代码：

 

2、创建JAVA程序

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; 
import com.sap.conn.jco.JCoField; 
import com.sap.conn.jco.JCoStructure;  
import com.sap.conn.jco.JCoTable;
  
public class AccessTable { 
     static String ABAP_AS_POOLED = "ABAP_AS_WITH_POOL";   
     static    
  {   
       Properties connectProperties = new Properties();     
        connectProperties.setProperty(DestinationDataProvider.JCO_ASHOST, "192.168.0.0");     
        connectProperties.setProperty(DestinationDataProvider.JCO_SYSNR,  "10");     
        connectProperties.setProperty(DestinationDataProvider.JCO_CLIENT, "100");     
        connectProperties.setProperty(DestinationDataProvider.JCO_USER,   "LIUWL");     
        connectProperties.setProperty(DestinationDataProvider.JCO_PASSWD, "ADMIN123");     
        connectProperties.setProperty(DestinationDataProvider.JCO_LANG,   "ZH");   
        //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 accessTable() throws JCoException    
     {    
           JCoDestination destination = JCoDestinationManager.getDestination(ABAP_AS_POOLED);    
           JCoFunction function = destination.getRepository().getFunction("ZRFC_TEST_JCO_SELECT");  
           function.getImportParameterList().setValue("CARRID", "LH"); 
           if(function == null)    
              throw new RuntimeException("ZRFC_TEST_JCO_SELECT not found in SAP.");    
 
         try    
      {    
               function.execute(destination);    
      }    
       catch(AbapException e)    
       {    
              System.out.println(e.toString());    
              return;    
       }    
        
          JCoTable exportTable = function.getTableParameterList().getTable("DATA");    
          System.out.println("table row:" + exportTable.getNumRows()); 
          exportTable.firstRow();
          for(int i = 0; i < exportTable.getMetaData().getFieldCount(); i++)     
          {     
              System.out.print(exportTable.getMetaData().getName(i) + " " ); 
          }    
          System.out.println();
         
          for(int j = 0; j< exportTable.getNumRows();j++)
          {
              for(int k = 0; k < exportTable.getMetaData().getFieldCount(); k++)     
              {     
                   System.out.print(exportTable.getString(k) + "   " );
                  //system.out.print(exportTable.getString("PRICE");  输出指定字段的值
              }    
              exportTable.nextRow();
              System.out.println();
          }
          

   }    
    
    public static void main(String[] args) throws JCoException    
    {    
          accessTable();    
   } 
 } 

执行结果：

 

 SAP中的数据：