java.lang.Objectcom.ibm.ivj.ejb.runtime.AbstractEntityAccessBean
com.ibm.commerce.taxation.objects.StateProvinceAccessBean
This table lists State and Province names (by country or region) in each of the supported Languages identified by LANGUAGE_ID. This access bean corresponds to the database table 'STATEPROV'.
Constructor Summary | |
StateProvinceAccessBean() Zero argument constructor used to initialize the access bean. |
|
StateProvinceAccessBean(javax.ejb.EJBObject o) constructor |
Method Summary | |
void | commitCopyHelper() Update(flush) data to the EJBObject (persistent storage). |
protected java.lang.String | defaultJNDIName() |
java.util.Enumeration | findByCountryNameAndLanguageId(java.lang.String astrCountryName, java.lang.Integer anLanguageId) Retrieves all the states or provinces for the indicated country and language. |
java.util.Enumeration | findByLanguageIdAndState(java.lang.Integer anLanguageId, java.lang.String astrState) Retrieves all the states or provinces for the indicated country and language. |
java.util.Enumeration | findByLanguageIdAndStateName(java.lang.Integer anLanguageId, java.lang.String astrStateName) Retrieves all the states or provinces for the indicated country and language. |
java.util.Enumeration | findByLanguageIdStateAbbrAndCountryAbbr(java.lang.Integer anLanguageId, java.lang.String astrStateNameAbbr, java.lang.String countryAbbreviationCode) Retrieves all the states or provinces for the indicated country and language. |
java.util.Enumeration | findByLanguageIdStateAndCountryAbbr(java.lang.Integer anLanguageId, java.lang.String astrStateName, java.lang.String countryAbbreviationCode) Retrieves all the states or provinces for the indicated state, country abbreviation and language. |
java.util.Enumeration | findByLanguageIdStateNameAndCountryAbbr(java.lang.Integer anLanguageId, java.lang.String astrStateName, java.lang.String countryAbbreviationCode) Retrieves all the states or provinces for the indicated country and language. |
java.util.Enumeration | findByNameAndCountryAbbreviationCode(java.lang.String name, java.lang.String countryAbbreviationCode) Retrieves all the states or provinces for the indicated country and language. |
java.lang.String | getCountryAbbr() This method accesses a non-CMP field |
java.lang.String | getLanguageId() This method accesses a non-CMP field |
java.lang.Integer | getLanguageIdInEJBType() This method accesses a non-CMP field |
java.lang.String | getName() This method accesses a non-CMP field |
java.lang.String | getStateAbbr() This method accesses a non-CMP field |
protected void | instantiateEJB() |
protected boolean | instantiateEJBByPrimaryKey() |
void | refreshCopyHelper() Load data from the EJBObject. |
void | setCountryAbbr(java.lang.String newValue) This method accesses a non-CMP field |
void | setInitKey_nLanguageId(java.lang.String newValue) Set the primary key for this object |
void | setInitKey_strStateAbbr(java.lang.String newValue) Set the primary key for this object |
void | setLanguageId(java.lang.Integer newValue) This method accesses a non-CMP field |
void | setLanguageId(java.lang.String newValue) This method accesses a non-CMP field |
void | setName(java.lang.String newValue) This method accesses a non-CMP field |
void | setStateAbbr(java.lang.String newValue) This method accesses a non-CMP field |
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
public StateProvinceAccessBean()
public StateProvinceAccessBean(javax.ejb.EJBObject o) throws java.rmi.RemoteException
Method Detail |
public java.util.Enumeration findByCountryNameAndLanguageId(java.lang.String astrCountryName, java.lang.Integer anLanguageId) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Retrieves all the states or provinces for the indicated country and language.
The SQL query used to fetch all the required rows from the STATEPROV table is:
SELECT * FROM STATEPROV T1 WHERE T1.COUNTRYABBR = ANY (SELECT COUNTRY.COUNTRYABBR FROM COUNTRY WHERE COUNTRY.NAME = ? AND COUNTRY.LANGUAGE_ID = T1.LANGUAGE_ID) AND T1.LANGUAGE_ID = ?
public java.util.Enumeration findByLanguageIdAndState(java.lang.Integer anLanguageId, java.lang.String astrState) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Retrieves all the states or provinces for the indicated country and language.
The SQL query used to fetch all the required rows from the STATEPROV table is:
SELECT * FROM STATEPROV T1 WHERE T1.LANGUAGE_ID=? AND ((T1.NAME=?) OR (T1.STATEPROVABBR=?))
public java.util.Enumeration findByLanguageIdAndStateName(java.lang.Integer anLanguageId, java.lang.String astrStateName) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Retrieves all the states or provinces for the indicated country and language.
The SQL query used to fetch all the required rows from the STATEPROV table is:
SELECT * FROM STATEPROV T1 WHERE T1.LANGUAGE_ID=? AND T1.NAME=?
public java.util.Enumeration findByLanguageIdStateAbbrAndCountryAbbr(java.lang.Integer anLanguageId, java.lang.String astrStateNameAbbr, java.lang.String countryAbbreviationCode) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Retrieves all the states or provinces for the indicated country and language.
The SQL query used to fetch all the required rows from the STATEPROV table is:
SELECT * FROM STATEPROV T1 WHERE T1.LANGUAGE_ID=? AND T1.STATEPROVABBR=? AND T1.COUNTRYABBR=?
public java.util.Enumeration findByLanguageIdStateAndCountryAbbr(java.lang.Integer anLanguageId, java.lang.String astrStateName, java.lang.String countryAbbreviationCode) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Retrieves all the states or provinces for the indicated state, country abbreviation and language.
The SQL query used to fetch all the required rows from the STATEPROV table is:
SELECT * FROM STATEPROV WHERE T1.LANGUAGE_ID=? AND ((T1.NAME=?) OR (T1.STATEPROVABBR=?)) AND (T1.COUNTRYABBR=?)
public java.util.Enumeration findByLanguageIdStateNameAndCountryAbbr(java.lang.Integer anLanguageId, java.lang.String astrStateName, java.lang.String countryAbbreviationCode) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Retrieves all the states or provinces for the indicated country and language.
The SQL query used to fetch all the required rows from the STATEPROV table is:
SELECT * FROM STATEPROV T1 WHERE T1.LANGUAGE_ID=? AND T1.NAME=? AND T1.COUNTRYABBR=?
public java.util.Enumeration findByNameAndCountryAbbreviationCode(java.lang.String name, java.lang.String countryAbbreviationCode) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Retrieves all the states or provinces for the indicated country and language.
The SQL query used to fetch all the required rows from the STATEPROV table is:
SELECT * FROM STATEPROV T1 T1.NAME=? AND T1.COUNTRYABBR=?
public void setInitKey_nLanguageId(java.lang.String newValue)
Set the primary key for this object
public void setInitKey_strStateAbbr(java.lang.String newValue)
Set the primary key for this object
protected java.lang.String defaultJNDIName()
protected void instantiateEJB() throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
protected boolean instantiateEJBByPrimaryKey() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.naming.NamingException
public void commitCopyHelper() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
Update(flush) data to the EJBObject (persistent storage).
public void refreshCopyHelper() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
Load data from the EJBObject.
public java.lang.String getLanguageId() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public java.lang.Integer getLanguageIdInEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public void setLanguageId(java.lang.String newValue)
public void setLanguageId(java.lang.Integer newValue)
public java.lang.String getCountryAbbr() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public void setCountryAbbr(java.lang.String newValue)
public java.lang.String getStateAbbr() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public void setStateAbbr(java.lang.String newValue)
public java.lang.String getName() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public void setName(java.lang.String newValue)
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.