java取出SAP接口的数据/javaでsap interfaceからデータを取得する/obtain data from sap by java

import test.ConnectionPool;

import com.sap.mw.jco.*;
import com.sap.mw.jco.JCO.Client;
import com.sap.mw.jco.JCO.ParameterList;
import com.sap.mw.jco.JCO.Table;

public class MyMain {

    public static void main(String[] args) {
   
       Client mConnection = null;
       //创建连接池
       ConnectionPool cp = new ConnectionPool();
       try{
       JCO.Table ret = null;
       JCO.Function function = null;
       JCO.ParameterList inParm = null;
     
       //RFC函数名      
       String strRfcName = "zrfc_ddstutas";//rfc函数名
       //使用连接池
       cp.PoolConnection("mySAPPools",50, "700", "00593987", "shit","192.168.100.4", "03");
       //从连接池中取出Connection
       mConnection = JCO.getClient("mySAPPools");
       //             (
  //                            "700", //端口号
  //                            "00593987", //用户名
  //                            "shit", //密码
  //                            "EN", //语言
  //                            "192.168.100.4", //sap服务器ip
  //                            "03"); //系统编号
                              //sysConfig.getSapGroupName()); //SAP组名

        //mConnection.connect();
        if(mConnection!=null&& mConnection.isAlive()){
           System.out.println("SAP连接成功");
        // 从连接获得一个逻辑意义上的“仓库”对象（Repository）

           JCO.Repository myRepository = new JCO.Repository("hui",mConnection); // 只是一个名字
         //为输入参数赋值
           IFunctionTemplate ft = myRepository.getFunctionTemplate(strRfcName.toUpperCase());

             // 从这个函数模板获得该SAP函数的对象

           function = ft.getFunction();
          //  function = this.createFunction(strRfcName);
   inParm = function.getImportParameterList();
   //inParm.clear();
   inParm.setValue("8515466119", "BSTNK"); //AUFNR_B 订单号                          
   //inParm.setValue("1997-10-11", "ERDAT_B"); //AUFNR_E 订单号 
   //inParm.setValue("2011-10-11", "ERDAT_E"); //AUFNR_E 订单号   
   //inParm.setValue("", "KUNNR"); //AUFNR_E 订单号   
  
   //赋值传入参数
   function.setImportParameterList(inParm);          
   mConnection.execute(function);
  
   //执行完毕读取返回信息
   ParameterList pList=function.getTableParameterList();
   //pList.getTable("OUTPUT");
  
   System.out.println(">>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>"+pList.toXML());
   ret = function.getTableParameterList().getTable("OUTPUT");
   if (ret.getNumRows() > 0) {
    System.out.println("查询结果>0");
    for (int i = 0; i < ret.getNumRows(); i++) {
        ret.setRow(i);//指定行
        String strVBELN = ret.getString("VBELN");
        System.out.println("strVBELN查询结果为"+strVBELN);
        String strKUNNR = ret.getString("KUNNR");
        System.out.println("strKUNNR查询结果为"+strKUNNR);
        String strERDAT = ret.getString("ERDAT");
        System.out.println("strERDAT查询结果为"+strERDAT);
        String strMS = ret.getString("MS");
        System.out.println("strMS查询结果为"+strMS);
        String strSTUTSA1= ret.getString("STUTSA1");
        System.out.println("strSTUTSA1查询结果为"+strSTUTSA1);
        String strSTUTSA2= ret.getString("STUTSA2");
        System.out.println("strSTUTSA2查询结果为"+strSTUTSA2);
        String strSTUTSA3= ret.getString("STUTSA3");
        System.out.println("strSTUTSA3查询结果为"+strSTUTSA3);
        String strSTUTSA4= ret.getString("STUTSA4");
        System.out.println("strSTUTSA4查询结果为"+strSTUTSA4);
        String strSTUTSA5= ret.getString("STUTSA5");
        System.out.println("strSTUTSA5查询结果为"+strSTUTSA5);
        String strSTUTSA6= ret.getString("STUTSA6");
        System.out.println("strSTUTSA6查询结果为"+strSTUTSA6);
        String strSTUTSA7= ret.getString("STUTSA7");
        System.out.println("strSTUTSA7查询结果为"+strSTUTSA7);
    }
   }
   System.out.println("查询结果为"+ret.getNumRows());    

          
      

          
        }
      }catch(Exception ex) {
      
           System.out.println(">>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>");
           ex.printStackTrace();
          System.out.println("Caught an exception: \n" + ex);
        }finally{
            // do not forget to close the client connection
         cp.RemoveClientPool("Sample_Pool");
        }
    }

}