java.lang.Objectcom.ibm.ivj.ejb.runtime.AbstractEntityAccessBean
com.ibm.commerce.fulfillment.objects.ShippingArrangementAccessBean
Each row of this table represents a ShippingArrangement, indicating that a FulfillmentCenter can ship products on behalf of a Store using a ShippingMode. This access bean corresponds to the database table 'SHPARRANGE'.
Constructor Summary | |
ShippingArrangementAccessBean() Zero argument constructor used to initialize the access bean. |
|
ShippingArrangementAccessBean(java.lang.Integer newFulfillmentCenterId, java.lang.Integer newStoreId) Creates an access bean with the specified attributes. |
|
ShippingArrangementAccessBean(java.lang.Integer newFulfillmentCenterId, java.lang.Integer newStoreId, java.lang.Integer newShipModeId, java.sql.Timestamp newStartDate, java.sql.Timestamp newEndDate) Creates an access bean with the specified attributes. |
|
ShippingArrangementAccessBean(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 | findByStoreAndFulfillmentCenter(java.lang.Integer storeId, java.lang.Integer fulfillmentCenterId)
Retrieves the ShippingArrangementAccessBeans that match the specified Store and FulfillmentCenter.
The SQL query used to fetch all the required rows from the SHPARRANGE table is: SELECT * FROM SHPARRANGE T1 WHERE T1.STORE_ID = ? AND T1.FFMCENTER_ID = ? |
java.util.Enumeration | findByStoreAndNullShipMode(java.lang.Integer storeId) Retrieves the ShippingArrangementAccessBeans that match the specified Store, with ShippingMode not specified. The SQL query used to fetch all the required rows from the SHPARRANGE table is: SELECT * FROM SHPARRANGE T1 WHERE T1.STORE_ID = ? AND T1.SHIPMODE_ID IS NULL ORDER BY T1.PRECEDENCE DESC |
java.util.Enumeration | findByStoreAndShipMode(java.lang.Integer storeId, java.lang.Integer shipModeId)
Retrieves the ShippingArrangementAccessBeans that match the specified Store and ShippingMode.
The SQL query used to fetch all the required rows from the SHPARRANGE table is: SELECT * FROM SHPARRANGE T1 WHERE T1.STORE_ID = ? AND T1.SHIPMODE_ID = ? |
java.util.Enumeration | findByStoreFulfillmentCenterAndShipMode(java.lang.Integer storeId, java.lang.Integer fulfillmentCenterId, java.lang.Integer shipModeId) Retrieves the ShippingArrangementAccessBeans that match the specified Store, FulfillmentCenter and ShippingMode. The SQL query used to fetch all the required rows from the SHPARRANGE table is: SELECT * FROM SHPARRANGE T1 WHERE T1.STORE_ID = ? AND T1.FFMCENTER_ID = ? AND T1.SHIPMODE_ID = ? AND (T1.STARTDATE IS NULL OR T1.STARTDATE <= CURRENT TIMESTAMP AND (T1.ENDDATE IS NULL OR T1.ENDDATE >= CURRENT TIMESTAMP ORDER BY T1.PRECEDENCE DESC |
java.util.Enumeration | findByStoreNullShipModeAndCurrentTime(java.lang.Integer storeId) Retrieves the ShippingArrangementAccessBeans that match the specified Store, with ShippingMode not specified, and are currently effective. The SQL query used to fetch all the required rows from the SHPARRANGE table is: SELECT * FROM SHPARRANGE T1 WHERE T1.STORE_ID = ? AND T1.SHIPMODE_ID IS NULL AND (T1.STARTDATE IS NULL OR T1.STARTDATE <= CURRENT TIMESTAMP AND (T1.ENDDATE IS NULL OR T1.ENDDATE >= CURRENT TIMESTAMP ORDER BY T1.PRECEDENCE DESC |
java.util.Enumeration | findByStoreShipModeAndCurrentTime(java.lang.Integer storeId, java.lang.Integer shipModeId) Retrieves the ShippingArrangementAccessBeans that match the specified Store and ShippingMode, and are currently effective. The SQL query used to fetch all the required rows from the SHPARRANGE table is: SELECT * FROM SHPARRANGE T1 WHERE T1.STORE_ID = ? AND (T1.SHIPMODE_ID = ? or T1.SHIPMODE_ID IS NULL) AND (T1.STARTDATE IS NULL OR T1.STARTDATE <= CURRENT TIMESTAMP AND (T1.ENDDATE IS NULL OR T1.ENDDATE >= CURRENT TIMESTAMP ORDER BY T1.PRECEDENCE DESC |
java.lang.String | getEndDate() This method provides access to the SHPARRANGE.ENDDATE column of DB2 type TIMESTAMP. |
java.sql.Timestamp | getEndDateInEJBType() This method provides access to the SHPARRANGE.ENDDATE column of DB2 type TIMESTAMP. |
java.lang.String | getField1() This method provides access to the SHPARRANGE.FIELD1 column of DB2 type VARCHAR(254). |
java.lang.String | getField2() This method provides access to the SHPARRANGE.FIELD2 column of DB2 type INTEGER. |
java.lang.Integer | getField2InEJBType() This method provides access to the SHPARRANGE.FIELD2 column of DB2 type INTEGER. |
java.lang.String | getFlags() This method provides access to the SHPARRANGE.FLAGS column of DB2 type INTEGER NOT NULL DEFAULT 0. |
java.lang.Integer | getFlagsInEJBType() This method provides access to the SHPARRANGE.FLAGS column of DB2 type INTEGER NOT NULL DEFAULT 0. |
java.lang.String | getFulfillmentCenterId() This method provides access to the SHPARRANGE.FFMCENTER_ID column of DB2 type INTEGER NOT NULL. |
java.lang.Integer | getFulfillmentCenterIdInEJBType() This method provides access to the SHPARRANGE.FFMCENTER_ID column of DB2 type INTEGER NOT NULL. |
java.lang.String | getPrecedence() This method provides access to the SHPARRANGE.PRECEDENCE column of DB2 type FLOAT NOT NULL DEFAULT 0. |
java.lang.Double | getPrecedenceInEJBType() This method provides access to the SHPARRANGE.PRECEDENCE column of DB2 type FLOAT NOT NULL DEFAULT 0. |
java.lang.String | getShipArrangementId() This method provides access to the SHPARRANGE.SHPARRANGE_ID column of DB2 type INTEGER NOT NULL. |
java.lang.Integer | getShipArrangementIdInEJBType() This method provides access to the SHPARRANGE.SHPARRANGE_ID column of DB2 type INTEGER NOT NULL. |
java.lang.String | getShipModeId() This method provides access to the SHPARRANGE.SHIPMODE_ID column of DB2 type INTEGER. |
java.lang.Integer | getShipModeIdInEJBType() This method provides access to the SHPARRANGE.SHIPMODE_ID column of DB2 type INTEGER. |
java.lang.String | getStartDate() This method provides access to the SHPARRANGE.STARTDATE column of DB2 type TIMESTAMP. |
java.sql.Timestamp | getStartDateInEJBType() This method provides access to the SHPARRANGE.STARTDATE column of DB2 type TIMESTAMP. |
java.lang.String | getStoreId() This method provides access to the SHPARRANGE.STORE_ID column of DB2 type INTEGER NOT NULL. |
java.lang.Integer | getStoreIdInEJBType() This method provides access to the SHPARRANGE.STORE_ID column of DB2 type INTEGER NOT NULL. |
java.lang.String | getTrackingNumber() This method provides access to the SHPARRANGE.TRACKINGNUMBER column of DB2 type VARCHAR(64). |
protected void | instantiateEJB() |
protected boolean | instantiateEJBByPrimaryKey() |
void | refreshCopyHelper() Load data from the EJBObject. |
void | setEndDate(java.lang.String newValue) This method accesses a non-CMP field |
void | setEndDate(java.sql.Timestamp newValue) This method accesses a non-CMP field |
void | setField1(java.lang.String newValue) This method accesses a non-CMP field |
void | setField2(java.lang.Integer newValue) This method accesses a non-CMP field |
void | setField2(java.lang.String newValue) This method accesses a non-CMP field |
void | setFlags(java.lang.Integer newValue) This method accesses a non-CMP field |
void | setFlags(java.lang.String newValue) This method accesses a non-CMP field |
void | setFulfillmentCenterId(java.lang.Integer newValue) This method accesses a non-CMP field |
void | setFulfillmentCenterId(java.lang.String newValue) This method accesses a non-CMP field |
void | setInitKey_shipArrangementId(java.lang.String newValue) Set the primary key for this object |
void | setPrecedence(java.lang.Double newValue) This method accesses a non-CMP field |
void | setPrecedence(java.lang.String newValue) This method accesses a non-CMP field |
void | setShipArrangementId(java.lang.Integer newValue) This method accesses a non-CMP field |
void | setShipArrangementId(java.lang.String newValue) This method accesses a non-CMP field |
void | setShipModeId(java.lang.Integer newValue) This method accesses a non-CMP field |
void | setShipModeId(java.lang.String newValue) This method accesses a non-CMP field |
void | setStartDate(java.lang.String newValue) This method accesses a non-CMP field |
void | setStartDate(java.sql.Timestamp newValue) This method accesses a non-CMP field |
void | setStoreId(java.lang.Integer newValue) This method accesses a non-CMP field |
void | setStoreId(java.lang.String newValue) This method accesses a non-CMP field |
void | setTrackingNumber(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 ShippingArrangementAccessBean()
public ShippingArrangementAccessBean(javax.ejb.EJBObject o) throws java.rmi.RemoteException
public ShippingArrangementAccessBean(java.lang.Integer newFulfillmentCenterId, java.lang.Integer newStoreId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, javax.ejb.FinderException
Creates an access bean with the specified attributes.
public ShippingArrangementAccessBean(java.lang.Integer newFulfillmentCenterId, java.lang.Integer newStoreId, java.lang.Integer newShipModeId, java.sql.Timestamp newStartDate, java.sql.Timestamp newEndDate) throws javax.naming.NamingException, javax.ejb.FinderException, javax.ejb.CreateException, java.rmi.RemoteException
Creates an access bean with the specified attributes.
Method Detail |
public java.util.Enumeration findByStoreAndFulfillmentCenter(java.lang.Integer storeId, java.lang.Integer fulfillmentCenterId) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Retrieves the ShippingArrangementAccessBeans that match the specified Store and FulfillmentCenter.
The SQL query used to fetch all the required rows from the SHPARRANGE table is:
SELECT * FROM SHPARRANGE T1 WHERE T1.STORE_ID = ? AND T1.FFMCENTER_ID = ?
public java.util.Enumeration findByStoreAndShipMode(java.lang.Integer storeId, java.lang.Integer shipModeId) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Retrieves the ShippingArrangementAccessBeans that match the specified Store and ShippingMode.
The SQL query used to fetch all the required rows from the SHPARRANGE table is:
SELECT * FROM SHPARRANGE T1 WHERE T1.STORE_ID = ? AND T1.SHIPMODE_ID = ?
public java.util.Enumeration findByStoreFulfillmentCenterAndShipMode(java.lang.Integer storeId, java.lang.Integer fulfillmentCenterId, java.lang.Integer shipModeId) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Retrieves the ShippingArrangementAccessBeans that match the specified Store, FulfillmentCenter and ShippingMode.
The SQL query used to fetch all the required rows from the SHPARRANGE table is:
SELECT * FROM SHPARRANGE T1 WHERE
T1.STORE_ID = ? AND T1.FFMCENTER_ID = ? AND T1.SHIPMODE_ID = ?
AND (T1.STARTDATE IS NULL OR T1.STARTDATE <= CURRENT TIMESTAMP
AND (T1.ENDDATE IS NULL OR T1.ENDDATE >= CURRENT TIMESTAMP
ORDER BY T1.PRECEDENCE DESC
public java.util.Enumeration findByStoreNullShipModeAndCurrentTime(java.lang.Integer storeId) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Retrieves the ShippingArrangementAccessBeans that match the specified Store, with ShippingMode not specified, and are currently effective.
The SQL query used to fetch all the required rows from the SHPARRANGE table is:
SELECT * FROM SHPARRANGE T1 WHERE
T1.STORE_ID = ? AND T1.SHIPMODE_ID IS NULL
AND (T1.STARTDATE IS NULL OR T1.STARTDATE <= CURRENT TIMESTAMP
AND (T1.ENDDATE IS NULL OR T1.ENDDATE >= CURRENT TIMESTAMP
ORDER BY T1.PRECEDENCE DESC
public java.util.Enumeration findByStoreShipModeAndCurrentTime(java.lang.Integer storeId, java.lang.Integer shipModeId) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Retrieves the ShippingArrangementAccessBeans that match the specified Store and ShippingMode, and are currently effective.
The SQL query used to fetch all the required rows from the SHPARRANGE table is:
SELECT * FROM SHPARRANGE T1 WHERE
T1.STORE_ID = ? AND (T1.SHIPMODE_ID = ? or T1.SHIPMODE_ID IS NULL)
AND (T1.STARTDATE IS NULL OR T1.STARTDATE <= CURRENT TIMESTAMP
AND (T1.ENDDATE IS NULL OR T1.ENDDATE >= CURRENT TIMESTAMP
ORDER BY T1.PRECEDENCE DESC
public void setInitKey_shipArrangementId(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 getShipArrangementId() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the SHPARRANGE.SHPARRANGE_ID column of DB2 type INTEGER NOT NULL.
The following is a description of this column:
Generated unique key.
public java.lang.Integer getShipArrangementIdInEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the SHPARRANGE.SHPARRANGE_ID column of DB2 type INTEGER NOT NULL.
The following is a description of this column:
Generated unique key.
public void setShipArrangementId(java.lang.String newValue)
public void setShipArrangementId(java.lang.Integer newValue)
public java.lang.String getStartDate() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the SHPARRANGE.STARTDATE column of DB2 type TIMESTAMP.
The following is a description of this column:
The time this ShippingArrangement starts being effective.
public java.sql.Timestamp getStartDateInEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the SHPARRANGE.STARTDATE column of DB2 type TIMESTAMP.
The following is a description of this column:
The time this ShippingArrangement starts being effective.
public void setStartDate(java.lang.String newValue)
public void setStartDate(java.sql.Timestamp newValue)
public java.lang.String getField2() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the SHPARRANGE.FIELD2 column of DB2 type INTEGER.
The following is a description of this column:
Customizable.
public java.lang.Integer getField2InEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the SHPARRANGE.FIELD2 column of DB2 type INTEGER.
The following is a description of this column:
Customizable.
public void setField2(java.lang.String newValue)
public void setField2(java.lang.Integer newValue)
public java.lang.String getField1() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the SHPARRANGE.FIELD1 column of DB2 type VARCHAR(254).
The following is a description of this column:
Customizable.
public void setField1(java.lang.String newValue)
public java.lang.String getStoreId() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the SHPARRANGE.STORE_ID column of DB2 type INTEGER NOT NULL.
The following is a description of this column:
The Store.
public java.lang.Integer getStoreIdInEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the SHPARRANGE.STORE_ID column of DB2 type INTEGER NOT NULL.
The following is a description of this column:
The Store.
public void setStoreId(java.lang.String newValue)
public void setStoreId(java.lang.Integer newValue)
public java.lang.String getShipModeId() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the SHPARRANGE.SHIPMODE_ID column of DB2 type INTEGER.
The following is a description of this column:
The ShippingMode. NULL indicates this ShippingArrangement can be used regardless of ShippingMode.
public java.lang.Integer getShipModeIdInEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the SHPARRANGE.SHIPMODE_ID column of DB2 type INTEGER.
The following is a description of this column:
The ShippingMode. NULL indicates this ShippingArrangement can be used regardless of ShippingMode.
public void setShipModeId(java.lang.String newValue)
public void setShipModeId(java.lang.Integer newValue)
public java.lang.String getPrecedence() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the SHPARRANGE.PRECEDENCE column of DB2 type FLOAT NOT NULL DEFAULT 0.
The following is a description of this column:
When more than one ShippingArrangement (for the same Store and ShippingMode) is effective at a particular time, the one with the highest precedence is used.
public java.lang.Double getPrecedenceInEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the SHPARRANGE.PRECEDENCE column of DB2 type FLOAT NOT NULL DEFAULT 0.
The following is a description of this column:
When more than one ShippingArrangement (for the same Store and ShippingMode) is effective at a particular time, the one with the highest precedence is used.
public void setPrecedence(java.lang.String newValue)
public void setPrecedence(java.lang.Double newValue)
public java.lang.String getTrackingNumber() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the SHPARRANGE.TRACKINGNUMBER column of DB2 type VARCHAR(64).
The following is a description of this column:
Reserved for IBM internal use.
public void setTrackingNumber(java.lang.String newValue)
public java.lang.String getFlags() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the SHPARRANGE.FLAGS column of DB2 type INTEGER NOT NULL DEFAULT 0.
The following is a description of this column:
The low order bit contains a flag as follows:&l
public java.lang.Integer getFlagsInEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the SHPARRANGE.FLAGS column of DB2 type INTEGER NOT NULL DEFAULT 0.
The following is a description of this column:
The low order bit contains a flag as follows:&l
public void setFlags(java.lang.String newValue)
public void setFlags(java.lang.Integer newValue)
public java.lang.String getFulfillmentCenterId() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the SHPARRANGE.FFMCENTER_ID column of DB2 type INTEGER NOT NULL.
The following is a description of this column:
The FulfillmentCenter.
public java.lang.Integer getFulfillmentCenterIdInEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the SHPARRANGE.FFMCENTER_ID column of DB2 type INTEGER NOT NULL.
The following is a description of this column:
The FulfillmentCenter.
public void setFulfillmentCenterId(java.lang.String newValue)
public void setFulfillmentCenterId(java.lang.Integer newValue)
public java.lang.String getEndDate() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the SHPARRANGE.ENDDATE column of DB2 type TIMESTAMP.
The following is a description of this column:
The time this ShippingArrangement stops being effective.
public java.sql.Timestamp getEndDateInEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the SHPARRANGE.ENDDATE column of DB2 type TIMESTAMP.
The following is a description of this column:
The time this ShippingArrangement stops being effective.
public void setEndDate(java.lang.String newValue)
public void setEndDate(java.sql.Timestamp newValue)
public java.util.Enumeration findByStoreAndNullShipMode(java.lang.Integer storeId) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
Retrieves the ShippingArrangementAccessBeans that match the specified Store, with ShippingMode not specified.
The SQL query used to fetch all the required rows from the SHPARRANGE table is:
SELECT * FROM SHPARRANGE T1 WHERE
T1.STORE_ID = ? AND T1.SHIPMODE_ID IS NULL
ORDER BY T1.PRECEDENCE DESC
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.