|
© 2002 BEA Systems, Inc. | ||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object | +--com.beasys.commerce.ebusiness.catalog.sql.JdbcCatalogFactory
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 java.lang.String |
CATALOG_ITEM_CONTRIBUTOR
|
static java.lang.String |
CATALOG_ITEM_COVERAGE
|
static java.lang.String |
CATALOG_ITEM_CREATION_DATE
|
static java.lang.String |
CATALOG_ITEM_CREATOR
|
static java.lang.String |
CATALOG_ITEM_LANGUAGE
|
static java.lang.String |
CATALOG_ITEM_LARGE_IMAGE_ALT_TXT
|
static java.lang.String |
CATALOG_ITEM_LARGE_IMAGE_LANGUAGE
|
static java.lang.String |
CATALOG_ITEM_LARGE_IMAGE_NAME
|
static java.lang.String |
CATALOG_ITEM_LARGE_IMAGE_TYPE
|
static java.lang.String |
CATALOG_ITEM_LARGE_IMAGE_URL
|
static java.lang.String |
CATALOG_ITEM_LONG_DESCRIPTION
|
static java.lang.String |
CATALOG_ITEM_MODIFIED_DATE
|
static java.lang.String |
CATALOG_ITEM_NAME
these are the column names for attributes shared between categories and product items |
static java.lang.String |
CATALOG_ITEM_PUBLISHER
|
static java.lang.String |
CATALOG_ITEM_RELATION
|
static java.lang.String |
CATALOG_ITEM_RIGHTS
|
static java.lang.String |
CATALOG_ITEM_SHORT_DESCRIPTION
|
static java.lang.String |
CATALOG_ITEM_SMALL_IMAGE_ALT_TXT
|
static java.lang.String |
CATALOG_ITEM_SMALL_IMAGE_LANGUAGE
|
static java.lang.String |
CATALOG_ITEM_SMALL_IMAGE_NAME
|
static java.lang.String |
CATALOG_ITEM_SMALL_IMAGE_TYPE
|
static java.lang.String |
CATALOG_ITEM_SMALL_IMAGE_URL
|
static java.lang.String |
CATALOG_ITEM_SOURCE
|
static java.lang.String |
CATEGORY_DISPLAY_JSP_URL
|
static java.lang.String |
CATEGORY_ID
attributes just for category |
static java.lang.String |
CATEGORY_NAME
|
static java.lang.String |
CATEGORY_PARENT_ID
|
static java.lang.String |
PRODUCT_DETAIL_DISPLAY_JSP_URL
|
static java.lang.String |
PRODUCT_ESTIMATE_SHIP_TIME
|
static java.lang.String |
PRODUCT_FORMAT
|
static java.lang.String |
PRODUCT_IN_STOCK
|
static java.lang.String |
PRODUCT_KEYWORD_KEYWORD
|
static java.lang.String |
PRODUCT_KEYWORD_SKU
|
static java.lang.String |
PRODUCT_MSRP_AMOUNT
|
static java.lang.String |
PRODUCT_MSRP_CURRENCY
|
static java.lang.String |
PRODUCT_PRICE_AMOUNT
|
static java.lang.String |
PRODUCT_PRICE_CURRENCY
|
static java.lang.String |
PRODUCT_SHIPPING_CODE
|
static java.lang.String |
PRODUCT_SKU
attributes just for product items |
static java.lang.String |
PRODUCT_SPECIAL_NOTES
|
static java.lang.String |
PRODUCT_SUMMARY_DISPLAY_JSP_URL
|
static java.lang.String |
PRODUCT_TAX_CODE
|
static java.lang.String |
PRODUCT_TYPE
|
static java.lang.String |
PRODUCT_VISIBLE
|
Constructor Summary | |
JdbcCatalogFactory(CatalogSchemaManager schema)
This class is abstract and cannot be created. |
Method Summary | |
protected void |
assignCatalogItemAttributes(MutableCatalogItem item,
java.sql.ResultSet resultSet,
java.util.Map indexMap)
Assigns the base class CatalogItem attributes from the ResultSet to a CatalogItem object. |
protected void |
buildCatalogItemStatement(java.sql.PreparedStatement preparedStatement,
CatalogItem item,
java.util.Map indexMap)
Assigns the attributes for a CatalogItem into a PreparedStatement. |
void |
buildCategoryStatement(java.sql.PreparedStatement preparedStatement,
CategoryKey parentKey,
Category cat)
Assigns the attributes for a Category into a PreparedStatement. |
void |
buildProductItemStatement(java.sql.PreparedStatement preparedStatement,
ProductItem item)
Assigns the attributes for a ProductItem into a PreparedStatement. |
java.util.LinkedList |
createCategory(java.sql.ResultSet resultSet)
creates a LinkedList of Category objects from a ResultSet. |
java.util.LinkedList |
createProductItem(java.sql.ResultSet resultSet)
creates a LinkedList of ProductItem objects from a ResultSet. |
java.lang.String |
getCategoryColumnName(java.lang.String fieldName)
|
int |
getCategoryFieldIndex(java.lang.String fieldName)
|
java.lang.String |
getCategoryTableName()
|
protected int |
getMapFieldIndex(java.util.Map indexMap,
java.lang.String fieldName)
|
java.lang.String |
getProductItemColumnName(java.lang.String fieldName)
|
int |
getProductItemFieldIndex(java.lang.String fieldName)
|
java.lang.String |
getProductItemKeywordColumnName(java.lang.String fieldName)
|
java.lang.String |
getProductItemKeywordTableName()
|
java.lang.String |
getProductItemTableName()
|
protected java.lang.String |
getResultSetFieldAsString(java.sql.ResultSet resultSet,
java.util.Map indexMap,
java.lang.String fieldName)
|
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 CATALOG_ITEM_NAME
public static final java.lang.String CATALOG_ITEM_SHORT_DESCRIPTION
public static final java.lang.String CATALOG_ITEM_LONG_DESCRIPTION
public static final java.lang.String CATALOG_ITEM_CREATOR
public static final java.lang.String CATALOG_ITEM_PUBLISHER
public static final java.lang.String CATALOG_ITEM_CONTRIBUTOR
public static final java.lang.String CATALOG_ITEM_CREATION_DATE
public static final java.lang.String CATALOG_ITEM_SOURCE
public static final java.lang.String CATALOG_ITEM_LANGUAGE
public static final java.lang.String CATALOG_ITEM_RELATION
public static final java.lang.String CATALOG_ITEM_COVERAGE
public static final java.lang.String CATALOG_ITEM_RIGHTS
public static final java.lang.String CATALOG_ITEM_SMALL_IMAGE_NAME
public static final java.lang.String CATALOG_ITEM_SMALL_IMAGE_ALT_TXT
public static final java.lang.String CATALOG_ITEM_SMALL_IMAGE_URL
public static final java.lang.String CATALOG_ITEM_SMALL_IMAGE_LANGUAGE
public static final java.lang.String CATALOG_ITEM_SMALL_IMAGE_TYPE
public static final java.lang.String CATALOG_ITEM_LARGE_IMAGE_NAME
public static final java.lang.String CATALOG_ITEM_LARGE_IMAGE_ALT_TXT
public static final java.lang.String CATALOG_ITEM_LARGE_IMAGE_URL
public static final java.lang.String CATALOG_ITEM_LARGE_IMAGE_LANGUAGE
public static final java.lang.String CATALOG_ITEM_LARGE_IMAGE_TYPE
public static final java.lang.String CATALOG_ITEM_MODIFIED_DATE
public static final java.lang.String PRODUCT_SKU
public static final java.lang.String PRODUCT_FORMAT
public static final java.lang.String PRODUCT_TYPE
public static final java.lang.String PRODUCT_SUMMARY_DISPLAY_JSP_URL
public static final java.lang.String PRODUCT_DETAIL_DISPLAY_JSP_URL
public static final java.lang.String PRODUCT_MSRP_CURRENCY
public static final java.lang.String PRODUCT_MSRP_AMOUNT
public static final java.lang.String PRODUCT_PRICE_CURRENCY
public static final java.lang.String PRODUCT_PRICE_AMOUNT
public static final java.lang.String PRODUCT_IN_STOCK
public static final java.lang.String PRODUCT_ESTIMATE_SHIP_TIME
public static final java.lang.String PRODUCT_SPECIAL_NOTES
public static final java.lang.String PRODUCT_TAX_CODE
public static final java.lang.String PRODUCT_SHIPPING_CODE
public static final java.lang.String PRODUCT_VISIBLE
public static final java.lang.String PRODUCT_KEYWORD_SKU
public static final java.lang.String PRODUCT_KEYWORD_KEYWORD
public static final java.lang.String CATEGORY_ID
public static final java.lang.String CATEGORY_DISPLAY_JSP_URL
public static final java.lang.String CATEGORY_PARENT_ID
public static final java.lang.String CATEGORY_NAME
Constructor Detail |
public JdbcCatalogFactory(CatalogSchemaManager schema)
Method Detail |
public java.lang.String getCategoryTableName()
public java.lang.String getProductItemTableName()
public java.lang.String getProductItemKeywordTableName()
public java.lang.String getProductItemColumnName(java.lang.String fieldName)
fieldName
- the name of the field. Use the constants defined in this class.public java.lang.String getProductItemKeywordColumnName(java.lang.String fieldName)
fieldName
- the name of the field (PRODUCT_KEYWORD_SKU,
PRODUCT_KEYWORD_KEYWORD).public java.lang.String getCategoryColumnName(java.lang.String fieldName)
fieldName
- the name of the field. Use the constants defined in this class.public int getCategoryFieldIndex(java.lang.String fieldName)
fieldName
- the name of the field. Use the constants defined in this class.public int getProductItemFieldIndex(java.lang.String fieldName)
fieldName
- the name of the field. Use the constants defined in this class.public java.util.LinkedList createCategory(java.sql.ResultSet resultSet) throws java.sql.SQLException, InvalidArgumentException
resultSet
- the SQL result set for the category tablepublic java.util.LinkedList createProductItem(java.sql.ResultSet resultSet) throws java.sql.SQLException, InvalidArgumentException
resultSet
- the SQL result set for the product item tableprotected void assignCatalogItemAttributes(MutableCatalogItem item, java.sql.ResultSet resultSet, java.util.Map indexMap) throws java.sql.SQLException
item
- the Category or ProductItem to populateresultSet
- the SQL result set for the category or product itemfieldName
- the name of the field. Use the constants defined in this class.public void buildCategoryStatement(java.sql.PreparedStatement preparedStatement, CategoryKey parentKey, Category cat) throws java.sql.SQLException
preparedStatement
- the PreparedStatement to populatecat
- the Category which is the source of the valuespublic void buildProductItemStatement(java.sql.PreparedStatement preparedStatement, ProductItem item) throws java.sql.SQLException
preparedStatement
- the PreparedStatement to populateitem
- the ProductItem which is the source of the valuesprotected void buildCatalogItemStatement(java.sql.PreparedStatement preparedStatement, CatalogItem item, java.util.Map indexMap) throws java.sql.SQLException
preparedStatement
- the PreparedStatement to populateitem
- the Category or ProductItem which is the source of the valuesfieldName
- the name of the field. Use the constants defined in this class.protected java.lang.String getResultSetFieldAsString(java.sql.ResultSet resultSet, java.util.Map indexMap, java.lang.String fieldName) throws java.sql.SQLException
indexMap
- one of the column maps for the tables we supportfieldName
- the name of the field. Use the constants defined in this class.processString
).protected int getMapFieldIndex(java.util.Map indexMap, java.lang.String fieldName)
indexMap
- one of the column maps for the tables we supportfieldName
- the name of the field. Use the constants defined in this class.
|
© 2002 BEA Systems, Inc. | ||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |