java.lang.Objectcom.ibm.ivj.ejb.runtime.AbstractEntityAccessBean
com.ibm.commerce.fulfillment.objects.JurisdictionAccessBean
Each row of this table defines an instance of a particular subclass of jurisdiction. A jurisdiction contains information that can be matched with an address. This access bean corresponds to the database table 'JURST'.
Constructor Summary | |
JurisdictionAccessBean() Zero argument constructor used to initialize the access bean. |
|
JurisdictionAccessBean(javax.ejb.EJBObject o) constructor |
|
JurisdictionAccessBean(java.lang.String aCode, java.lang.Integer aStoreEntityId, java.lang.Integer aSubclass) |
Method Summary | |
void | commitCopyHelper() Update(flush) data to the EJBObject (persistent storage). |
protected java.lang.String | defaultJNDIName() |
java.util.Enumeration | findByStoreentId(java.lang.Integer storeentId) Retrieves the JurisdictionAccessBeans of the specified StoreEntity. |
java.util.Enumeration | findByStoreEntitySubclassZipCodeCityStateAndCountry(java.lang.Integer storeEntityId, java.lang.Integer subclass, java.lang.String zipCode, java.lang.String city, java.lang.String state, java.lang.String country) Retrieves the JurisdictionAccessBeans of a StoreEntity and a subclass that match the specified zip code, city, state, and country The SQL query used to fetch all the required rows from the JURST table is: SELECT * FROM JURST T1 WHERE (T1.STOREENT_ID = ?) AND (T1.SUBCLASS = ?) AND (T1.ZIPCODESTART <= ? or T1.ZIPCODESTART IS NULL) AND (T1.ZIPCODEEND >= ? OR T1.ZIPCODEEND IS NULL) AND (T1.CITY = ? OR T1.CITY is null) AND (T1.STATE = ? OR T1.STATE is null) AND (T1.COUNTRY = ? OR T1.COUNTRY IS NULL) |
java.util.Enumeration | findByStoreSubclassGeoCodeZipCodeCityStateAndCountry(java.lang.Integer storeId, java.lang.Integer subclass, java.lang.String geoCode, java.lang.String zipCode, java.lang.String city, java.lang.String state, java.lang.String country) Retrieves the JurisdictionAccessBeans of a Store and a subclass that match the specified GEO code, zip code, city, state, and country The SQL query used to fetch all the required rows from the JURST table is: SELECT * FROM JURST T1 WHERE (T1.STOREENT_ID = ? OR T1.STOREENT_ID = (SELECT STORE.STOREGRP_ID FROM STORE WHERE STORE.STORE_ID = ?)) AND (T1.SUBCLASS = ?) AND (T1.GEOCODE = ? or T1.GEOCODE IS NULL) AND (T1.ZIPCODESTART <= ? or T1.ZIPCODESTART IS NULL) AND (T1.ZIPCODEEND >= ? OR T1.ZIPCODEEND IS NULL) AND (T1.CITY = ? OR T1.CITY is null) AND (T1.STATE = ? OR T1.STATE is null) AND (T1.COUNTRY = ? OR T1.COUNTRY IS NULL) |
java.util.Enumeration | findByZipCodeCityStateAndCountry(java.lang.String zipCode, java.lang.String city, java.lang.String state, java.lang.String country) Retrieves the JurisdictionAccessBeans that match the specified zip code, city, state, and country. The SQL query used to fetch all the required rows from the JURST table is: SELECT * FROM JURST T1 WHERE (T1.ZIPCODESTART <= ? OR T1.ZIPCODESTART IS NULL) AND (T1.ZIPCODEEND >= ? OR T1.ZIPCODEEND IS NULL) AND (T1.CITY = ? OR T1.CITY is null) AND (T1.STATE = ? OR T1.STATE is null) AND (T1.COUNTRY = ? OR T1.COUNTRY IS NULL) |
java.lang.String | getCity() This method provides access to the JURST.CITY column of DB2 type VARCHAR(128). |
java.lang.String | getCode() This method provides access to the JURST.CODE column of DB2 type CHAR(30) NOT NULL. |
java.lang.String | getCountry() This method provides access to the JURST.COUNTRY column of DB2 type VARCHAR(128). |
java.lang.String | getCountryAbbreviation() This method provides access to the JURST.COUNTRYABBR column of DB2 type VARCHAR(10). |
java.lang.String | getCounty() This method provides access to the JURST.COUNTY column of DB2 type VARCHAR(30). |
java.lang.String | getDescription() This method provides access to the JURST.DESCRIPTION column of DB2 type VARCHAR(254). |
java.lang.String | getDistrict() This method provides access to the JURST.DISTRICT column of DB2 type VARCHAR(30). |
java.lang.String | getGeoCode() This method provides access to the JURST.GEOCODE column of DB2 type VARCHAR(254). |
java.lang.String | getJurisdictionId() This method provides access to the JURST.JURST_ID column of DB2 type INTEGER NOT NULL. |
java.lang.Integer | getJurisdictionIdInEJBType() This method provides access to the JURST.JURST_ID column of DB2 type INTEGER NOT NULL. |
java.lang.String | getMarkForDelete() This method provides access to the JURST.MARKFORDELETE column of DB2 type INTEGER NOT NULL DEFAULT 0. |
java.lang.Integer | getMarkForDeleteInEJBType() This method provides access to the JURST.MARKFORDELETE column of DB2 type INTEGER NOT NULL DEFAULT 0. |
java.lang.String | getState() This method provides access to the JURST.STATE column of DB2 type VARCHAR(128). |
java.lang.String | getStateAbbreviation() This method provides access to the JURST.STATEABBR column of DB2 type VARCHAR(10). |
java.lang.String | getStoreEntityId() This method provides access to the JURST.STOREENT_ID column of DB2 type INTEGER NOT NULL. |
java.lang.Integer | getStoreEntityIdInEJBType() This method provides access to the JURST.STOREENT_ID column of DB2 type INTEGER NOT NULL. |
java.lang.String | getSubclass() This method provides access to the JURST.SUBCLASS column of DB2 type INTEGER NOT NULL. |
java.lang.Integer | getSubclassInEJBType() This method provides access to the JURST.SUBCLASS column of DB2 type INTEGER NOT NULL. |
java.lang.String | getZipcodeEnd() This method provides access to the JURST.ZIPCODEEND column of DB2 type VARCHAR(40). |
java.lang.String | getZipcodeStart() This method provides access to the JURST.ZIPCODESTART column of DB2 type VARCHAR(40). |
protected void | instantiateEJB() |
protected boolean | instantiateEJBByPrimaryKey() |
void | refreshCopyHelper() Load data from the EJBObject. |
void | setCity(java.lang.String newValue) This method accesses a non-CMP field |
void | setCode(java.lang.String newValue) This method accesses a non-CMP field |
void | setCountry(java.lang.String newValue) This method accesses a non-CMP field |
void | setCountryAbbreviation(java.lang.String newValue) This method accesses a non-CMP field |
void | setCounty(java.lang.String newValue) This method accesses a non-CMP field |
void | setDescription(java.lang.String newValue) This method accesses a non-CMP field |
void | setDistrict(java.lang.String newValue) This method accesses a non-CMP field |
void | setGeoCode(java.lang.String newValue) This method accesses a non-CMP field |
void | setInitKey_jurisdictionId(java.lang.String newValue) Set the primary key for this object |
void | setMarkForDelete(java.lang.Integer newValue) This method accesses a non-CMP field |
void | setMarkForDelete(java.lang.String newValue) This method accesses a non-CMP field |
void | setState(java.lang.String newValue) This method accesses a non-CMP field |
void | setStateAbbreviation(java.lang.String newValue) This method accesses a non-CMP field |
void | setStoreEntityId(java.lang.Integer newValue) This method accesses a non-CMP field |
void | setStoreEntityId(java.lang.String newValue) This method accesses a non-CMP field |
void | setSubclass(java.lang.Integer newValue) This method accesses a non-CMP field |
void | setSubclass(java.lang.String newValue) This method accesses a non-CMP field |
void | setZipcodeEnd(java.lang.String newValue) This method accesses a non-CMP field |
void | setZipcodeStart(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 JurisdictionAccessBean()
public JurisdictionAccessBean(javax.ejb.EJBObject o) throws java.rmi.RemoteException
public JurisdictionAccessBean(java.lang.String aCode, java.lang.Integer aStoreEntityId, java.lang.Integer aSubclass) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, javax.ejb.FinderException
Method Detail |
public java.util.Enumeration findByStoreEntitySubclassZipCodeCityStateAndCountry(java.lang.Integer storeEntityId, java.lang.Integer subclass, java.lang.String zipCode, java.lang.String city, java.lang.String state, java.lang.String country) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Retrieves the JurisdictionAccessBeans of a StoreEntity and a subclass that match the specified zip code, city, state, and country
The SQL query used to fetch all the required rows from the JURST table is:
SELECT * FROM JURST T1 WHERE
(T1.STOREENT_ID = ?) AND (T1.SUBCLASS = ?)
AND (T1.ZIPCODESTART <= ? or T1.ZIPCODESTART IS NULL) AND (T1.ZIPCODEEND >= ? OR T1.ZIPCODEEND IS NULL)
AND (T1.CITY = ? OR T1.CITY is null) AND (T1.STATE = ? OR T1.STATE is null) AND (T1.COUNTRY = ? OR T1.COUNTRY IS NULL)
public java.util.Enumeration findByStoreSubclassGeoCodeZipCodeCityStateAndCountry(java.lang.Integer storeId, java.lang.Integer subclass, java.lang.String geoCode, java.lang.String zipCode, java.lang.String city, java.lang.String state, java.lang.String country) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Retrieves the JurisdictionAccessBeans of a Store and a subclass that match the specified GEO code, zip code, city, state, and country
The SQL query used to fetch all the required rows from the JURST table is:
SELECT * FROM JURST T1 WHERE
(T1.STOREENT_ID = ? OR T1.STOREENT_ID = (SELECT STORE.STOREGRP_ID FROM STORE WHERE STORE.STORE_ID = ?)) AND (T1.SUBCLASS = ?)
AND (T1.GEOCODE = ? or T1.GEOCODE IS NULL)
AND (T1.ZIPCODESTART <= ? or T1.ZIPCODESTART IS NULL) AND (T1.ZIPCODEEND >= ? OR T1.ZIPCODEEND IS NULL)
AND (T1.CITY = ? OR T1.CITY is null) AND (T1.STATE = ? OR T1.STATE is null) AND (T1.COUNTRY = ? OR T1.COUNTRY IS NULL)
public java.util.Enumeration findByStoreentId(java.lang.Integer storeentId) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Retrieves the JurisdictionAccessBeans of the specified StoreEntity.
The SQL query used to fetch all the required rows from the JURST table is: SELECT * FROM JURST T1 WHERE T1.STOREENT_ID = ?
public java.util.Enumeration findByZipCodeCityStateAndCountry(java.lang.String zipCode, java.lang.String city, java.lang.String state, java.lang.String country) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Retrieves the JurisdictionAccessBeans that match the specified zip code, city, state, and country.
The SQL query used to fetch all the required rows from the JURST table is:
SELECT * FROM JURST T1 WHERE
(T1.ZIPCODESTART <= ? OR T1.ZIPCODESTART IS NULL) AND (T1.ZIPCODEEND >= ? OR T1.ZIPCODEEND IS NULL)
AND (T1.CITY = ? OR T1.CITY is null) AND (T1.STATE = ? OR T1.STATE is null) AND (T1.COUNTRY = ? OR T1.COUNTRY IS NULL)
public void setInitKey_jurisdictionId(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 getDescription() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the JURST.DESCRIPTION column of DB2 type VARCHAR(254).
The following is a description of this column:
A brief description of the jurisdiction, suitable for display by a user interface that manages jurisdiction definitions.
public void setDescription(java.lang.String newValue)
public java.lang.String getCity() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the JURST.CITY column of DB2 type VARCHAR(128).
The following is a description of this column:
The city or an equivalent. Its definition should always match the one in the ADDRESS table.
public void setCity(java.lang.String newValue)
public java.lang.String getStateAbbreviation() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the JURST.STATEABBR column of DB2 type VARCHAR(10).
The following is a description of this column:
An optional abbreviation code for the state or province (as specified in the STATE column). It supports the use of normal form or short form in the ADDRESS table.
public void setStateAbbreviation(java.lang.String newValue)
public java.lang.String getCode() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the JURST.CODE column of DB2 type CHAR(30) NOT NULL.
The following is a description of this column:
A code which, together with its StoreEntity and SubClass, uniquely identifies this jurisdiction.
public void setCode(java.lang.String newValue)
public java.lang.String getJurisdictionId() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the JURST.JURST_ID column of DB2 type INTEGER NOT NULL.
The following is a description of this column:
Generated unique key.
public java.lang.Integer getJurisdictionIdInEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the JURST.JURST_ID column of DB2 type INTEGER NOT NULL.
The following is a description of this column:
Generated unique key.
public java.lang.String getCountry() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the JURST.COUNTRY column of DB2 type VARCHAR(128).
The following is a description of this column:
The country or region. Its definition should always match the one in the ADDRESS table.
public void setCountry(java.lang.String newValue)
public java.lang.String getState() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the JURST.STATE column of DB2 type VARCHAR(128).
The following is a description of this column:
The state, province, or an equivalent. Its definition should always match the one in the ADDRESS table.
public void setState(java.lang.String newValue)
public java.lang.String getGeoCode() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the JURST.GEOCODE column of DB2 type VARCHAR(254).
The following is a description of this column:
A tax code based on geographical region. This column is used to support Taxware integration. Its definition should always match the one in the ADDRESS table.
public void setGeoCode(java.lang.String newValue)
public java.lang.String getCountryAbbreviation() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the JURST.COUNTRYABBR column of DB2 type VARCHAR(10).
The following is a description of this column:
An optional abbreviation code for the country or region (as specified in the COUNTRY column). It supports the use of normal form or short form in the ADDRESS table.
public void setCountryAbbreviation(java.lang.String newValue)
public java.lang.String getMarkForDelete() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the JURST.MARKFORDELETE column of DB2 type INTEGER NOT NULL DEFAULT 0.
The following is a description of this column:
Reserved for IBM internal use.
public java.lang.Integer getMarkForDeleteInEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the JURST.MARKFORDELETE column of DB2 type INTEGER NOT NULL DEFAULT 0.
The following is a description of this column:
Reserved for IBM internal use.
public void setMarkForDelete(java.lang.String newValue)
public void setMarkForDelete(java.lang.Integer newValue)
public java.lang.String getZipcodeStart() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the JURST.ZIPCODESTART column of DB2 type VARCHAR(40).
The following is a description of this column:
The starting ZIP or postal code of a range of codes. Its definition should always match the one in the ADDRESS table.
public void setZipcodeStart(java.lang.String newValue)
public java.lang.String getZipcodeEnd() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the JURST.ZIPCODEEND column of DB2 type VARCHAR(40).
The following is a description of this column:
The ending ZIP or postal code of a range of codes. Its definition should always match the one in the ADDRESS table.
public void setZipcodeEnd(java.lang.String newValue)
public java.lang.String getSubclass() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the JURST.SUBCLASS column of DB2 type INTEGER NOT NULL.
The following is a description of this column:
Indicates the jurisdiction subclass as follows:&l
public java.lang.Integer getSubclassInEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the JURST.SUBCLASS column of DB2 type INTEGER NOT NULL.
The following is a description of this column:
Indicates the jurisdiction subclass as follows:&l
public void setSubclass(java.lang.String newValue)
public void setSubclass(java.lang.Integer newValue)
public java.lang.String getCounty() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the JURST.COUNTY column of DB2 type VARCHAR(30).
The following is a description of this column:
The county or an equivalent.
public void setCounty(java.lang.String newValue)
public java.lang.String getStoreEntityId() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the JURST.STOREENT_ID column of DB2 type INTEGER NOT NULL.
The following is a description of this column:
The StoreEntity associated with this jurisdiction definition.
public java.lang.Integer getStoreEntityIdInEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the JURST.STOREENT_ID column of DB2 type INTEGER NOT NULL.
The following is a description of this column:
The StoreEntity associated with this jurisdiction definition.
public void setStoreEntityId(java.lang.String newValue)
public void setStoreEntityId(java.lang.Integer newValue)
public java.lang.String getDistrict() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the JURST.DISTRICT column of DB2 type VARCHAR(30).
The following is a description of this column:
The district or an equivalent.
public void setDistrict(java.lang.String newValue)
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.