com.ibm.commerce.fulfillment.objects

Class FulfillmentJDBCHelperBean

    • Field Detail

      • findFFMAndOrderItemsList

        public static final java.lang.String findFFMAndOrderItemsList
        sql String
        See Also:
        Constant Field Values
      • findFfmcenterIdAndDisplayName

        public static final java.lang.String findFfmcenterIdAndDisplayName
        sql String
        See Also:
        Constant Field Values
      • findShipModeListByStoreentIdAndLanguageId

        public static final java.lang.String findShipModeListByStoreentIdAndLanguageId
        sql String
        See Also:
        Constant Field Values
      • findShipModeListByStoreentIdAndLanguageId_DB2J

        public static final java.lang.String findShipModeListByStoreentIdAndLanguageId_DB2J
        sql String
        See Also:
        Constant Field Values
      • findFfmcenterNameAndIdByStoreId

        public static final java.lang.String findFfmcenterNameAndIdByStoreId
        sql String
        See Also:
        Constant Field Values
      • findFfmcenterListByLanguageId

        public static final java.lang.String findFfmcenterListByLanguageId
        sql String
        See Also:
        Constant Field Values
      • findFfmcenterListByLanguageIdAndStoreId

        public static final java.lang.String findFfmcenterListByLanguageIdAndStoreId
        sql String
        See Also:
        Constant Field Values
      • findFfmcenterByFfmcenterIdAndLanguageId

        public static final java.lang.String findFfmcenterByFfmcenterIdAndLanguageId
        sql String
        See Also:
        Constant Field Values
      • findStaddress

        public static final java.lang.String findStaddress
        sql String
        See Also:
        Constant Field Values
      • findShipModeListByStoreentId

        public static final java.lang.String findShipModeListByStoreentId
        sql String
        See Also:
        Constant Field Values
      • findFulfillmentDescriptionByFulfillmentCenterId

        public static final java.lang.String findFulfillmentDescriptionByFulfillmentCenterId
        sql String
        See Also:
        Constant Field Values
      • findCalcodeDescriptionLongDescriptionSQL

        public static final java.lang.String findCalcodeDescriptionLongDescriptionSQL
        sql String
        See Also:
        Constant Field Values
      • updateCalcodeDescriptionLongDescriptionSQL

        public static final java.lang.String updateCalcodeDescriptionLongDescriptionSQL
        sql String
        See Also:
        Constant Field Values
      • findFulfillmentCenterDescriptionDescriptionSQL

        public static final java.lang.String findFulfillmentCenterDescriptionDescriptionSQL
        sql String
        See Also:
        Constant Field Values
      • updateFulfillmentCenterDescriptionDescriptionSQL

        public static final java.lang.String updateFulfillmentCenterDescriptionDescriptionSQL
        sql String
        See Also:
        Constant Field Values
    • Constructor Detail

      • FulfillmentJDBCHelperBean

        public FulfillmentJDBCHelperBean()
    • Method Detail

      • convertResultSetToTableForAvailableReceiptMaxAndMinPrecedence

        public static java.util.Vector convertResultSetToTableForAvailableReceiptMaxAndMinPrecedence(java.sql.ResultSet rs)
                                                                                              throws java.sql.SQLException
        Insert the method's description here. Creation date: (9/5/2001 9:03:07 PM)
        Parameters:
        rs - java.sql.ResultSet
        Returns:
        java.util.Vector
        Throws:
        java.sql.SQLException
      • convertResultSetToTableForFFMAndOrderItems

        public static java.util.Vector convertResultSetToTableForFFMAndOrderItems(java.sql.ResultSet rs)
                                                                           throws java.sql.SQLException
        Insert the method's description here. Creation date: (2/15/2002 1:03:07 PM)
        Parameters:
        rs - java.sql.ResultSet
        Returns:
        java.util.Vector
        Throws:
        java.sql.SQLException
      • convertResultSetToTableForFfmcenterByFfmcenterIdAndLanguageId

        public static java.util.Vector convertResultSetToTableForFfmcenterByFfmcenterIdAndLanguageId(java.sql.ResultSet rs)
                                                                                              throws java.sql.SQLException
        Insert the method's description here. Creation date: (9/5/2001 9:03:07 PM)
        Parameters:
        rs - java.sql.ResultSet
        Returns:
        java.util.Vector
        Throws:
        java.sql.SQLException
      • convertResultSetToTableForFfmcenterIdAndDisplayName

        public static java.util.Vector convertResultSetToTableForFfmcenterIdAndDisplayName(java.sql.ResultSet rs)
                                                                                    throws java.sql.SQLException
        Insert the method's description here. Creation date: (9/5/2001 9:03:07 PM)
        Parameters:
        rs - java.sql.ResultSet
        Returns:
        java.util.Vector
        Throws:
        java.sql.SQLException
      • convertResultSetToTableForFfmcenterListByLanguageId

        public static java.util.Vector convertResultSetToTableForFfmcenterListByLanguageId(java.sql.ResultSet rs)
                                                                                    throws java.sql.SQLException
        Insert the method's description here. Creation date: (9/5/2001 9:03:07 PM)
        Parameters:
        rs - java.sql.ResultSet
        Returns:
        java.util.Vector
        Throws:
        java.sql.SQLException
      • convertResultSetToTableForFfmcenterListByLanguageIdAndStoreId

        public static java.util.Vector convertResultSetToTableForFfmcenterListByLanguageIdAndStoreId(java.sql.ResultSet rs)
                                                                                              throws java.sql.SQLException
        Insert the method's description here. Creation date: (9/5/2001 9:03:07 PM)
        Parameters:
        rs - java.sql.ResultSet
        Returns:
        java.util.Vector
        Throws:
        java.sql.SQLException
      • convertResultSetToTableForFfmcenterNameAndIdByStoreId

        public static java.util.Vector convertResultSetToTableForFfmcenterNameAndIdByStoreId(java.sql.ResultSet rs)
                                                                                      throws java.sql.SQLException
        Insert the method's description here. Creation date: (9/5/2001 9:03:07 PM)
        Parameters:
        rs - java.sql.ResultSet
        Returns:
        java.util.Vector
        Throws:
        java.sql.SQLException
      • convertResultSetToTableForFulfillmentDescriptionByFulfillmentCenterId

        public static java.util.Vector convertResultSetToTableForFulfillmentDescriptionByFulfillmentCenterId(java.sql.ResultSet rs)
                                                                                                      throws java.sql.SQLException
        Insert the method's description here. Creation date: (9/5/2001 9:03:07 PM)
        Parameters:
        rs - java.sql.ResultSet
        Returns:
        java.util.Vector
        Throws:
        java.sql.SQLException
      • convertResultSetToTableForShipModeListByStoreentId

        public static java.util.Vector convertResultSetToTableForShipModeListByStoreentId(java.sql.ResultSet rs)
                                                                                   throws java.sql.SQLException
        Insert the method's description here. Creation date: (9/5/2001 9:03:07 PM)
        Parameters:
        rs - java.sql.ResultSet
        Returns:
        java.util.Vector
        Throws:
        java.sql.SQLException
      • convertResultSetToTableForShipModeListByStoreentIdAndLanguageId

        public static java.util.Vector convertResultSetToTableForShipModeListByStoreentIdAndLanguageId(java.sql.ResultSet rs)
                                                                                                throws java.sql.SQLException
        Insert the method's description here. Creation date: (9/5/2001 9:03:07 PM)
        Parameters:
        rs - java.sql.ResultSet
        Returns:
        java.util.Vector
        Throws:
        java.sql.SQLException
      • convertResultSetToTableForStaddress

        public static java.util.Vector convertResultSetToTableForStaddress(java.sql.ResultSet rs)
                                                                    throws java.sql.SQLException
        Insert the method's description here. Creation date: (9/5/2001 9:03:07 PM)
        Parameters:
        rs - java.sql.ResultSet
        Returns:
        java.util.Vector
        Throws:
        java.sql.SQLException
      • findFFMAndOrderItemsList

        public java.util.Vector findFFMAndOrderItemsList(java.lang.Integer languageId,
                                                         java.lang.Integer storeId)
                                                  throws java.sql.SQLException,
                                                         javax.naming.NamingException
        Insert the method's description here. Creation date: (3/15/01 10:37:28 AM)
        Returns:
        java.util.Vector
        Throws:
        java.sql.SQLException
        javax.naming.NamingException
      • findFFMAndOrderItemsList

        public java.util.Vector findFFMAndOrderItemsList(java.lang.Integer languageId,
                                                         java.lang.Integer storeId,
                                                         boolean flush)
                                                  throws java.sql.SQLException,
                                                         javax.naming.NamingException
        Insert the method's description here. Creation date: (3/15/01 10:37:28 AM)
        Returns:
        java.util.Vector
        Throws:
        java.sql.SQLException
        javax.naming.NamingException
      • findFfmcenterByFfmcenterIdAndLanguageId

        public java.util.Vector findFfmcenterByFfmcenterIdAndLanguageId(java.lang.Integer ffmCenterId,
                                                                        java.lang.Integer languageId)
                                                                 throws java.sql.SQLException,
                                                                        javax.naming.NamingException
        Insert the method's description here. Creation date: (3/15/01 10:37:28 AM)
        Returns:
        java.util.Vector
        Throws:
        java.sql.SQLException
        javax.naming.NamingException
      • findFfmcenterByFfmcenterIdAndLanguageId

        public java.util.Vector findFfmcenterByFfmcenterIdAndLanguageId(java.lang.Integer ffmCenterId,
                                                                        java.lang.Integer languageId,
                                                                        boolean flush)
                                                                 throws java.sql.SQLException,
                                                                        javax.naming.NamingException
        Insert the method's description here. Creation date: (3/15/01 10:37:28 AM)
        Returns:
        java.util.Vector
        Throws:
        java.sql.SQLException
        javax.naming.NamingException
      • findFfmcenterIdAndDisplayName

        public java.util.Vector findFfmcenterIdAndDisplayName(java.lang.Integer storeId)
                                                       throws java.sql.SQLException,
                                                              javax.naming.NamingException
        Insert the method's description here. Creation date: (3/15/01 10:37:28 AM)
        Returns:
        java.util.Vector
        Throws:
        java.sql.SQLException
        javax.naming.NamingException
      • findFfmcenterIdAndDisplayName

        public java.util.Vector findFfmcenterIdAndDisplayName(java.lang.Integer storeId,
                                                              boolean flush)
                                                       throws java.sql.SQLException,
                                                              javax.naming.NamingException
        Insert the method's description here. Creation date: (3/15/01 10:37:28 AM)
        Returns:
        java.util.Vector
        Throws:
        java.sql.SQLException
        javax.naming.NamingException
      • findFfmcenterListByLanguageId

        public java.util.Vector findFfmcenterListByLanguageId(java.lang.Integer languageId,
                                                              java.lang.Integer storeId)
                                                       throws java.sql.SQLException,
                                                              javax.naming.NamingException
        Insert the method's description here. Creation date: (3/15/01 10:37:28 AM)
        Returns:
        java.util.Vector
        Throws:
        java.sql.SQLException
        javax.naming.NamingException
      • findFfmcenterListByLanguageId

        public java.util.Vector findFfmcenterListByLanguageId(java.lang.Integer languageId,
                                                              java.lang.Integer storeId,
                                                              boolean flush)
                                                       throws java.sql.SQLException,
                                                              javax.naming.NamingException
        Insert the method's description here. Creation date: (3/15/01 10:37:28 AM)
        Returns:
        java.util.Vector
        Throws:
        java.sql.SQLException
        javax.naming.NamingException
      • findFfmcenterListByLanguageIdAndStoreId

        public java.util.Vector findFfmcenterListByLanguageIdAndStoreId(java.lang.Integer languageId,
                                                                        java.lang.Integer storeId)
                                                                 throws java.sql.SQLException,
                                                                        javax.naming.NamingException
        Insert the method's description here. Creation date: (3/15/01 10:37:28 AM)
        Returns:
        java.util.Vector
        Throws:
        java.sql.SQLException
        javax.naming.NamingException
      • findFfmcenterListByLanguageIdAndStoreId

        public java.util.Vector findFfmcenterListByLanguageIdAndStoreId(java.lang.Integer languageId,
                                                                        java.lang.Integer storeId,
                                                                        boolean flush)
                                                                 throws java.sql.SQLException,
                                                                        javax.naming.NamingException
        Insert the method's description here. Creation date: (3/15/01 10:37:28 AM)
        Returns:
        java.util.Vector
        Throws:
        java.sql.SQLException
        javax.naming.NamingException
      • findFfmcenterNameAndIdByStoreId

        public java.util.Vector findFfmcenterNameAndIdByStoreId(java.lang.Integer storeId,
                                                                java.lang.String dropShip)
                                                         throws java.sql.SQLException,
                                                                javax.naming.NamingException
        Overloaded finder for dropship flag Creation date: (4/28/04 )
        Returns:
        java.util.Vector
        Throws:
        java.sql.SQLException
        javax.naming.NamingException
      • findFfmcenterNameAndIdByStoreId

        public java.util.Vector findFfmcenterNameAndIdByStoreId(java.lang.Integer storeId)
                                                         throws java.sql.SQLException,
                                                                javax.naming.NamingException
        Insert the method's description here. Creation date: (3/15/01 10:37:28 AM)
        Returns:
        java.util.Vector
        Throws:
        java.sql.SQLException
        javax.naming.NamingException
      • findFfmcenterNameAndIdByStoreId

        public java.util.Vector findFfmcenterNameAndIdByStoreId(java.lang.Integer storeId,
                                                                boolean flush)
                                                         throws java.sql.SQLException,
                                                                javax.naming.NamingException
        Insert the method's description here. Creation date: (3/15/01 10:37:28 AM)
        Returns:
        java.util.Vector
        Throws:
        java.sql.SQLException
        javax.naming.NamingException
      • findFulfillmentDescriptionByFulfillmentCenterId

        public java.util.Vector findFulfillmentDescriptionByFulfillmentCenterId(java.lang.Integer ffmCenterId)
                                                                         throws java.sql.SQLException,
                                                                                javax.naming.NamingException
        Insert the method's description here. Creation date: (3/15/01 10:37:28 AM)
        Returns:
        java.util.Vector
        Throws:
        java.sql.SQLException
        javax.naming.NamingException
      • findFulfillmentDescriptionByFulfillmentCenterId

        public java.util.Vector findFulfillmentDescriptionByFulfillmentCenterId(java.lang.Integer ffmCneterId,
                                                                                boolean flush)
                                                                         throws java.sql.SQLException,
                                                                                javax.naming.NamingException
        Insert the method's description here. Creation date: (3/15/01 10:37:28 AM)
        Returns:
        java.util.Vector
        Throws:
        java.sql.SQLException
        javax.naming.NamingException
      • findShipModeListByStoreentId

        public java.util.Vector findShipModeListByStoreentId(java.lang.Integer storeentId)
                                                      throws java.sql.SQLException,
                                                             javax.naming.NamingException
        Insert the method's description here. Creation date: (3/15/01 10:37:28 AM)
        Returns:
        java.util.Vector
        Throws:
        java.sql.SQLException
        javax.naming.NamingException
      • findShipModeListByStoreentId

        public java.util.Vector findShipModeListByStoreentId(java.lang.Integer storeentId,
                                                             boolean flush)
                                                      throws java.sql.SQLException,
                                                             javax.naming.NamingException
        Insert the method's description here. Creation date: (3/15/01 10:37:28 AM)
        Returns:
        java.util.Vector
        Throws:
        java.sql.SQLException
        javax.naming.NamingException
      • findShipModeListByStoreentIdAndLanguageId

        public java.util.Vector findShipModeListByStoreentIdAndLanguageId(java.lang.Integer storeentId,
                                                                          java.lang.Integer languageId)
                                                                   throws java.sql.SQLException,
                                                                          javax.naming.NamingException
        Insert the method's description here. Creation date: (3/15/01 10:37:28 AM)
        Returns:
        java.util.Vector
        Throws:
        java.sql.SQLException
        javax.naming.NamingException
      • findShipModeListByStoreentIdAndLanguageId

        public java.util.Vector findShipModeListByStoreentIdAndLanguageId(java.lang.Integer storeentId,
                                                                          java.lang.Integer languageId,
                                                                          boolean flush)
                                                                   throws java.sql.SQLException,
                                                                          javax.naming.NamingException
        Insert the method's description here. Creation date: (3/15/01 10:37:28 AM)
        Returns:
        java.util.Vector
        Throws:
        java.sql.SQLException
        javax.naming.NamingException
      • findStaddress

        public java.util.Vector findStaddress(java.lang.Integer ffmCenterId,
                                              java.lang.Integer languageId)
                                       throws java.sql.SQLException,
                                              javax.naming.NamingException
        Insert the method's description here. Creation date: (3/15/01 10:37:28 AM)
        Returns:
        java.util.Vector
        Throws:
        java.sql.SQLException
        javax.naming.NamingException
      • findStaddress

        public java.util.Vector findStaddress(java.lang.Integer ffmCneterId,
                                              java.lang.Integer languageId,
                                              boolean flush)
                                       throws java.sql.SQLException,
                                              javax.naming.NamingException
        Insert the method's description here. Creation date: (3/15/01 10:37:28 AM)
        Returns:
        java.util.Vector
        Throws:
        java.sql.SQLException
        javax.naming.NamingException
      • checkFulfillmentCenterByMemberIdAndFulfillmentCenterId

        public int checkFulfillmentCenterByMemberIdAndFulfillmentCenterId(java.lang.Long memberId,
                                                                          java.lang.Integer ffmcId)
                                                                   throws java.sql.SQLException,
                                                                          javax.naming.NamingException
        Throws:
        java.sql.SQLException
        javax.naming.NamingException
      • checkFulfillmentCenterByMemberIdAndFulfillmentCenterId

        public int checkFulfillmentCenterByMemberIdAndFulfillmentCenterId(java.lang.Long memberId,
                                                                          java.lang.Integer ffmcId,
                                                                          boolean flush)
                                                                   throws java.sql.SQLException,
                                                                          javax.naming.NamingException
        Insert the method's description here.
        Parameters:
        memberId - java.lang.Long
        ffmcId - java.lang.Integer
        Returns:
        int
        Throws:
        javax.naming.NamingException - The exception description.
        java.sql.SQLException - The exception description.
      • findCalcodeDescriptionLongDescription

        public java.lang.String findCalcodeDescriptionLongDescription(java.lang.Integer aCalcodeId,
                                                                      java.lang.Integer aLanguageId)
                                                               throws java.sql.SQLException,
                                                                      javax.naming.NamingException
        Parameters:
        aCalcodeId -
        aLanguageId -
        Returns:
        Throws:
        javax.naming.NamingException
        java.sql.SQLException
      • findCalcodeDescriptionLongDescription

        public java.lang.String findCalcodeDescriptionLongDescription(java.lang.Integer aCalcodeId,
                                                                      java.lang.Integer aLanguageId,
                                                                      boolean flush)
                                                               throws java.sql.SQLException,
                                                                      javax.naming.NamingException
        Parameters:
        aCalcodeId -
        aLanguageId -
        flush -
        Returns:
        Throws:
        javax.naming.NamingException
        java.sql.SQLException
      • findFulfillmentCenterDescriptionDescription

        public java.lang.String findFulfillmentCenterDescriptionDescription(java.lang.Integer aFulfillmentCenterId,
                                                                            java.lang.Integer aLanguageId)
                                                                     throws java.sql.SQLException,
                                                                            javax.naming.NamingException
        Parameters:
        aFulfillmentCenterId -
        aLanguageId -
        Returns:
        Throws:
        javax.naming.NamingException
        java.sql.SQLException
      • findFulfillmentCenterDescriptionDescription

        public java.lang.String findFulfillmentCenterDescriptionDescription(java.lang.Integer aFulfillmentCenterId,
                                                                            java.lang.Integer aLanguageId,
                                                                            boolean flush)
                                                                     throws java.sql.SQLException,
                                                                            javax.naming.NamingException
        Parameters:
        aFulfillmentCenterId -
        aLanguageId -
        flush -
        Returns:
        Throws:
        javax.naming.NamingException
        java.sql.SQLException
      • updateCalcodeDescriptionLongDescription

        public int updateCalcodeDescriptionLongDescription(java.lang.Integer aCalcodeId,
                                                           java.lang.Integer aLanguageId,
                                                           java.lang.String aLongDescription)
                                                    throws java.sql.SQLException,
                                                           javax.naming.NamingException
        Parameters:
        aCalcodeId -
        aLanguageId -
        aLongDescription -
        Returns:
        Throws:
        javax.naming.NamingException
        java.sql.SQLException
      • updateCalcodeDescriptionLongDescription

        public int updateCalcodeDescriptionLongDescription(java.lang.Integer aCalcodeId,
                                                           java.lang.Integer aLanguageId,
                                                           java.lang.String aLongDescription,
                                                           boolean flush)
                                                    throws java.sql.SQLException,
                                                           javax.naming.NamingException
        Parameters:
        aCalcodeId -
        aLanguageId -
        aLongDescription -
        flush -
        Returns:
        Throws:
        javax.naming.NamingException
        java.sql.SQLException
      • updateFulfillmentCenterDescriptionDescription

        public int updateFulfillmentCenterDescriptionDescription(java.lang.Integer aFulfillmentCenterId,
                                                                 java.lang.Integer aLanguageId,
                                                                 java.lang.String aDescription)
                                                          throws java.sql.SQLException,
                                                                 javax.naming.NamingException
        Parameters:
        aFulfillmentCenterId -
        aLanguageId -
        aDescription -
        Returns:
        Throws:
        javax.naming.NamingException
        java.sql.SQLException
      • updateFulfillmentCenterDescriptionDescription

        public int updateFulfillmentCenterDescriptionDescription(java.lang.Integer aFulfillmentCenterId,
                                                                 java.lang.Integer aLanguageId,
                                                                 java.lang.String aDescription,
                                                                 boolean flush)
                                                          throws java.sql.SQLException,
                                                                 javax.naming.NamingException
        Parameters:
        aFulfillmentCenterId -
        aLanguageId -
        aDescription -
        flush -
        Returns:
        Throws:
        javax.naming.NamingException
        java.sql.SQLException