public class FulfillmentJDBCHelperBean extends BaseJDBCHelper
Modifier and Type | Field and Description |
---|---|
static java.lang.String |
COPYRIGHT
Copyright.
|
static java.lang.String |
findCalcodeDescriptionLongDescriptionSQL
sql String
|
static java.lang.String |
findFFMAndOrderItemsList
sql String
|
static java.lang.String |
findFfmcenterByFfmcenterIdAndLanguageId
sql String
|
static java.lang.String |
findFfmcenterIdAndDisplayName
sql String
|
static java.lang.String |
findFfmcenterListByLanguageId
sql String
|
static java.lang.String |
findFfmcenterListByLanguageIdAndStoreId
sql String
|
static java.lang.String |
findFfmcenterNameAndIdByStoreId
sql String
|
static java.lang.String |
findFulfillmentCenterDescriptionDescriptionSQL
sql String
|
static java.lang.String |
findFulfillmentDescriptionByFulfillmentCenterId
sql String
|
static java.lang.String |
findShipModeListByStoreentId
sql String
|
static java.lang.String |
findShipModeListByStoreentIdAndLanguageId
sql String
|
static java.lang.String |
findShipModeListByStoreentIdAndLanguageId_DB2J
sql String
|
static java.lang.String |
findStaddress
sql String
|
static java.lang.String |
updateCalcodeDescriptionLongDescriptionSQL
sql String
|
static java.lang.String |
updateFulfillmentCenterDescriptionDescriptionSQL
sql String
|
autoFlush, DB_AS400, DB_DB2, DB_DB2_390, DB_DB2J, DB_ORACLE
Constructor and Description |
---|
FulfillmentJDBCHelperBean() |
Modifier and Type | Method and Description |
---|---|
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.
|
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.util.Vector |
findFfmcenterNameAndIdByStoreId(java.lang.Integer storeId,
java.lang.String dropShip)
Overloaded finder for dropship flag Creation date: (4/28/04 )
|
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.
|
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) |
buildCommaSeparatedWhereClause, convertResultSetToTable, flush, flush, getCharacterStreamFromResultSet, getDataSource, getDataSource, getInQueryClause, getObject, getObject, getObject, getSavedOptCounterInfoForDelete, getSavedOptCounterInfoForOptimisticSelect, getSavedOptCounterInfoForUpdate, init, init, useCloudscape, useDB2_390, useDB2_400, useDB2, useOracle, useOracle9
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
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 java.util.Vector findFFMAndOrderItemsList(java.lang.Integer languageId, java.lang.Integer storeId) throws java.sql.SQLException, javax.naming.NamingException
java.sql.SQLException
javax.naming.NamingException
public java.util.Vector findFFMAndOrderItemsList(java.lang.Integer languageId, java.lang.Integer storeId, boolean flush) throws java.sql.SQLException, javax.naming.NamingException
java.sql.SQLException
javax.naming.NamingException
public java.util.Vector findFfmcenterByFfmcenterIdAndLanguageId(java.lang.Integer ffmCenterId, java.lang.Integer languageId) throws java.sql.SQLException, javax.naming.NamingException
java.sql.SQLException
javax.naming.NamingException
public java.util.Vector findFfmcenterByFfmcenterIdAndLanguageId(java.lang.Integer ffmCenterId, java.lang.Integer languageId, boolean flush) throws java.sql.SQLException, javax.naming.NamingException
java.sql.SQLException
javax.naming.NamingException
public java.util.Vector findFfmcenterIdAndDisplayName(java.lang.Integer storeId) throws java.sql.SQLException, javax.naming.NamingException
java.sql.SQLException
javax.naming.NamingException
public java.util.Vector findFfmcenterIdAndDisplayName(java.lang.Integer storeId, boolean flush) throws java.sql.SQLException, javax.naming.NamingException
java.sql.SQLException
javax.naming.NamingException
public java.util.Vector findFfmcenterListByLanguageId(java.lang.Integer languageId, java.lang.Integer storeId) throws java.sql.SQLException, javax.naming.NamingException
java.sql.SQLException
javax.naming.NamingException
public java.util.Vector findFfmcenterListByLanguageId(java.lang.Integer languageId, java.lang.Integer storeId, boolean flush) throws java.sql.SQLException, javax.naming.NamingException
java.sql.SQLException
javax.naming.NamingException
public java.util.Vector findFfmcenterListByLanguageIdAndStoreId(java.lang.Integer languageId, java.lang.Integer storeId) throws java.sql.SQLException, javax.naming.NamingException
java.sql.SQLException
javax.naming.NamingException
public java.util.Vector findFfmcenterListByLanguageIdAndStoreId(java.lang.Integer languageId, java.lang.Integer storeId, boolean flush) throws java.sql.SQLException, javax.naming.NamingException
java.sql.SQLException
javax.naming.NamingException
public java.util.Vector findFfmcenterNameAndIdByStoreId(java.lang.Integer storeId, java.lang.String dropShip) throws java.sql.SQLException, javax.naming.NamingException
java.sql.SQLException
javax.naming.NamingException
public java.util.Vector findFfmcenterNameAndIdByStoreId(java.lang.Integer storeId) throws java.sql.SQLException, javax.naming.NamingException
java.sql.SQLException
javax.naming.NamingException
public java.util.Vector findFfmcenterNameAndIdByStoreId(java.lang.Integer storeId, boolean flush) throws java.sql.SQLException, javax.naming.NamingException
java.sql.SQLException
javax.naming.NamingException
public java.util.Vector findFulfillmentDescriptionByFulfillmentCenterId(java.lang.Integer ffmCenterId) throws java.sql.SQLException, javax.naming.NamingException
java.sql.SQLException
javax.naming.NamingException
public java.util.Vector findFulfillmentDescriptionByFulfillmentCenterId(java.lang.Integer ffmCneterId, boolean flush) throws java.sql.SQLException, javax.naming.NamingException
java.sql.SQLException
javax.naming.NamingException
public java.util.Vector findShipModeListByStoreentId(java.lang.Integer storeentId) throws java.sql.SQLException, javax.naming.NamingException
java.sql.SQLException
javax.naming.NamingException
public java.util.Vector findShipModeListByStoreentId(java.lang.Integer storeentId, boolean flush) throws java.sql.SQLException, javax.naming.NamingException
java.sql.SQLException
javax.naming.NamingException
public java.util.Vector findShipModeListByStoreentIdAndLanguageId(java.lang.Integer storeentId, java.lang.Integer languageId) throws java.sql.SQLException, javax.naming.NamingException
java.sql.SQLException
javax.naming.NamingException
public java.util.Vector findShipModeListByStoreentIdAndLanguageId(java.lang.Integer storeentId, java.lang.Integer languageId, boolean flush) throws java.sql.SQLException, javax.naming.NamingException
java.sql.SQLException
javax.naming.NamingException
public java.util.Vector findStaddress(java.lang.Integer ffmCenterId, java.lang.Integer languageId) throws java.sql.SQLException, javax.naming.NamingException
java.sql.SQLException
javax.naming.NamingException
public java.util.Vector findStaddress(java.lang.Integer ffmCneterId, java.lang.Integer languageId, boolean flush) throws java.sql.SQLException, javax.naming.NamingException
java.sql.SQLException
javax.naming.NamingException
public int checkFulfillmentCenterByMemberIdAndFulfillmentCenterId(java.lang.Long memberId, java.lang.Integer ffmcId) throws java.sql.SQLException, javax.naming.NamingException
java.sql.SQLException
javax.naming.NamingException
public int checkFulfillmentCenterByMemberIdAndFulfillmentCenterId(java.lang.Long memberId, java.lang.Integer ffmcId, boolean flush) throws java.sql.SQLException, javax.naming.NamingException
memberId
- java.lang.LongffmcId
- java.lang.Integerjavax.naming.NamingException
- The exception description.java.sql.SQLException
- The exception description.public java.lang.String findCalcodeDescriptionLongDescription(java.lang.Integer aCalcodeId, java.lang.Integer aLanguageId) throws java.sql.SQLException, javax.naming.NamingException
aCalcodeId
- aLanguageId
- javax.naming.NamingException
java.sql.SQLException
public java.lang.String findCalcodeDescriptionLongDescription(java.lang.Integer aCalcodeId, java.lang.Integer aLanguageId, boolean flush) throws java.sql.SQLException, javax.naming.NamingException
aCalcodeId
- aLanguageId
- flush
- javax.naming.NamingException
java.sql.SQLException
public java.lang.String findFulfillmentCenterDescriptionDescription(java.lang.Integer aFulfillmentCenterId, java.lang.Integer aLanguageId) throws java.sql.SQLException, javax.naming.NamingException
aFulfillmentCenterId
- aLanguageId
- javax.naming.NamingException
java.sql.SQLException
public java.lang.String findFulfillmentCenterDescriptionDescription(java.lang.Integer aFulfillmentCenterId, java.lang.Integer aLanguageId, boolean flush) throws java.sql.SQLException, javax.naming.NamingException
aFulfillmentCenterId
- aLanguageId
- flush
- javax.naming.NamingException
java.sql.SQLException
public int updateCalcodeDescriptionLongDescription(java.lang.Integer aCalcodeId, java.lang.Integer aLanguageId, java.lang.String aLongDescription) throws java.sql.SQLException, javax.naming.NamingException
aCalcodeId
- aLanguageId
- aLongDescription
- javax.naming.NamingException
java.sql.SQLException
public int updateCalcodeDescriptionLongDescription(java.lang.Integer aCalcodeId, java.lang.Integer aLanguageId, java.lang.String aLongDescription, boolean flush) throws java.sql.SQLException, javax.naming.NamingException
aCalcodeId
- aLanguageId
- aLongDescription
- flush
- javax.naming.NamingException
java.sql.SQLException
public int updateFulfillmentCenterDescriptionDescription(java.lang.Integer aFulfillmentCenterId, java.lang.Integer aLanguageId, java.lang.String aDescription) throws java.sql.SQLException, javax.naming.NamingException
aFulfillmentCenterId
- aLanguageId
- aDescription
- javax.naming.NamingException
java.sql.SQLException
public int updateFulfillmentCenterDescriptionDescription(java.lang.Integer aFulfillmentCenterId, java.lang.Integer aLanguageId, java.lang.String aDescription, boolean flush) throws java.sql.SQLException, javax.naming.NamingException
aFulfillmentCenterId
- aLanguageId
- aDescription
- flush
- javax.naming.NamingException
java.sql.SQLException