java.lang.Object | +--com.ibm.commerce.base.helpers.BaseJDBCHelper | +--com.ibm.commerce.fulfillment.objects.FulfillmentJDBCHelperBean
This is a Session Bean Class
Field Summary | |
---|---|
static java.lang.String |
COPYRIGHT |
static java.lang.String |
findCalcodeDescriptionLongDescriptionSQL |
static java.lang.String |
findFFMAndOrderItemsList |
static java.lang.String |
findFfmcenterByFfmcenterIdAndLanguageId |
static java.lang.String |
findFfmcenterIdAndDisplayName |
static java.lang.String |
findFfmcenterListByLanguageId |
static java.lang.String |
findFfmcenterListByLanguageIdAndStoreId |
static java.lang.String |
findFfmcenterNameAndIdByStoreId |
static java.lang.String |
findFulfillmentCenterDescriptionDescriptionSQL |
static java.lang.String |
findFulfillmentDescriptionByFulfillmentCenterId |
static java.lang.String |
findShipModeListByStoreentId |
static java.lang.String |
findShipModeListByStoreentIdAndLanguageId |
static java.lang.String |
findShipModeListByStoreentIdAndLanguageId_DB2J |
static java.lang.String |
findStaddress |
static java.lang.String |
updateCalcodeDescriptionLongDescriptionSQL |
static java.lang.String |
updateFulfillmentCenterDescriptionDescriptionSQL |
Fields inherited from class com.ibm.commerce.base.helpers. BaseJDBCHelper |
autoFlush,
DATASOURCE,
dataSourceConfigData,
DB_DB2,
DB_DB2_390,
DB_DB2J,
DB_ORACLE,
DBTYPE,
mySessionCtx |
Constructor Summary | |
---|---|
FulfillmentJDBCHelperBean() |
Method Summary | |
---|---|
int |
checkFulfillmentCenterByMemberIdAndFulfillmentCenterId(java.lang.Long memberId,
java.lang.Integer ffmcId) |
int |
checkFulfillmentCenterByMemberIdAndFulfillmentCenterId(java.lang.Long memberId,
java.lang.Integer ffmcId, boolean flush) Insert the method's description here. |
static java.util.Vector |
convertResultSetToTableForAvailableReceiptMaxAndMinPrecedence(java.sql.ResultSet rs) Insert the method's description here. |
static java.util.Vector |
convertResultSetToTableForFFMAndOrderItems(java.sql.ResultSet rs) Insert the method's description here. |
static java.util.Vector |
convertResultSetToTableForFfmcenterByFfmcenterIdAndLanguageId(java.sql.ResultSet rs) Insert the method's description here. |
static java.util.Vector |
convertResultSetToTableForFfmcenterIdAndDisplayName(java.sql.ResultSet rs) Insert the method's description here. |
static java.util.Vector |
convertResultSetToTableForFfmcenterListByLanguageId(java.sql.ResultSet rs) Insert the method's description here. |
static java.util.Vector |
convertResultSetToTableForFfmcenterListByLanguageIdAndStoreId(java.sql.ResultSet rs) Insert the method's description here. |
static java.util.Vector |
convertResultSetToTableForFfmcenterNameAndIdByStoreId(java.sql.ResultSet rs) Insert the method's description here. |
static java.util.Vector |
convertResultSetToTableForFulfillmentDescriptionByFulfillmentCenterId(java.sql.ResultSet rs) Insert the method's description here. |
static java.util.Vector |
convertResultSetToTableForShipModeListByStoreentId(java.sql.ResultSet rs) Insert the method's description here. |
static java.util.Vector |
convertResultSetToTableForShipModeListByStoreentIdAndLanguageId(java.sql.ResultSet rs) Insert the method's description here. |
static java.util.Vector |
convertResultSetToTableForStaddress(java.sql.ResultSet rs) Insert the method's description here. |
void |
ejbActivate() ejbActivate method comment |
void |
ejbCreate() ejbCreate method comment |
void |
ejbPassivate() ejbPassivate method comment |
void |
ejbRemove() ejbRemove method comment |
java.lang.String |
findCalcodeDescriptionLongDescription(java.lang.Integer aCalcodeId,
java.lang.Integer aLanguageId) |
java.lang.String |
findCalcodeDescriptionLongDescription(java.lang.Integer aCalcodeId,
java.lang.Integer aLanguageId, boolean flush) |
java.util.Vector |
findFFMAndOrderItemsList(java.lang.Integer languageId,
java.lang.Integer storeId) Insert the method's description here. |
java.util.Vector |
findFFMAndOrderItemsList(java.lang.Integer languageId,
java.lang.Integer storeId, boolean flush) Insert the method's description here. |
java.util.Vector |
findFfmcenterByFfmcenterIdAndLanguageId(java.lang.Integer ffmCenterId,
java.lang.Integer languageId) Insert the method's description here. |
java.util.Vector |
findFfmcenterByFfmcenterIdAndLanguageId(java.lang.Integer ffmCenterId,
java.lang.Integer languageId, boolean flush) Insert the method's description here. |
java.util.Vector |
findFfmcenterIdAndDisplayName(java.lang.Integer storeId) Insert the method's description here. |
java.util.Vector |
findFfmcenterIdAndDisplayName(java.lang.Integer storeId,
boolean flush) Insert the method's description here. |
java.util.Vector |
findFfmcenterListByLanguageId(java.lang.Integer languageId,
java.lang.Integer storeId) Insert the method's description here. |
java.util.Vector |
findFfmcenterListByLanguageId(java.lang.Integer languageId,
java.lang.Integer storeId, boolean flush) Insert the method's description here. |
java.util.Vector |
findFfmcenterListByLanguageIdAndStoreId(java.lang.Integer languageId,
java.lang.Integer storeId) Insert the method's description here. |
java.util.Vector |
findFfmcenterListByLanguageIdAndStoreId(java.lang.Integer languageId,
java.lang.Integer storeId, boolean flush) Insert the method's description here. |
java.util.Vector |
findFfmcenterNameAndIdByStoreId(java.lang.Integer storeId) Insert the method's description here. |
java.util.Vector |
findFfmcenterNameAndIdByStoreId(java.lang.Integer storeId,
boolean flush) Insert the method's description here. |
java.lang.String |
findFulfillmentCenterDescriptionDescription(java.lang.Integer aFulfillmentCenterId,
java.lang.Integer aLanguageId) |
java.lang.String |
findFulfillmentCenterDescriptionDescription(java.lang.Integer aFulfillmentCenterId,
java.lang.Integer aLanguageId, boolean flush) |
java.util.Vector |
findFulfillmentDescriptionByFulfillmentCenterId(java.lang.Integer ffmCenterId) Insert the method's description here. |
java.util.Vector |
findFulfillmentDescriptionByFulfillmentCenterId(java.lang.Integer ffmCneterId,
boolean flush) Insert the method's description here. |
java.util.Vector |
findShipModeListByStoreentId(java.lang.Integer storeentId) Insert the method's description here. |
java.util.Vector |
findShipModeListByStoreentId(java.lang.Integer storeentId,
boolean flush) Insert the method's description here. |
java.util.Vector |
findShipModeListByStoreentIdAndLanguageId(java.lang.Integer storeentId,
java.lang.Integer languageId) Insert the method's description here. |
java.util.Vector |
findShipModeListByStoreentIdAndLanguageId(java.lang.Integer storeentId,
java.lang.Integer languageId, boolean flush) Insert the method's description here. |
java.util.Vector |
findStaddress(java.lang.Integer ffmCenterId,
java.lang.Integer languageId) Insert the method's description here. |
java.util.Vector |
findStaddress(java.lang.Integer ffmCneterId,
java.lang.Integer languageId, boolean flush) Insert the method's description here. |
javax.ejb.SessionContext |
getSessionContext() getSessionContext method comment |
void |
setSessionContext(javax.ejb.SessionContext ctx) setSessionContext method comment |
int |
updateCalcodeDescriptionLongDescription(java.lang.Integer aCalcodeId,
java.lang.Integer aLanguageId, java.lang.String aLongDescription) |
int |
updateCalcodeDescriptionLongDescription(java.lang.Integer aCalcodeId,
java.lang.Integer aLanguageId, java.lang.String aLongDescription,
boolean flush) |
int |
updateFulfillmentCenterDescriptionDescription(java.lang.Integer aFulfillmentCenterId,
java.lang.Integer aLanguageId, java.lang.String aDescription) |
int |
updateFulfillmentCenterDescriptionDescription(java.lang.Integer aFulfillmentCenterId,
java.lang.Integer aLanguageId, java.lang.String aDescription,
boolean flush) |
Methods inherited from class com.ibm.commerce.base.helpers. BaseJDBCHelper |
buildCommaSeparatedWhereClause,
closeConnection,
convertFirstRowToHashtable,
convertResultSetToTable,
convertRowFromHashtable,
debugInitConnection,
executeQuery,
executeUpdate,
flush,
getCallableStatement,
getCharacterStreamFromResultSet,
getConnection,
getDataSource,
getPreparedStatement,
getPreparedStatement,
init,
init,
makeConnection,
useCloudscape,
useDB2_390,
useDB2,
useOracle |
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll,
toString, wait, wait, wait |
Field Detail |
---|
public static final java.lang.String COPYRIGHT
public static final java.lang.String findFFMAndOrderItemsList
public static final java.lang.String findFfmcenterIdAndDisplayName
public static final java.lang.String findShipModeListByStoreentIdAndLanguageId
public static final java.lang.String findShipModeListByStoreentIdAndLanguageId_DB2J
public static final java.lang.String findFfmcenterNameAndIdByStoreId
public static final java.lang.String findFfmcenterListByLanguageId
public static final java.lang.String findFfmcenterListByLanguageIdAndStoreId
public static final java.lang.String findFfmcenterByFfmcenterIdAndLanguageId
public static final java.lang.String findStaddress
public static final java.lang.String findShipModeListByStoreentId
public static final java.lang.String findFulfillmentDescriptionByFulfillmentCenterId
public static final java.lang.String findCalcodeDescriptionLongDescriptionSQL
public static final java.lang.String updateCalcodeDescriptionLongDescriptionSQL
public static final java.lang.String findFulfillmentCenterDescriptionDescriptionSQL
public static final java.lang.String updateFulfillmentCenterDescriptionDescriptionSQL
Constructor Detail |
---|
public FulfillmentJDBCHelperBean()
Method Detail |
---|
public static java.util.Vector convertResultSetToTableForAvailableReceiptMaxAndMinPrecedence(java.sql.ResultSet rs) throws java.sql.SQLException
rs
- java.sql.ResultSetjava.sql.SQLException
public static java.util.Vector convertResultSetToTableForFFMAndOrderItems(java.sql.ResultSet rs) throws java.sql.SQLException
rs
- java.sql.ResultSetjava.sql.SQLException
public static java.util.Vector convertResultSetToTableForFfmcenterByFfmcenterIdAndLanguageId(java.sql.ResultSet rs) throws java.sql.SQLException
rs
- java.sql.ResultSetjava.sql.SQLException
public static java.util.Vector convertResultSetToTableForFfmcenterIdAndDisplayName(java.sql.ResultSet rs) throws java.sql.SQLException
rs
- java.sql.ResultSetjava.sql.SQLException
public static java.util.Vector convertResultSetToTableForFfmcenterListByLanguageId(java.sql.ResultSet rs) throws java.sql.SQLException
rs
- java.sql.ResultSetjava.sql.SQLException
public static java.util.Vector convertResultSetToTableForFfmcenterListByLanguageIdAndStoreId(java.sql.ResultSet rs) throws java.sql.SQLException
rs
- java.sql.ResultSetjava.sql.SQLException
public static java.util.Vector convertResultSetToTableForFfmcenterNameAndIdByStoreId(java.sql.ResultSet rs) throws java.sql.SQLException
rs
- java.sql.ResultSetjava.sql.SQLException
public static java.util.Vector convertResultSetToTableForFulfillmentDescriptionByFulfillmentCenterId(java.sql.ResultSet rs) throws java.sql.SQLException
rs
- java.sql.ResultSetjava.sql.SQLException
public static java.util.Vector convertResultSetToTableForShipModeListByStoreentId(java.sql.ResultSet rs) throws java.sql.SQLException
rs
- java.sql.ResultSetjava.sql.SQLException
public static java.util.Vector convertResultSetToTableForShipModeListByStoreentIdAndLanguageId(java.sql.ResultSet rs) throws java.sql.SQLException
rs
- java.sql.ResultSetjava.sql.SQLException
public static java.util.Vector convertResultSetToTableForStaddress(java.sql.ResultSet rs) throws java.sql.SQLException
rs
- java.sql.ResultSetjava.sql.SQLException
public void ejbActivate()
java.rmi.RemoteException
- The exception
description.public void ejbCreate() throws javax.ejb.CreateException
javax.ejb.CreateException
- The exception description.java.rmi.RemoteException
- The exception
description.public void ejbPassivate()
java.rmi.RemoteException
- The exception
description.public void ejbRemove()
java.rmi.RemoteException
- The exception
description.public java.lang.String findCalcodeDescriptionLongDescription(java.lang.Integer aCalcodeId, java.lang.Integer aLanguageId) throws javax.naming.NamingException, java.sql.SQLException
javax.naming.NamingException
java.sql.SQLException
public java.lang.String findCalcodeDescriptionLongDescription(java.lang.Integer aCalcodeId, java.lang.Integer aLanguageId, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
javax.naming.NamingException
java.sql.SQLException
public java.util.Vector findFFMAndOrderItemsList(java.lang.Integer languageId, java.lang.Integer storeId) throws javax.naming.NamingException, java.sql.SQLException
javax.naming.NamingException
java.sql.SQLException
public java.util.Vector findFFMAndOrderItemsList(java.lang.Integer languageId, java.lang.Integer storeId, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
javax.naming.NamingException
java.sql.SQLException
public java.util.Vector findFfmcenterByFfmcenterIdAndLanguageId(java.lang.Integer ffmCenterId, java.lang.Integer languageId) throws javax.naming.NamingException, java.sql.SQLException
javax.naming.NamingException
java.sql.SQLException
public java.util.Vector findFfmcenterByFfmcenterIdAndLanguageId(java.lang.Integer ffmCenterId, java.lang.Integer languageId, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
javax.naming.NamingException
java.sql.SQLException
public java.util.Vector findFfmcenterIdAndDisplayName(java.lang.Integer storeId) throws javax.naming.NamingException, java.sql.SQLException
javax.naming.NamingException
java.sql.SQLException
public java.util.Vector findFfmcenterIdAndDisplayName(java.lang.Integer storeId, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
javax.naming.NamingException
java.sql.SQLException
public java.util.Vector findFfmcenterListByLanguageId(java.lang.Integer languageId, java.lang.Integer storeId) throws javax.naming.NamingException, java.sql.SQLException
javax.naming.NamingException
java.sql.SQLException
public java.util.Vector findFfmcenterListByLanguageId(java.lang.Integer languageId, java.lang.Integer storeId, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
javax.naming.NamingException
java.sql.SQLException
public java.util.Vector findFfmcenterListByLanguageIdAndStoreId(java.lang.Integer languageId, java.lang.Integer storeId) throws javax.naming.NamingException, java.sql.SQLException
javax.naming.NamingException
java.sql.SQLException
public java.util.Vector findFfmcenterListByLanguageIdAndStoreId(java.lang.Integer languageId, java.lang.Integer storeId, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
javax.naming.NamingException
java.sql.SQLException
public java.util.Vector findFfmcenterNameAndIdByStoreId(java.lang.Integer storeId) throws javax.naming.NamingException, java.sql.SQLException
javax.naming.NamingException
java.sql.SQLException
public java.util.Vector findFfmcenterNameAndIdByStoreId(java.lang.Integer storeId, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
javax.naming.NamingException
java.sql.SQLException
public java.lang.String findFulfillmentCenterDescriptionDescription(java.lang.Integer aFulfillmentCenterId, java.lang.Integer aLanguageId) throws javax.naming.NamingException, java.sql.SQLException
javax.naming.NamingException
java.sql.SQLException
public java.lang.String findFulfillmentCenterDescriptionDescription(java.lang.Integer aFulfillmentCenterId, java.lang.Integer aLanguageId, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
javax.naming.NamingException
java.sql.SQLException
public java.util.Vector findFulfillmentDescriptionByFulfillmentCenterId(java.lang.Integer ffmCenterId) throws javax.naming.NamingException, java.sql.SQLException
javax.naming.NamingException
java.sql.SQLException
public java.util.Vector findFulfillmentDescriptionByFulfillmentCenterId(java.lang.Integer ffmCneterId, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
javax.naming.NamingException
java.sql.SQLException
public java.util.Vector findShipModeListByStoreentId(java.lang.Integer storeentId) throws javax.naming.NamingException, java.sql.SQLException
javax.naming.NamingException
java.sql.SQLException
public java.util.Vector findShipModeListByStoreentId(java.lang.Integer storeentId, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
javax.naming.NamingException
java.sql.SQLException
public java.util.Vector findShipModeListByStoreentIdAndLanguageId(java.lang.Integer storeentId, java.lang.Integer languageId) throws javax.naming.NamingException, java.sql.SQLException
javax.naming.NamingException
java.sql.SQLException
public java.util.Vector findShipModeListByStoreentIdAndLanguageId(java.lang.Integer storeentId, java.lang.Integer languageId, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
javax.naming.NamingException
java.sql.SQLException
public java.util.Vector findStaddress(java.lang.Integer ffmCenterId, java.lang.Integer languageId) throws javax.naming.NamingException, java.sql.SQLException
javax.naming.NamingException
java.sql.SQLException
public java.util.Vector findStaddress(java.lang.Integer ffmCneterId, java.lang.Integer languageId, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
javax.naming.NamingException
java.sql.SQLException
public int checkFulfillmentCenterByMemberIdAndFulfillmentCenterId(java.lang.Long memberId, java.lang.Integer ffmcId) throws javax.naming.NamingException, java.sql.SQLException
javax.naming.NamingException
java.sql.SQLException
public int checkFulfillmentCenterByMemberIdAndFulfillmentCenterId(java.lang.Long memberId, java.lang.Integer ffmcId, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
memberId
- java.lang.LongffmcId
- java.lang.Integerjavax.naming.NamingException
- The exception description.java.rmi.RemoteException
- The exception description.java.sql.SQLException
- The exception
description.public javax.ejb.SessionContext getSessionContext()
getSessionContext
in class
BaseJDBCHelper
public void setSessionContext(javax.ejb.SessionContext ctx)
ctx
- javax.ejb.SessionContextjava.rmi.RemoteException
- The exception
description.public int updateCalcodeDescriptionLongDescription(java.lang.Integer aCalcodeId, java.lang.Integer aLanguageId, java.lang.String aLongDescription) throws javax.naming.NamingException, java.sql.SQLException
javax.naming.NamingException
java.sql.SQLException
public int updateCalcodeDescriptionLongDescription(java.lang.Integer aCalcodeId, java.lang.Integer aLanguageId, java.lang.String aLongDescription, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
javax.naming.NamingException
java.sql.SQLException
public int updateFulfillmentCenterDescriptionDescription(java.lang.Integer aFulfillmentCenterId, java.lang.Integer aLanguageId, java.lang.String aDescription) throws javax.naming.NamingException, java.sql.SQLException
javax.naming.NamingException
java.sql.SQLException
public int updateFulfillmentCenterDescriptionDescription(java.lang.Integer aFulfillmentCenterId, java.lang.Integer aLanguageId, java.lang.String aDescription, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
javax.naming.NamingException
java.sql.SQLException