Java Data Bean集成Siebel ​​​​​​​

1、在IDEA中新建java项目，并添加如下jar包的引用

2、新建类JDB.JAVA

3、添加如下代码，如下代码完成两个功能，第一是对Siebel标准的Account进行查询，

第二是调用Siebel的一个标准BS，

package IO;

import com.siebel.data.*;

public class JDB {

    /**

     * @param args

     */

    public static void main(String[] args) throws SiebelException {

       // TODO Auto-generated method stub

       String UserName = "ADMIN";

       String Password = "ADMIN";

       String Lang = "chs";

       String connectString = "siebel://xx.6.11.xx:3321/SBA_81/eConsumerSectorObjMgr_chs";

       //String connectString = "siebel://192.168.30.128:2321/SBA_81/eConsumerSectorObjMgr_chs";

       //String connectString = "siebel://10.8.164.17:2321/SBA_81/eConsumerSectorObjMgr_chs";

       SiebelDataBean dataBean = new SiebelDataBean();

       dataBean.login(connectString, UserName, Password, Lang);

       SiebelBusObject busObject = dataBean.getBusObject("Account");

       SiebelBusComp busComp = busObject.getBusComp("Account");

/*

 * 查询客户

 */

       busComp.setViewMode(3);

       busComp.clearToQuery();

       busComp.activateField("Name");

       busComp.activateField("Id");

       busComp.setSearchSpec("Name", "xxxxxxxxxxxxxx公司");

       busComp.executeQuery2(true, true);

       if (busComp.firstRecord()) {

           System.out.println("AccountId: " + busComp.getFieldValue("Id"));

           System.out.println("Name: " + busComp.getFieldValue("Name"));

       }

       else

       {

           System.out.println("未找到记录");

       }

       busComp.release();

       busObject.release();

       

       /*

        * 调用Siebel的BS

        */

       

       //SiebelService businessService = dataBean.getService("CofcoSMSBusinessService");

       SiebelService businessService = dataBean.getService("COFCO SMS Service");

       String url="jdbc:jtds:sqlserver://xxx.5.125.xx:1433/addresslist;USER=***;PASSWORD=***";

       //SiebelService businessService = dataBean.getService("ImposSiebelXSLT Business Service");

       SiebelPropertySet input = new SiebelPropertySet();

       SiebelPropertySet output = new SiebelPropertySet();

       input.setProperty("PhoneNum", "1365178xxxx");

       input.setProperty("SendDate", "2019-01-01 01:01:01");

       input.setProperty("Message", "122");

       input.setProperty("ConnectionStr", url);

       businessService.invokeMethod("Send", input, output);

       System.out.println("Output: " + output.toString());

       String ot=output.getProperty("BackMsg");

       System.out.println(ot);

       dataBean.logoff();

    }

    //DelayMin

}

运行，可得到返回值