JCO的使用

JCO的使用

最近公司上线SAP R/3，需要使用JAVA做外部的应用开发，所以用到JCO工具。

import com.sap.mw.jco.*;
。。。

import java.io.*;
import java.util.*;

/**
 *
 * @author  ShineYu
 */
public class MainJFrame extends javax.swing.JFrame {
    
    private void jButton1MouseClicked(java.awt.event.MouseEvent evt) {                                     
// JCO连接处理的代码

        JCO.Client SapConn;
        //try {
            SapConn = JCO.createClient("400","MIS-YL","123456",null,"192.168.0.15","00");//建立连接
            SapConn.connect();//打开连接，连接到SAP
            
            JCO.Repository mRepository;
            mRepository = new JCO.Repository("ARAsoft",SapConn);

            //定义函数
            IFunctionTemplate ft =
                mRepository.getFunctionTemplate("BAPI_SALESORDER_GETLIST");
            JCO.Function jcoFunction = new JCO.Function(ft);
            

            //设置输入参数
            jcoFunction.getImportParameterList().setValue("C0209","CUSTOMER_NUMBER");//客户代号
            jcoFunction.getImportParameterList().setValue( "1000", "SALES_ORGANIZATION");//销售组织
            
         
            //执行函数

            SapConn.execute(jcoFunction);
            
            //取函数结果中表SALES_ORDERS 
           JCO.Table Order = jcoFunction.getTableParameterList().getTable("SALES_ORDERS");
           
            String TableData="";
            for(int i=0;i<Order.getNumRows();i++)
            {
               
                Order.setRow(i);
                TableData = TableData+Order.getString("SD_DOC")+"|"+Order.getString("MATERIAL")+"/n";
            }
            JOptionPane.showMessageDialog(null,TableData);
            
            SapConn.disconnect(); //断开连接
           JOptionPane.showMessageDialog(null,"连接成功！");
        }
        catch (Exception EX)
        {
            JOptionPane.showMessageDialog(null,"连接失败！");           
        }
        
    }