|
© 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.JdbcSqlManager
The JdbcSqlManager
class implements the CatalogSqlManager
interface
using JDBC compliant SQL.
This is an advanced (internal) class and may be subject to change.
Constructor Summary | |
JdbcSqlManager()
|
Method Summary | |
void |
addItem(java.sql.Connection connection,
CatalogRequest request,
CategoryKey categoryKey,
ProductItemKey itemKey)
Adds an item to the specified category. |
void |
createCategory(java.sql.Connection connection,
CatalogRequest request,
CategoryKey parentKey,
Category category)
Creates a sub category within the supplied parent category. |
void |
createItem(java.sql.Connection connection,
CatalogRequest request,
ProductItem product)
Creates a new product item. |
Category[] |
getAncestors(java.sql.Connection connection,
CatalogRequest request,
CategoryKey categoryKey)
Returns the ancestors of the specified category in ascending order. |
CatalogSchemaManager |
getCatalogSchemaManager()
|
Category[] |
getCategories(java.sql.Connection connection,
CatalogRequest request,
CategoryKey[] categoryKeys)
Returns the categories with the given category keys. |
Category |
getCategory(java.sql.Connection connection,
CatalogRequest request,
CategoryKey categoryKey)
Returns the category with the given category key. |
int |
getCategoryCount(java.sql.Connection connection,
CatalogRequest request)
Returns the total number of categories in the product catalog. |
CategoryKey[] |
getCategoryKeys(java.sql.Connection connection,
CatalogRequest request,
int beginIndex,
int endIndex)
Returns an array of all existing category keys within the specified ordered range. |
ProductItem |
getItem(java.sql.Connection connection,
CatalogRequest request,
ProductItemKey productKey)
Returns the product item with the specified key. |
CategoryKey[] |
getItemCategories(java.sql.Connection connection,
CatalogRequest request,
ProductItemKey productKey)
Gets all the categories that the item is a part of. |
CategoryKey[][] |
getItemCategories(java.sql.Connection connection,
CatalogRequest request,
ProductItemKey[] productKeys)
Returns an array of arrays of all the categories that items are part of. |
int |
getItemCount(java.sql.Connection connection,
CatalogRequest request)
Returns the number of product items in the product catalog. |
int |
getItemCount(java.sql.Connection connection,
CatalogRequest request,
CategoryKey categoryKey)
Returns the number of product items associated with the specified category. |
ProductItemKey[] |
getItemKeys(java.sql.Connection connection,
CatalogRequest request,
CategoryKey categoryKey,
int beginIndex,
int endIndex)
Returns an array of all product item keys of the specified category within the specified ordered range. |
ProductItemKey[] |
getItemKeys(java.sql.Connection connection,
CatalogRequest request,
int beginIndex,
int endIndex)
Returns an array over all existing product item keys within the specified ordered range. |
ProductItem[] |
getItems(java.sql.Connection connection,
CatalogRequest request,
ProductItemKey[] productKeys)
Returns the product items with the given product item keys. |
JdbcCatalogFactory |
getJdbcCatalogFactory()
|
java.lang.String[] |
getKeywords(java.sql.Connection connection,
CatalogRequest request,
ProductItemKey productKey)
Returns the keywords associated with a given product item. |
int |
getOrphanedItemCount(java.sql.Connection connection,
CatalogRequest request)
Returns the number of orphaned items in the catalog. |
ProductItemKey[] |
getOrphanedItemKeys(java.sql.Connection connection,
CatalogRequest request,
int beginIndex,
int endIndex)
Returns an array of all existing orphaned item keys within the specified ordered range. |
Category |
getParent(java.sql.Connection connection,
CatalogRequest request,
CategoryKey categoryKey)
Returns the parent of the specified category. |
Category |
getRootCategory(java.sql.Connection connection,
CatalogRequest request)
Returns the root category. |
int |
getSiblingCount(java.sql.Connection connection,
CatalogRequest request,
CategoryKey categoryKey)
Returns the number of siblings associated with the specified category. |
CategoryKey[] |
getSiblingKeys(java.sql.Connection connection,
CatalogRequest request,
CategoryKey categoryKey,
int beginIndex,
int endIndex)
Returns an array of all exististing sibling keys of the specified category within the specified ordered range. |
int |
getSubCategoryCount(java.sql.Connection connection,
CatalogRequest request,
CategoryKey categoryKey)
Returns the number of sub categories associated with the specified category. |
CategoryKey[] |
getSubCategoryKeys(java.sql.Connection connection,
CatalogRequest request,
CategoryKey categoryKey,
int beginIndex,
int endIndex)
Returns an array of all sub category keys of the specified category within the specified ordered range. |
void |
initialize(java.lang.String schemaName)
|
void |
moveCategory(java.sql.Connection connection,
CatalogRequest request,
CategoryKey categoryKey,
CategoryKey newParentKey)
Moves the specifed category. |
void |
removeCategory(java.sql.Connection connection,
CatalogRequest request,
CategoryKey categoryKey)
Removes the specifed category. |
void |
removeItem(java.sql.Connection connection,
CatalogRequest request,
CategoryKey categoryKey,
ProductItemKey itemKey)
Removes an item from the specified category. |
void |
removeItem(java.sql.Connection connection,
CatalogRequest request,
ProductItemKey productKey)
Removes a product item. |
void |
setKeywords(java.sql.Connection connection,
CatalogRequest request,
ProductItemKey productKey,
java.lang.String[] keywords)
Sets the keywords for a given product item. |
void |
updateCategory(java.sql.Connection connection,
CatalogRequest request,
Category category)
Updates the specifed category. |
void |
updateItem(java.sql.Connection connection,
CatalogRequest request,
ProductItem product)
Updates a product item. |
Methods inherited from class java.lang.Object |
clone,
equals,
finalize,
getClass,
hashCode,
notify,
notifyAll,
toString,
wait,
wait,
wait |
Constructor Detail |
public JdbcSqlManager()
Method Detail |
public void initialize(java.lang.String schemaName)
public CatalogSchemaManager getCatalogSchemaManager()
public JdbcCatalogFactory getJdbcCatalogFactory()
public int getItemCount(java.sql.Connection connection, CatalogRequest request) throws CatalogException, java.sql.SQLException
connection
- The database connection object.request
- The catalog request object.public ProductItem getItem(java.sql.Connection connection, CatalogRequest request, ProductItemKey productKey) throws CatalogFinderException, CatalogException, java.sql.SQLException
connection
- The database connection object.request
- The catalog request object.productKey
- The key of the target product.public ProductItem[] getItems(java.sql.Connection connection, CatalogRequest request, ProductItemKey[] productKeys) throws CatalogFinderException, CatalogException, java.sql.SQLException
connection
- The database connection object.request
- The catalog request object.keys
- The keys of the target product items.public ProductItemKey[] getItemKeys(java.sql.Connection connection, CatalogRequest request, int beginIndex, int endIndex) throws CatalogException, java.sql.SQLException
connection
- The database connection object.request
- The catalog request object.beginIndex
- The lower bound index for returned product item keys.endIndex
- The upper bound index for returned product item keys.public java.lang.String[] getKeywords(java.sql.Connection connection, CatalogRequest request, ProductItemKey productKey) throws CatalogFinderException, CatalogException, java.sql.SQLException
connection
- The database connection object.request
- The catalog request object.productKey
- The key of the target product.public void setKeywords(java.sql.Connection connection, CatalogRequest request, ProductItemKey productKey, java.lang.String[] keywords) throws CatalogFinderException, CatalogException, java.sql.SQLException
connection
- The database connection object.request
- The catalog request object.productKey
- The key of the target product.keywords
- The keywords to associate with the given product item.public void createItem(java.sql.Connection connection, CatalogRequest request, ProductItem product) throws CatalogCreateException, CatalogException, java.sql.SQLException
connection
- The database connection object.request
- The catalog request object.product
- The product item to persist.public void updateItem(java.sql.Connection connection, CatalogRequest request, ProductItem product) throws CatalogFinderException, CatalogException, java.sql.SQLException
connection
- The database connection object.request
- The catalog request object.product
- The product item to update.public void removeItem(java.sql.Connection connection, CatalogRequest request, ProductItemKey productKey) throws CatalogRemoveException, CatalogFinderException, CatalogException, java.sql.SQLException
connection
- The database connection object.request
- The catalog request object.product
- The product item to remove.public CategoryKey[] getItemCategories(java.sql.Connection connection, CatalogRequest request, ProductItemKey productKey) throws CatalogFinderException, CatalogException, java.sql.SQLException
connection
- The database connection object.request
- The catalog request object.productKey
- ProductItemKey of the product item concerned.public CategoryKey[][] getItemCategories(java.sql.Connection connection, CatalogRequest request, ProductItemKey[] productKeys) throws CatalogException, java.sql.SQLException
request
- The catalog request object.productKeys
- Array of ProductItemKeys.public Category getRootCategory(java.sql.Connection connection, CatalogRequest request) throws CatalogException, java.sql.SQLException
connection
- The database connection object.request
- The catalog request object.public int getCategoryCount(java.sql.Connection connection, CatalogRequest request) throws CatalogException, java.sql.SQLException
connection
- The database connection object.request
- The catalog request object.public int getItemCount(java.sql.Connection connection, CatalogRequest request, CategoryKey categoryKey) throws CatalogFinderException, CatalogException, java.sql.SQLException
connection
- The database connection object.request
- The catalog request object.categoryKey
- The key of the target category.public int getSubCategoryCount(java.sql.Connection connection, CatalogRequest request, CategoryKey categoryKey) throws CatalogFinderException, CatalogException, java.sql.SQLException
connection
- The database connection object.request
- The catalog request object.categoryKey
- The key of the target category.public int getSiblingCount(java.sql.Connection connection, CatalogRequest request, CategoryKey categoryKey) throws CatalogFinderException, CatalogException, java.sql.SQLException
connection
- The database connection object.request
- The catalog request object.categoryKey
- The key of the target category.public int getOrphanedItemCount(java.sql.Connection connection, CatalogRequest request) throws CatalogException, java.sql.SQLException
connection
- The database connection object.request
- The catalog request object.public Category getCategory(java.sql.Connection connection, CatalogRequest request, CategoryKey categoryKey) throws CatalogFinderException, CatalogException, java.sql.SQLException
connection
- The database connection object.request
- The catalog request object.categoryKey
- The key of the target category.public Category[] getCategories(java.sql.Connection connection, CatalogRequest request, CategoryKey[] categoryKeys) throws CatalogFinderException, CatalogException, java.sql.SQLException
connection
- The database connection object.request
- The catalog request object.keys
- The keys of the target categories.public CategoryKey[] getCategoryKeys(java.sql.Connection connection, CatalogRequest request, int beginIndex, int endIndex) throws CatalogException, java.sql.SQLException
connection
- The database connection object.request
- The catalog request object.beginIndex
- The lower bound index for returned category keys.endIndex
- The upper bound index for returned category keys.public CategoryKey[] getSiblingKeys(java.sql.Connection connection, CatalogRequest request, CategoryKey categoryKey, int beginIndex, int endIndex) throws CatalogException, java.sql.SQLException
connection
- The database connection object.request
- The catalog request object.categoryKey
- The key of the target category.beginIndex
- The lower bound index for returned sibling keys.endIndex
- The upper bound index for returned sibling keys.public CategoryKey[] getSubCategoryKeys(java.sql.Connection connection, CatalogRequest request, CategoryKey categoryKey, int beginIndex, int endIndex) throws CatalogException, java.sql.SQLException
connection
- The database connection object.request
- The catalog request object.categoryKey
- The key of the target category.beginIndex
- The lower bound index for returned sub category keys.endIndex
- The upper bound index for returned sub category keys.public Category[] getAncestors(java.sql.Connection connection, CatalogRequest request, CategoryKey categoryKey) throws CatalogException, java.sql.SQLException
connection
- The database connection object.request
- The catalog request object.categoryKey
- The key of the target category.public Category getParent(java.sql.Connection connection, CatalogRequest request, CategoryKey categoryKey) throws CatalogFinderException, CatalogException, java.sql.SQLException
connection
- The database connection object.request
- The catalog request object.categoryKey
- The key of the target category.public ProductItemKey[] getItemKeys(java.sql.Connection connection, CatalogRequest request, CategoryKey categoryKey, int beginIndex, int endIndex) throws CatalogException, java.sql.SQLException
connection
- The database connection object.request
- The catalog request object.categoryKey
- The key of the target category.beginIndex
- The lower bound index for returned product item keys.endIndex
- The upper bound index for returned product item keys.public ProductItemKey[] getOrphanedItemKeys(java.sql.Connection connection, CatalogRequest request, int beginIndex, int endIndex) throws CatalogException, java.sql.SQLException
connection
- The database connection object.request
- The catalog request object.beginIndex
- The lower bound index for returned category keys.endIndex
- The upper bound index for returned category keys.public void createCategory(java.sql.Connection connection, CatalogRequest request, CategoryKey parentKey, Category category) throws CatalogCreateException, CatalogException, java.sql.SQLException
connection
- The database connection object.request
- The catalog request object.parentKey
- The key of the target parent category.category
- The category to persist.public void removeCategory(java.sql.Connection connection, CatalogRequest request, CategoryKey categoryKey) throws CatalogRemoveException, CatalogException, java.sql.SQLException
connection
- The database connection object.request
- The catalog request object.categoryKey
- The key of the target category.public void updateCategory(java.sql.Connection connection, CatalogRequest request, Category category) throws CatalogFinderException, CatalogException, java.sql.SQLException
connection
- The database connection object.request
- The catalog request object.category
- The category to update.public void moveCategory(java.sql.Connection connection, CatalogRequest request, CategoryKey categoryKey, CategoryKey newParentKey) throws CatalogFinderException, CatalogException, java.sql.SQLException
connection
- The database connection object.request
- The catalog request object.categoryKey
- The key of the target category.parentKey
- The key of the new parent category.public void addItem(java.sql.Connection connection, CatalogRequest request, CategoryKey categoryKey, ProductItemKey itemKey) throws CatalogFinderException, CatalogException, java.sql.SQLException
connection
- The database connection object.request
- The catalog request object.categoryKey
- The key of target category.itemKey
- The key of the target item.public void removeItem(java.sql.Connection connection, CatalogRequest request, CategoryKey categoryKey, ProductItemKey itemKey) throws CatalogFinderException, CatalogException, java.sql.SQLException
connection
- The database connection object.request
- The catalog request object.categoryKey
- The key of target category.itemKey
- The key of the target item.
|
© 2002 BEA Systems, Inc. | ||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |