Finding data using an access bean

Finding data by primary key

The following code snippet demonstrates how to select using a primary key.

The first line in the following code snippet instantiates a new UserProfileAccessBean that is called "abUserProfile". The second line sets the primary key in the access bean. The setInitKey_ xxx (where xxx is the primary key field name) naming convention is used by HCL Commerce Developer to name the set methods for primary keys.

//create a new access bean
UserProfileAccessBean abUserProfile = new UserProfileAccessBean();

// set the primary key
abUserProfile.setInitKey_UserId(getUserId().toString());

//call getter to get the DisplayName.  This will also fully populate the access bean with data.
String myDisplayName = abUserProfile.getDisplayName();

When to use instantiateEntity()

Use the instantiateEntity method to retrieve information from the database and populate the access bean. You do not need to use the instantiateEntity() if you are using a getter method to retrieve specific data from the access bean. You only need to use it to explicitly tell the access bean to populate itself, for example, to check if the data you are looking for exists, or to populate an object before passing it to another method.

//Create a new access bean
UserProfileAccessBean abUserProfile = new UserProfileAccessBean();

//Set the primary key
abUserProfile.setInitKey_UserId(getUserId().toString());

//Call instantiateEntity to populate it with data
abUserProfile.instantiateEntity();

Finding data using a finder method

Access beans may also provide specific finder methods for commonly required "find" operations. These methods will return you an Enumeration of access beans that match the find criteria. If records are found, there will be one or more access beans in the Enumeration. If the result of the finder is empty, the finder method will throw javax.persistence.NoResultException.

AddressAccessBean abAddress = new AddressAccessBean().findByNickname("nickname", new Long("10001"));