Siebel Java Data Bean: Query first record

Following codes will show you how to query the first record from DB using Java Data Bean.

package com ;

import com.siebel.data.*;
import com.siebel.data.SiebelException;

public class DataBeanDemo {

    private SiebelDataBean m_dataBean = null;
    private SiebelBusObject m_busObject = null;
    private SiebelBusComp m_busComp = null;
    public static void main(String[] args)
    {
        DataBeanDemo demo = new DataBeanDemo();
    }
    public DataBeanDemo()
    {
        try
        {
            // instantiate the Siebel Data Bean
            m_dataBean = new SiebelDataBean();
            // log in to the server
            
            //the name or IP address of your Siebel Server
            String SiebelServerhost = "192.168.1.120" ;
            
            //listening port number for the SCBroker component (default 2321)
            String SCBPort = "2321" ;
            
            String enterpriseServer = "SBA_81" ;
            String AppObjMgr_enu = "EAIObjMgr_enu" ;
            
            m_dataBean.login("Siebel://"+SiebelServerhost+":"+SCBPort+"/"+enterpriseServer+"/"+AppObjMgr_enu, "SADMIN", "SADMIN", "enu");
            // get the business object
            m_busObject = m_dataBean.getBusObject("Account");
            // get the business component
            m_busComp = m_busObject.getBusComp("Account");
            
            m_busComp.clearToQuery() ;
            m_busComp.setSearchExpr("[Name] like '*'");
            m_busComp.executeQuery(true) ;
            m_busComp.firstRecord() ;
            
            String acctName = m_busComp.getFieldValue("Name");
            System.out.println(acctName);
            
            // log off
            m_dataBean.logoff();
        }
        catch (SiebelException e)
        {
            System.out.println(e.getErrorMessage());
        }
    
    }
}

If you have any question, please contact yexianyi@hotmail.com

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

yexianyi

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值