public class StateProvinceAccessBean extends com.ibm.ivj.ejb.runtime.AbstractEntityAccessBean implements StateProvinceAccessBeanData
Constructor and Description |
---|
StateProvinceAccessBean()
Zero argument constructor used to initialize the access bean.
|
StateProvinceAccessBean(javax.ejb.EJBObject o) |
Modifier and Type | Method and Description |
---|---|
void | commitCopyHelper() |
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() |
java.lang.String | getLanguageId() |
java.lang.Integer | getLanguageIdInEJBType() |
java.lang.String | getName() |
java.lang.String | getStateAbbr() |
protected void | instantiateEJB() |
protected boolean | instantiateEJBByPrimaryKey() |
void | refreshCopyHelper() |
void | setCountryAbbr(java.lang.String newValue) |
void | setInitKey_nLanguageId(java.lang.String newValue) |
void | setInitKey_strStateAbbr(java.lang.String newValue) |
void | setLanguageId(java.lang.Integer newValue) |
void | setLanguageId(java.lang.String newValue) |
void | setName(java.lang.String newValue) |
void | setStateAbbr(java.lang.String newValue) |
public StateProvinceAccessBean()
public StateProvinceAccessBean(javax.ejb.EJBObject o) throws java.rmi.RemoteException
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)
public void setInitKey_strStateAbbr(java.lang.String newValue)
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
public void refreshCopyHelper() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
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)