com.ibm.commerce.taxation.objects
Class StateCodeAccessBean

java.lang.Object
  |
  +--com.ibm.ivj.ejb.runtime.AbstractAccessBean
        |
        +--com.ibm.ivj.ejb.runtime.AbstractEntityAccessBean
              |
              +--com.ibm.commerce.taxation.objects.StateCodeAccessBean
All Implemented Interfaces:
java.io.Serializable, StateCodeAccessBeanData

public class StateCodeAccessBean
extends com.ibm.ivj.ejb.runtime.AbstractEntityAccessBean
implements StateCodeAccessBeanData

This bean provides access to the STATECODE table.

The following is a description of this table:

This table maps the internal StateProv Abbreviation Code to the State or Province Code dictated by the third-party product or vendor identified in the PRODUCTVENDOR column.

See Also:
Serialized Form

Fields inherited from class com.ibm.ivj.ejb.runtime.AbstractAccessBean
DEFAULT_NAMESERVICE_PROVIDER_URL, DEFAULT_NAMESERVICE_TYPE, ejbRef
 
Constructor Summary
StateCodeAccessBean()
          Default constructor.
StateCodeAccessBean(javax.ejb.EJBObject ejbObject)
          Maps to a corresponding ejbCreate method in the home interface of the EJB
 
Method Summary
 void commitCopyHelper()
          Update(flush) data to the EJBObject (persistent storage).
 java.util.Enumeration findByProductVendorAndStateProvinceName(java.lang.String productVendor, java.lang.String stateName)
          Retrieves all the state codes in the specified state name under the indicated product vendor.
 java.util.Enumeration findByProductVendorLanguageIdAndState(java.lang.String productVendor, java.lang.Integer languageId, java.lang.String stateName)
          Retrieves all the state codes in the specified state name under the indicated product vendor.
 java.util.Enumeration findByProductVendorLanguageIdAndStateAbbr(java.lang.String productVendor, java.lang.Integer languageId, java.lang.String stateAbbr)
          Retrieves all the state codes in the specified state abbreviation and language id under the indicated product vendor.
 java.util.Enumeration findByProductVendorLanguageIdAndStateName(java.lang.String productVendor, java.lang.Integer languageId, java.lang.String stateName)
          Retrieves all the state codes in the specified state name under the indicated product vendor.
 java.lang.String getProductVendor()
          This method provides access to the STATECODE.PRODUCTVENDOR column of DB2 type VARCHAR(64) NOT NULL.
 java.lang.String getStateAbbr()
          This method provides access to the STATECODE.STATEPROVABBR column of DB2 type VARCHAR(254) NOT NULL.
 java.lang.String getStateCode()
          This method provides access to the STATECODE.STATEPROVCODE column of DB2 type CHAR(5) NULL.
 void refreshCopyHelper()
          Load data from the EJBObject.
 void setInitKey_strProductVendor(java.lang.String aInitKey_strProductVendor)
          Set the primary key for this object
 void setInitKey_strStateAbbr(java.lang.String aInitKey_strStateAbbr)
          Set the primary key for this object
 void setProductVendor(java.lang.String aProductVendor)
          This method provides access to the STATECODE.PRODUCTVENDOR column of DB2 type VARCHAR(64) NOT NULL.
 void setStateAbbr(java.lang.String aStateAbbr)
          This method provides access to the STATECODE.STATEPROVABBR column of DB2 type CHARACTER (20) NOT NULL.
 void setStateCode(java.lang.String aStateCode)
          This method provides access to the STATECODE.STATEPROVCODE column of DB2 type CHAR(5) NULL.
 
Methods inherited from class com.ibm.ivj.ejb.runtime.AbstractEntityAccessBean
__getCache, __getCache, __getKey, __setCache, __setCache, __setKey, commitCopyHelper, createAccessBeans, createAccessBeans, instantiateEJBByPrimaryKey, refreshCopyHelper, setEJBRef
 
Methods inherited from class com.ibm.ivj.ejb.runtime.AbstractAccessBean
defaultJNDIName, defaultNameServiceType, defaultNameServiceURL, getEJBRef, getGlobalHome, getHome, getInit_GlobalNameServiceTypeName, getInit_GlobalNameServiceURLName, getInit_JNDIName, getInit_NameServiceTypeName, getInit_NameServiceURLName, getInitContext, getInitContext, instantiateEJB, resetEJBRef, resetHomeCache, setInit_GlobalNameServiceTypeName, setInit_GlobalNameServiceURLName, setInit_JNDIName, setInit_NameServiceTypeName, setInit_NameServiceURLName
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

StateCodeAccessBean

public StateCodeAccessBean()

Default constructor. Maps to findByPrimaryKey.


StateCodeAccessBean

public StateCodeAccessBean(javax.ejb.EJBObject ejbObject)
                    throws java.rmi.RemoteException

Maps to a corresponding ejbCreate method in the home interface of the EJB

Parameters:
ejbObject - javax.ejb.EJBObject
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
Method Detail

commitCopyHelper

public void commitCopyHelper()
                      throws java.rmi.RemoteException,
                             javax.ejb.CreateException,
                             javax.ejb.FinderException,
                             javax.naming.NamingException

Update(flush) data to the EJBObject (persistent storage).

Overrides:
commitCopyHelper in class com.ibm.ivj.ejb.runtime.AbstractEntityAccessBean
Returns:
void
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException - The javax.naming.NamingException exception

findByProductVendorAndStateProvinceName

public java.util.Enumeration findByProductVendorAndStateProvinceName(java.lang.String productVendor,
                                                                     java.lang.String stateName)
                                                              throws java.rmi.RemoteException,
                                                                     javax.ejb.FinderException,
                                                                     javax.naming.NamingException

Retrieves all the state codes in the specified state name under the indicated product vendor.

The SQL query used to fetch all the required rows from the STATECODE table is:

SELECT * FROM STATECODE T1 WHERE (T1.PRODUCTVENDOR = ? AND T1.STATEPROVABBR = ANY (SELECT STATEPROV.STATEPROVABBR FROM STATEPROV WHERE STATEPROV.NAME = ?))

Parameters:
productVendor - java.lang.String
stateName - java.lang.String
Returns:
Enumeration of all the StateCodeAccessBeans representing rows that match the search criteria.

findByProductVendorLanguageIdAndState

public java.util.Enumeration findByProductVendorLanguageIdAndState(java.lang.String productVendor,
                                                                   java.lang.Integer languageId,
                                                                   java.lang.String stateName)
                                                            throws java.rmi.RemoteException,
                                                                   javax.ejb.FinderException,
                                                                   javax.naming.NamingException

Retrieves all the state codes in the specified state name under the indicated product vendor.

The SQL query used to fetch all the required rows from the STATECODE table is:

SELECT * FROM STATECODE T1 WHERE T1.PRODUCTVENDOR = ? AND T1.STATEPROVABBR = ANY (SELECT STATEPROV.STATEPROVABBR FROM STATEPROV WHERE STATEPROV.LANGUAGE_ID=? AND ((STATEPROV.STATEPROVABBR=?) OR (STATEPROV.NAME=?)))

Parameters:
productVendor - java.lang.String
languageId - java.lang.Integer
stateName - java.lang.String
Returns:
Enumeration of all the StateCodeAccessBeans representing rows that match the search criteria.

findByProductVendorLanguageIdAndStateAbbr

public java.util.Enumeration findByProductVendorLanguageIdAndStateAbbr(java.lang.String productVendor,
                                                                       java.lang.Integer languageId,
                                                                       java.lang.String stateAbbr)
                                                                throws java.rmi.RemoteException,
                                                                       javax.ejb.FinderException,
                                                                       javax.naming.NamingException

Retrieves all the state codes in the specified state abbreviation and language id under the indicated product vendor.

The SQL query used to fetch all the required rows from the STATECODE table is:

SELECT * FROM STATECODE T1 WHERE (T1.PRODUCTVENDOR = ? AND T1.STATEPROVABBR = ANY (SELECT STATEPROV.STATEPROVABBR FROM STATEPROV WHERE STATEPROV.LANGUAGE_ID=? AND STATEPROV.STATEPROVABBR=?))

Parameters:
productVendor - java.lang.String
languageId - java.lang.Integer
stateAbbr - java.lang.String
Returns:
Enumeration of all the StateCodeAccessBeans representing rows that match the search criteria.

findByProductVendorLanguageIdAndStateName

public java.util.Enumeration findByProductVendorLanguageIdAndStateName(java.lang.String productVendor,
                                                                       java.lang.Integer languageId,
                                                                       java.lang.String stateName)
                                                                throws java.rmi.RemoteException,
                                                                       javax.ejb.FinderException,
                                                                       javax.naming.NamingException

Retrieves all the state codes in the specified state name under the indicated product vendor.

The SQL query used to fetch all the required rows from the STATECODE table is:

SELECT * FROM STATECODE T1 WHERE T1.PRODUCTVENDOR = ? AND T1.STATEPROVABBR = ANY (SELECT STATEPROV.STATEPROVABBR FROM STATEPROV WHERE STATEPROV.LANGUAGE_ID=? AND STATEPROV.NAME = ?)

Parameters:
productVendor - java.lang.String
languageId - java.lang.Integer
stateName - java.lang.String
Returns:
Enumeration of all the StateCodeAccessBeans representing rows that match the search criteria.

getProductVendor

public java.lang.String getProductVendor()
                                  throws java.rmi.RemoteException,
                                         javax.ejb.CreateException,
                                         javax.ejb.FinderException,
                                         javax.naming.NamingException

This method provides access to the STATECODE.PRODUCTVENDOR column of DB2 type VARCHAR(64) NOT NULL.

The following is a description of this column:

String that identifies the third-party product or vendor using this State or Province code for the State or Province identified by this StateProvAbbr code.

Specified by:
getProductVendor in interface StateCodeAccessBeanData
Returns:
java.lang.String
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException - The javax.naming.NamingException exception

getStateAbbr

public java.lang.String getStateAbbr()
                              throws java.rmi.RemoteException,
                                     javax.ejb.CreateException,
                                     javax.ejb.FinderException,
                                     javax.naming.NamingException

This method provides access to the STATECODE.STATEPROVABBR column of DB2 type VARCHAR(254) NOT NULL.

The following is a description of this column:

Internal State or Province Code for the specified state or province assigned by the third-party product or vendor.

Specified by:
getStateAbbr in interface StateCodeAccessBeanData
Returns:
java.lang.String
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException - The javax.naming.NamingException exception

getStateCode

public java.lang.String getStateCode()
                              throws java.rmi.RemoteException,
                                     javax.ejb.CreateException,
                                     javax.ejb.FinderException,
                                     javax.naming.NamingException

This method provides access to the STATECODE.STATEPROVCODE column of DB2 type CHAR(5) NULL.

The following is a description of this column:

The State or Province Code used by the third-party product or vendor for this State or Province.

Specified by:
getStateCode in interface StateCodeAccessBeanData
Returns:
java.lang.String
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException - The javax.naming.NamingException exception

refreshCopyHelper

public void refreshCopyHelper()
                       throws java.rmi.RemoteException,
                              javax.ejb.CreateException,
                              javax.ejb.FinderException,
                              javax.naming.NamingException

Load data from the EJBObject.

Overrides:
refreshCopyHelper in class com.ibm.ivj.ejb.runtime.AbstractEntityAccessBean
Returns:
void
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException - The javax.naming.NamingException exception

setInitKey_strProductVendor

public void setInitKey_strProductVendor(java.lang.String aInitKey_strProductVendor)

Set the primary key for this object

Parameters:
aInitKey_strProductVendor - java.lang.String
Returns:
void

setInitKey_strStateAbbr

public void setInitKey_strStateAbbr(java.lang.String aInitKey_strStateAbbr)

Set the primary key for this object

Parameters:
aInitKey_strStateAbbr - java.lang.String
Returns:
void

setProductVendor

public void setProductVendor(java.lang.String aProductVendor)

This method provides access to the STATECODE.PRODUCTVENDOR column of DB2 type VARCHAR(64) NOT NULL.

The following is a description of this column:

String that identifies the third-party product or vendor using this State or Province code for the State or Province identified by this StateProvAbbr code.

Specified by:
setProductVendor in interface StateCodeAccessBeanData
Parameters:
aProductVendor - java.lang.String
Returns:
void

setStateAbbr

public void setStateAbbr(java.lang.String aStateAbbr)

This method provides access to the STATECODE.STATEPROVABBR column of DB2 type CHARACTER (20) NOT NULL.

The following is a description of this column:

The internal State or Province Code for the specified state or province assigned by the third-party product or vendor.

Specified by:
setStateAbbr in interface StateCodeAccessBeanData
Parameters:
aStateAbbr - java.lang.String
Returns:
void

setStateCode

public void setStateCode(java.lang.String aStateCode)

This method provides access to the STATECODE.STATEPROVCODE column of DB2 type CHAR(5) NULL.

The following is a description of this column:

The State or Province Code used by the third-party product or vendor for this State or Province.

Specified by:
setStateCode in interface StateCodeAccessBeanData
Parameters:
aStateCode - java.lang.String
Returns:
void