Overview | Package | Class | Tree | Deprecated | Index | Help
| Copyright © 2000, 2009, Oracle and/or its affiliates. All rights reserved.
PREV CLASS NEXT CLASS | FRAMES NO FRAMES
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD

## com.beasys.commerce.ebusiness.catalog.sql
Class JdbcCatalogFactory

    java.lang.Object
      com.beasys.commerce.ebusiness.catalog.sql.JdbcCatalogFactory

Deprecated

    @Deprecated
    public class JdbcCatalogFactory

extends Object

This class provides static methods to insulate the JDBC catalog developer from the underlying database schema. It implements a number of methods to query the structure of the schema and can create Category and Product Item objects from a ResultSet.
This is an advanced (internal) class and may be subject to change.

Field Summary
`static String` | `CATALOG_ITEM_CONTRIBUTOR` Deprecated
`static String` | `CATALOG_ITEM_COVERAGE` Deprecated
`static String` | `CATALOG_ITEM_CREATION_DATE` Deprecated
`static String` | `CATALOG_ITEM_CREATOR` Deprecated
`static String` | `CATALOG_ITEM_LANGUAGE` Deprecated
`static String` | `CATALOG_ITEM_LARGE_IMAGE_ALT_TXT` Deprecated
`static String` | `CATALOG_ITEM_LARGE_IMAGE_LANGUAGE` Deprecated
`static String` | `CATALOG_ITEM_LARGE_IMAGE_NAME` Deprecated
`static String` | `CATALOG_ITEM_LARGE_IMAGE_TYPE` Deprecated
`static String` | `CATALOG_ITEM_LARGE_IMAGE_URL` Deprecated
`static String` | `CATALOG_ITEM_LONG_DESCRIPTION` Deprecated
`static String` | `CATALOG_ITEM_MODIFIED_DATE` Deprecated
`static String` | `CATALOG_ITEM_NAME` Deprecated these are the column names for attributes shared between categories and product items
`static String` | `CATALOG_ITEM_PUBLISHER` Deprecated
`static String` | `CATALOG_ITEM_RELATION` Deprecated
`static String` | `CATALOG_ITEM_RIGHTS` Deprecated
`static String` | `CATALOG_ITEM_SHORT_DESCRIPTION` Deprecated
`static String` | `CATALOG_ITEM_SMALL_IMAGE_ALT_TXT` Deprecated
`static String` | `CATALOG_ITEM_SMALL_IMAGE_LANGUAGE` Deprecated
`static String` | `CATALOG_ITEM_SMALL_IMAGE_NAME` Deprecated
`static String` | `CATALOG_ITEM_SMALL_IMAGE_TYPE` Deprecated
`static String` | `CATALOG_ITEM_SMALL_IMAGE_URL` Deprecated
`static String` | `CATALOG_ITEM_SOURCE` Deprecated
`static String` | `CATEGORY_DISPLAY_JSP_URL` Deprecated
`static String` | `CATEGORY_ID` Deprecated attributes just for category
`static String` | `CATEGORY_NAME` Deprecated
`static String` | `CATEGORY_PARENT_ID` Deprecated
`static String` | `PRODUCT_DETAIL_DISPLAY_JSP_URL` Deprecated
`static String` | `PRODUCT_ESTIMATE_SHIP_TIME` Deprecated
`static String` | `PRODUCT_FORMAT` Deprecated
`static String` | `PRODUCT_IN_STOCK` Deprecated
`static String` | `PRODUCT_KEYWORD_KEYWORD` Deprecated
`static String` | `PRODUCT_KEYWORD_SKU` Deprecated
`static String` | `PRODUCT_MSRP_AMOUNT` Deprecated
`static String` | `PRODUCT_MSRP_CURRENCY` Deprecated
`static String` | `PRODUCT_PRICE_AMOUNT` Deprecated
`static String` | `PRODUCT_PRICE_CURRENCY` Deprecated
`static String` | `PRODUCT_SHIPPING_CODE` Deprecated
`static String` | `PRODUCT_SKU` Deprecated attributes just for product items
`static String` | `PRODUCT_SPECIAL_NOTES` Deprecated
`static String` | `PRODUCT_SUMMARY_DISPLAY_JSP_URL` Deprecated
`static String` | `PRODUCT_TAX_CODE` Deprecated
`static String` | `PRODUCT_TYPE` Deprecated
`static String` | `PRODUCT_VISIBLE` Deprecated

Constructor Summary
`JdbcCatalogFactory(CatalogSchemaManager schema)` Deprecated This class is abstract and cannot be created.

Method Summary
`protected void` | `assignCatalogItemAttributes(MutableCatalogItem item, ResultSet resultSet, Map indexMap)` Deprecated Assigns the base class CatalogItem attributes from the ResultSet to a CatalogItem object.
`protected void` | `buildCatalogItemStatement(PreparedStatement preparedStatement, CatalogItem item, Map indexMap)` Deprecated Assigns the attributes for a CatalogItem into a PreparedStatement.
`void` | `buildCategoryStatement(PreparedStatement preparedStatement, CategoryKey parentKey, Category cat)` Deprecated Assigns the attributes for a Category into a PreparedStatement.
`void` | `buildProductItemStatement(PreparedStatement preparedStatement, ProductItem item)` Deprecated Assigns the attributes for a ProductItem into a PreparedStatement.
`LinkedList` | `createCategory(ResultSet resultSet)` Deprecated creates a LinkedList of Category objects from a ResultSet.
`LinkedList` | `createProductItem(ResultSet resultSet)` Deprecated creates a LinkedList of ProductItem objects from a ResultSet.
`String` | `getCategoryColumnName(String fieldName)` Deprecated
`int` | `getCategoryFieldIndex(String fieldName)` Deprecated
`String` | `getCategoryTableName()` Deprecated
`protected int` | `getMapFieldIndex(Map indexMap, String fieldName)` Deprecated
`String` | `getProductItemColumnName(String fieldName)` Deprecated
`int` | `getProductItemFieldIndex(String fieldName)` Deprecated
`String` | `getProductItemKeywordColumnName(String fieldName)` Deprecated
`String` | `getProductItemKeywordTableName()` Deprecated
`String` | `getProductItemTableName()` Deprecated
`protected String` | `getResultSetFieldAsString(ResultSet resultSet, Map indexMap, String fieldName)` Deprecated

Methods inherited from class java.lang.Object
`clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait`

Field Detail

### CATALOG_ITEM_NAME

    public static final String CATALOG_ITEM_NAME

  Deprecated
  these are the column names for attributes shared between categories and product items

  See Also
    Constants Summary

### CATALOG_ITEM_SHORT_DESCRIPTION

    public static final String CATALOG_ITEM_SHORT_DESCRIPTION

  Deprecated
  See Also
    Constants Summary

### CATALOG_ITEM_LONG_DESCRIPTION

    public static final String CATALOG_ITEM_LONG_DESCRIPTION

  Deprecated
  See Also
    Constants Summary

### CATALOG_ITEM_CREATOR

    public static final String CATALOG_ITEM_CREATOR

  Deprecated
  See Also
    Constants Summary

### CATALOG_ITEM_PUBLISHER

    public static final String CATALOG_ITEM_PUBLISHER

  Deprecated
  See Also
    Constants Summary

### CATALOG_ITEM_CONTRIBUTOR

    public static final String CATALOG_ITEM_CONTRIBUTOR

  Deprecated
  See Also
    Constants Summary

### CATALOG_ITEM_CREATION_DATE

    public static final String CATALOG_ITEM_CREATION_DATE

  Deprecated
  See Also
    Constants Summary

### CATALOG_ITEM_SOURCE

    public static final String CATALOG_ITEM_SOURCE

  Deprecated
  See Also
    Constants Summary

### CATALOG_ITEM_LANGUAGE

    public static final String CATALOG_ITEM_LANGUAGE

  Deprecated
  See Also
    Constants Summary

### CATALOG_ITEM_RELATION

    public static final String CATALOG_ITEM_RELATION

  Deprecated
  See Also
    Constants Summary

### CATALOG_ITEM_COVERAGE

    public static final String CATALOG_ITEM_COVERAGE

  Deprecated
  See Also
    Constants Summary

### CATALOG_ITEM_RIGHTS

    public static final String CATALOG_ITEM_RIGHTS

  Deprecated
  See Also
    Constants Summary

### CATALOG_ITEM_SMALL_IMAGE_NAME

    public static final String CATALOG_ITEM_SMALL_IMAGE_NAME

  Deprecated
  See Also
    Constants Summary

### CATALOG_ITEM_SMALL_IMAGE_ALT_TXT

    public static final String CATALOG_ITEM_SMALL_IMAGE_ALT_TXT

  Deprecated
  See Also
    Constants Summary

### CATALOG_ITEM_SMALL_IMAGE_URL

    public static final String CATALOG_ITEM_SMALL_IMAGE_URL

  Deprecated
  See Also
    Constants Summary

### CATALOG_ITEM_SMALL_IMAGE_LANGUAGE

    public static final String CATALOG_ITEM_SMALL_IMAGE_LANGUAGE

  Deprecated
  See Also
    Constants Summary

### CATALOG_ITEM_SMALL_IMAGE_TYPE

    public static final String CATALOG_ITEM_SMALL_IMAGE_TYPE

  Deprecated
  See Also
    Constants Summary

### CATALOG_ITEM_LARGE_IMAGE_NAME

    public static final String CATALOG_ITEM_LARGE_IMAGE_NAME

  Deprecated
  See Also
    Constants Summary

### CATALOG_ITEM_LARGE_IMAGE_ALT_TXT

    public static final String CATALOG_ITEM_LARGE_IMAGE_ALT_TXT

  Deprecated
  See Also
    Constants Summary

### CATALOG_ITEM_LARGE_IMAGE_URL

    public static final String CATALOG_ITEM_LARGE_IMAGE_URL

  Deprecated
  See Also
    Constants Summary

### CATALOG_ITEM_LARGE_IMAGE_LANGUAGE

    public static final String CATALOG_ITEM_LARGE_IMAGE_LANGUAGE

  Deprecated
  See Also
    Constants Summary

### CATALOG_ITEM_LARGE_IMAGE_TYPE

    public static final String CATALOG_ITEM_LARGE_IMAGE_TYPE

  Deprecated
  See Also
    Constants Summary

### CATALOG_ITEM_MODIFIED_DATE

    public static final String CATALOG_ITEM_MODIFIED_DATE

  Deprecated
  See Also
    Constants Summary

### PRODUCT_SKU

    public static final String PRODUCT_SKU

  Deprecated
  attributes just for product items

  See Also
    Constants Summary

### PRODUCT_FORMAT

    public static final String PRODUCT_FORMAT

  Deprecated
  See Also
    Constants Summary

### PRODUCT_TYPE

    public static final String PRODUCT_TYPE

  Deprecated
  See Also
    Constants Summary

### PRODUCT_SUMMARY_DISPLAY_JSP_URL

    public static final String PRODUCT_SUMMARY_DISPLAY_JSP_URL

  Deprecated
  See Also
    Constants Summary

### PRODUCT_DETAIL_DISPLAY_JSP_URL

    public static final String PRODUCT_DETAIL_DISPLAY_JSP_URL

  Deprecated
  See Also
    Constants Summary

### PRODUCT_MSRP_CURRENCY

    public static final String PRODUCT_MSRP_CURRENCY

  Deprecated
  See Also
    Constants Summary

### PRODUCT_MSRP_AMOUNT

    public static final String PRODUCT_MSRP_AMOUNT

  Deprecated
  See Also
    Constants Summary

### PRODUCT_PRICE_CURRENCY

    public static final String PRODUCT_PRICE_CURRENCY

  Deprecated
  See Also
    Constants Summary

### PRODUCT_PRICE_AMOUNT

    public static final String PRODUCT_PRICE_AMOUNT

  Deprecated
  See Also
    Constants Summary

### PRODUCT_IN_STOCK

    public static final String PRODUCT_IN_STOCK

  Deprecated
  See Also
    Constants Summary

### PRODUCT_ESTIMATE_SHIP_TIME

    public static final String PRODUCT_ESTIMATE_SHIP_TIME

  Deprecated
  See Also
    Constants Summary

### PRODUCT_SPECIAL_NOTES

    public static final String PRODUCT_SPECIAL_NOTES

  Deprecated
  See Also
    Constants Summary

### PRODUCT_TAX_CODE

    public static final String PRODUCT_TAX_CODE

  Deprecated
  See Also
    Constants Summary

### PRODUCT_SHIPPING_CODE

    public static final String PRODUCT_SHIPPING_CODE

  Deprecated
  See Also
    Constants Summary

### PRODUCT_VISIBLE

    public static final String PRODUCT_VISIBLE

  Deprecated
  See Also
    Constants Summary

### PRODUCT_KEYWORD_SKU

    public static final String PRODUCT_KEYWORD_SKU

  Deprecated
  See Also
    Constants Summary

### PRODUCT_KEYWORD_KEYWORD

    public static final String PRODUCT_KEYWORD_KEYWORD

  Deprecated
  See Also
    Constants Summary

### CATEGORY_ID

    public static final String CATEGORY_ID

  Deprecated
  attributes just for category

  See Also
    Constants Summary

### CATEGORY_DISPLAY_JSP_URL

    public static final String CATEGORY_DISPLAY_JSP_URL

  Deprecated
  See Also
    Constants Summary

### CATEGORY_PARENT_ID

    public static final String CATEGORY_PARENT_ID

  Deprecated
  See Also
    Constants Summary

### CATEGORY_NAME

    public static final String CATEGORY_NAME

  Deprecated
  See Also
    Constants Summary

Constructor Detail

### JdbcCatalogFactory

    public JdbcCatalogFactory(CatalogSchemaManager schema)

  Deprecated
  This class is abstract and cannot be created.

Method Detail

### getCategoryTableName

    public String getCategoryTableName()

  Deprecated
  Returns
    the name of the database table used to store categories

### getProductItemTableName

    public String getProductItemTableName()

  Deprecated
  Returns
    the name of the database table used to store product items

### getProductItemKeywordTableName

    public String getProductItemKeywordTableName()

  Deprecated
  Returns
    the name of the database table used to store product item keywords.

### getProductItemColumnName

    public String getProductItemColumnName(String fieldName)

  Deprecated
  Parameters
    `fieldName` - the name of the field. Use the constants defined in this class.
  Returns
    the name of the database column used to store a product item attribute

### getProductItemKeywordColumnName

    public String getProductItemKeywordColumnName(String fieldName)

  Deprecated
  Parameters
    `fieldName` - the name of the field (PRODUCT_KEYWORD_SKU, PRODUCT_KEYWORD_KEYWORD).
  Returns
    the name of the database column used to store a product item keyword attribute.

### getCategoryColumnName

    public String getCategoryColumnName(String fieldName)

  Deprecated
  Parameters
    `fieldName` - the name of the field. Use the constants defined in this class.
  Returns
    the name of the database column used to store a category attribute

### getCategoryFieldIndex

    public int getCategoryFieldIndex(String fieldName)

  Deprecated
  Parameters
    `fieldName` - the name of the field. Use the constants defined in this class.
  Returns
    the index of a database column used to store a category attribute

### getProductItemFieldIndex

    public int getProductItemFieldIndex(String fieldName)

  Deprecated
  Parameters
    `fieldName` - the name of the field. Use the constants defined in this class.
  Returns
    the index of a database column used to store a product item attribute

### createCategory

    public LinkedList createCategory(ResultSet resultSet)
                              throws SQLException,
                                     InvalidArgumentException

  Deprecated
  creates a LinkedList of Category objects from a ResultSet. The ResultSet must include all the columns of the category table in the correct order.

  Parameters
    `resultSet` - the SQL result set for the category table
  Returns
    a Vector of Category objects
  Throws
    `SQLException`
    `InvalidArgumentException`

### createProductItem

    public LinkedList createProductItem(ResultSet resultSet)
                                 throws SQLException,
                                        InvalidArgumentException

  Deprecated
  creates a LinkedList of ProductItem objects from a ResultSet. The ResultSet must include all the columns of the product item table in the correct order.

  Parameters
    `resultSet` - the SQL result set for the product item table
  Returns
    a Vector of ProductItem objects
  Throws
    `SQLException`
    `InvalidArgumentException`

### assignCatalogItemAttributes

    protected void assignCatalogItemAttributes(MutableCatalogItem item,
                                               ResultSet resultSet,
                                               Map indexMap)
                                        throws SQLException

  Deprecated
  Assigns the base class CatalogItem attributes from the ResultSet to a CatalogItem object.

  Parameters
    `item` - the Category or ProductItem to populate
    `resultSet` - the SQL result set for the category or product item
    `fieldName` - the name of the field. Use the constants defined in this class.
  Throws
    `SQLException`

### buildCategoryStatement

    public void buildCategoryStatement(PreparedStatement preparedStatement,
                                       CategoryKey parentKey,
                                       Category cat)
                                throws SQLException

  Deprecated
  Assigns the attributes for a Category into a PreparedStatement.

  Parameters
    `preparedStatement` - the PreparedStatement to populate
    `cat` - the Category which is the source of the values
  Throws
    `SQLException`

### buildProductItemStatement

    public void buildProductItemStatement(PreparedStatement preparedStatement,
                                          ProductItem item)
                                   throws SQLException

  Deprecated
  Assigns the attributes for a ProductItem into a PreparedStatement.

  Parameters
    `preparedStatement` - the PreparedStatement to populate
    `item` - the ProductItem which is the source of the values
  Throws
    `SQLException`

### buildCatalogItemStatement

    protected void buildCatalogItemStatement(PreparedStatement preparedStatement,
                                             CatalogItem item,
                                             Map indexMap)
                                      throws SQLException

  Deprecated
  Assigns the attributes for a CatalogItem into a PreparedStatement.

  Parameters
    `preparedStatement` - the PreparedStatement to populate
    `item` - the Category or ProductItem which is the source of the values
    `fieldName` - the name of the field. Use the constants defined in this class.
  Throws
    `SQLException`

### getResultSetFieldAsString

    protected String getResultSetFieldAsString(ResultSet resultSet,
                                               Map indexMap,
                                               String fieldName)
                                        throws SQLException

  Deprecated
  Parameters
    `indexMap` - one of the column maps for the tables we support
    `fieldName` - the name of the field. Use the constants defined in this class.
  Returns
    The value of a String attribute from one of the database tables we support (after passing through a call to `processString`).
  Throws
    `SQLException`

### getMapFieldIndex

    protected int getMapFieldIndex(Map indexMap,
                                   String fieldName)

  Deprecated
  Parameters
    `indexMap` - one of the column maps for the tables we support
    `fieldName` - the name of the field. Use the constants defined in this class.
  Returns
    the index of the column for an attribute from one of the database tables we support

Overview | Package | Class | Tree | Deprecated | Index | Help
PREV CLASS NEXT CLASS | FRAMES NO FRAMES
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD

Copyright © 2000, 2009, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.