SAP JCO使用备忘录

　　公司的很多系统都需要连接SAP进行数据交互（我们用的是RFC方式），之前我们采用的是jco2的版本，前阵子因为服务器升级，导致系统旧的sap模块无法使用了，必须升级至jco3才行，后来下载了jco3才知道，两者相差太多了，许多接口名字都变了，相关模块必须重写！

　　好不容易弄完了，这里把两者如何做连接简单地记录一下：

JCO2:

Properties logonProperties = new Properties();
logonProperties.put("jco.client.ashost", "10.10.11.22");
logonProperties.put("jco.client.client", "100");
logonProperties.put("jco.client.sysnr", "01");
logonProperties.put("jco.client.user", "username");
logonProperties.put("jco.client.passwd", "password");

JCO.Client conn = JCO.createClient(logonProperties);
conn.connect();
JCO.Repository rep = new JCO.Repository("Repository", conn);
IFunctionTemplate ft = rep.getFunctionTemplate("Z_SD_XXXX");
JCO.Function function = ft.getFunction();
JCO.ParameterList list = function.getImportParameterList();

//设置输入参数
list.setValue("1000", "PLANT");
...
conn.execute(function);
JCO.Table rs = function.getTableParameterList().getTable("TABLE_HEAD");
conn.disconnect();

//获取输出
List<HeadBean> sh = new ArrayList<HeadBean>();
for (int i = 0; i < rs.getNumRows(); i++) {
	rs.setRow(i);
	HeadBean s = new HeadBean();
	s.setCompanyCode(rs.getString("COMPANY_CODE"));
	s.setSalesOrg(rs.getString("SALES_ORG"));
...
	sh.add(s);
}

JCO3:

Properties logonProperties = new Properties();
logonProperties.put("jco.client.ashost", "10.10.11.22");
logonProperties.put("jco.client.client", "100");
logonProperties.put("jco.client.sysnr", "01");
logonProperties.put("jco.client.user", "username");
logonProperties.put("jco.client.passwd", "password");

File file = new File("sapconnection.jcoDestination");
FileOutputStream stream = new FileOutputStream(file, false);
logonProperties.store(stream, "SAP connection properties");
stream.close();
JCoDestination destination = JCoDestinationManager.getDestination("sapconnection");
JCoRepository repository = destination.getRepository();
JCoFunction function = repository.getFunction("Z_SD_XXXX");
JCoParameterList list = function.getImportParameterList();

//设置输入参数
list.setValue("PLANT", "1000");
...

function.execute(destination);
JCoTable rs = function.getTableParameterList().getTable("TABLE_HEAD");

//获取输出
List<HeadBean> sh = new ArrayList<HeadBean>();
for (int i = 0; i < rs.getNumRows(); i++) {
	rs.setRow(i);
	HeadBean s = new HeadBean();
	s.setCompanyCode(rs.getString("COMPANY_CODE"));
	s.setSalesOrg(rs.getString("SALES_ORG"));
...
	sh.add(s);
}

评论

3 楼 林豪桀 2015-01-27  

我们现在还在用sapjco.jar。
能不能提供个 for Linux 64位的 jar包。  
找了一下午了~~

2 楼 Vacoor 2014-01-07  

非常感谢，终于找到个不要积分的 /  要是再来个 linux i686 的就更好了

1 楼 Sky_257 2012-11-07  

请问win 64位，需要怎么放置jar和动态库？