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());        }        }}

.csharpcode, .csharpcode pre{font-size: small;color: black;font-family: consolas, "Courier New", courier, monospace;background-color: #ffffff;/*white-space: pre;*/}.csharpcode pre { margin: 0em; }.csharpcode .rem { color: #008000; }.csharpcode .kwrd { color: #0000ff; }.csharpcode .str { color: #006080; }.csharpcode .op { color: #0000c0; }.csharpcode .preproc { color: #cc6633; }.csharpcode .asp { background-color: #ffff00; }.csharpcode .html { color: #800000; }.csharpcode .attr { color: #ff0000; }.csharpcode .alt {background-color: #f4f4f4;width: 100%;margin: 0em;}.csharpcode .lnum { color: #606060; }

If you have any question, please contact [e-mail]