|
© 2005 BEA Systems, Inc. | |||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectcom.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(Connection connection,
CatalogRequest request,
CategoryKey categoryKey,
ProductItemKey itemKey)
Adds an item to the specified category. |
void |
createCategory(Connection connection,
CatalogRequest request,
CategoryKey parentKey,
Category category)
Creates a sub category within the supplied parent category. |
void |
createItem(Connection connection,
CatalogRequest request,
ProductItem product)
Creates a new product item. |
Category[] |
getAncestors(Connection connection,
CatalogRequest request,
CategoryKey categoryKey)
Returns the ancestors of the specified category in ascending order. |
CatalogSchemaManager |
getCatalogSchemaManager()
|
Category[] |
getCategories(Connection connection,
CatalogRequest request,
CategoryKey[] categoryKeys)
Returns the categories with the given category keys. |
Category |
getCategory(Connection connection,
CatalogRequest request,
CategoryKey categoryKey)
Returns the category with the given category key. |
int |
getCategoryCount(Connection connection,
CatalogRequest request)
Returns the total number of categories in the product catalog. |
CategoryKey[] |
getCategoryKeys(Connection connection,
CatalogRequest request,
int beginIndex,
int endIndex)
Returns an array of all existing category keys within the specified ordered range. |
ProductItem |
getItem(Connection connection,
CatalogRequest request,
ProductItemKey productKey)
Returns the product item with the specified key. |
CategoryKey[] |
getItemCategories(Connection connection,
CatalogRequest request,
ProductItemKey productKey)
Gets all the categories that the item is a part of. |
CategoryKey[][] |
getItemCategories(Connection connection,
CatalogRequest request,
ProductItemKey[] productKeys)
Returns an array of arrays of all the categories that items are part of. |
int |
getItemCount(Connection connection,
CatalogRequest request)
Returns the number of product items in the product catalog. |
int |
getItemCount(Connection connection,
CatalogRequest request,
CategoryKey categoryKey)
Returns the number of product items associated with the specified category. |
ProductItemKey[] |
getItemKeys(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(Connection connection,
CatalogRequest request,
int beginIndex,
int endIndex)
Returns an array over all existing product item keys within the specified ordered range. |
ProductItem[] |
getItems(Connection connection,
CatalogRequest request,
ProductItemKey[] productKeys)
Returns the product items with the given product item keys. |
JdbcCatalogFactory |
getJdbcCatalogFactory()
|
String[] |
getKeywords(Connection connection,
CatalogRequest request,
ProductItemKey productKey)
Returns the keywords associated with a given product item. |
int |
getOrphanedItemCount(Connection connection,
CatalogRequest request)
Returns the number of orphaned items in the catalog. |
ProductItemKey[] |
getOrphanedItemKeys(Connection connection,
CatalogRequest request,
int beginIndex,
int endIndex)
Returns an array of all existing orphaned item keys within the specified ordered range. |
Category |
getParent(Connection connection,
CatalogRequest request,
CategoryKey categoryKey)
Returns the parent of the specified category. |
Category |
getRootCategory(Connection connection,
CatalogRequest request)
Returns the root category. |
int |
getSiblingCount(Connection connection,
CatalogRequest request,
CategoryKey categoryKey)
Returns the number of siblings associated with the specified category. |
CategoryKey[] |
getSiblingKeys(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(Connection connection,
CatalogRequest request,
CategoryKey categoryKey)
Returns the number of sub categories associated with the specified category. |
CategoryKey[] |
getSubCategoryKeys(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(String schemaName)
|
void |
moveCategory(Connection connection,
CatalogRequest request,
CategoryKey categoryKey,
CategoryKey newParentKey)
Moves the specifed category. |
void |
removeCategory(Connection connection,
CatalogRequest request,
CategoryKey categoryKey)
Removes the specifed category. |
void |
removeItem(Connection connection,
CatalogRequest request,
CategoryKey categoryKey,
ProductItemKey itemKey)
Removes an item from the specified category. |
void |
removeItem(Connection connection,
CatalogRequest request,
ProductItemKey productKey)
Removes a product item. |
void |
setKeywords(Connection connection,
CatalogRequest request,
ProductItemKey productKey,
String[] keywords)
Sets the keywords for a given product item. |
void |
updateCategory(Connection connection,
CatalogRequest request,
Category category)
Updates the specifed category. |
void |
updateItem(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 addItem(Connection connection, CatalogRequest request, CategoryKey categoryKey, ProductItemKey itemKey) throws CatalogFinderException, CatalogException, SQLException
addItem
in interface CatalogSqlManager
connection
- The database connection object.request
- The catalog request object.categoryKey
- The key of target category.itemKey
- The key of the target item.
CatalogFinderException
- if the target category or item could not be found.
CatalogException
- on general error.
SQLException
- on database access error.public void createCategory(Connection connection, CatalogRequest request, CategoryKey parentKey, Category category) throws CatalogCreateException, CatalogException, SQLException
createCategory
in interface CatalogSqlManager
connection
- The database connection object.request
- The catalog request object.parentKey
- The key of the target parent category.category
- The category to persist.
CatalogCreateException
- on category creation error.
CatalogException
- on general error.
SQLException
- on database access error.public void createItem(Connection connection, CatalogRequest request, ProductItem product) throws CatalogCreateException, CatalogException, SQLException
createItem
in interface CatalogSqlManager
connection
- The database connection object.request
- The catalog request object.product
- The product item to persist.
CatalogCreateException
- if the product item could not be created.
CatalogException
- on general error.
SQLException
- on database access error.public Category[] getAncestors(Connection connection, CatalogRequest request, CategoryKey categoryKey) throws CatalogException, SQLException
getAncestors
in interface CatalogSqlManager
connection
- The database connection object.request
- The catalog request object.categoryKey
- The key of the target category.
CatalogException
- on general error.
SQLException
- on database access error.public CatalogSchemaManager getCatalogSchemaManager()
getCatalogSchemaManager
in interface CatalogSqlManager
public Category[] getCategories(Connection connection, CatalogRequest request, CategoryKey[] categoryKeys) throws CatalogFinderException, CatalogException, SQLException
getCategories
in interface CatalogSqlManager
connection
- The database connection object.request
- The catalog request object.
CatalogFinderException
- if a category with a given key does not exist.
CatalogException
- on general error.
SQLException
- on database access error.public Category getCategory(Connection connection, CatalogRequest request, CategoryKey categoryKey) throws CatalogFinderException, CatalogException, SQLException
getCategory
in interface CatalogSqlManager
connection
- The database connection object.request
- The catalog request object.categoryKey
- The key of the target category.
CatalogFinderException
- if a category with the given key does not exist.
CatalogException
- on general error.
SQLException
- on database access error.public int getCategoryCount(Connection connection, CatalogRequest request) throws CatalogException, SQLException
getCategoryCount
in interface CatalogSqlManager
connection
- The database connection object.request
- The catalog request object.
CatalogException
- on general error.
SQLException
- on database access error.public CategoryKey[] getCategoryKeys(Connection connection, CatalogRequest request, int beginIndex, int endIndex) throws CatalogException, SQLException
getCategoryKeys
in interface CatalogSqlManager
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.
CatalogException
- on general error.
SQLException
- on database access error.public ProductItem getItem(Connection connection, CatalogRequest request, ProductItemKey productKey) throws CatalogFinderException, CatalogException, SQLException
getItem
in interface CatalogSqlManager
connection
- The database connection object.request
- The catalog request object.productKey
- The key of the target product.
CatalogFinderException
- if the product item could not be found.
CatalogException
- on general error.
SQLException
- on database access error.public CategoryKey[] getItemCategories(Connection connection, CatalogRequest request, ProductItemKey productKey) throws CatalogFinderException, CatalogException, SQLException
connection
- The database connection object.request
- The catalog request object.productKey
- ProductItemKey of the product item concerned.
CatalogFinderException
- if the product item could not be found.
CatalogException
- on general error.
SQLException
public CategoryKey[][] getItemCategories(Connection connection, CatalogRequest request, ProductItemKey[] productKeys) throws CatalogException, SQLException
request
- The catalog request object.productKeys
- Array of ProductItemKeys.
CatalogException
- on general error.
SQLException
public int getItemCount(Connection connection, CatalogRequest request) throws CatalogException, SQLException
getItemCount
in interface CatalogSqlManager
connection
- The database connection object.request
- The catalog request object.
CatalogException
- on general error.
SQLException
- on database access error.public int getItemCount(Connection connection, CatalogRequest request, CategoryKey categoryKey) throws CatalogFinderException, CatalogException, SQLException
getItemCount
in interface CatalogSqlManager
connection
- The database connection object.request
- The catalog request object.categoryKey
- The key of the target category.
CatalogFinderException
- if the specified category could not be found.
CatalogException
- on general error.
SQLException
- on database access error.public ProductItemKey[] getItemKeys(Connection connection, CatalogRequest request, CategoryKey categoryKey, int beginIndex, int endIndex) throws CatalogException, SQLException
getItemKeys
in interface CatalogSqlManager
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.
CatalogException
- on general error.
SQLException
- on database access error.public ProductItemKey[] getItemKeys(Connection connection, CatalogRequest request, int beginIndex, int endIndex) throws CatalogException, SQLException
getItemKeys
in interface CatalogSqlManager
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.
CatalogException
- on general error.
SQLException
- on database access error.public ProductItem[] getItems(Connection connection, CatalogRequest request, ProductItemKey[] productKeys) throws CatalogFinderException, CatalogException, SQLException
getItems
in interface CatalogSqlManager
connection
- The database connection object.request
- The catalog request object.
CatalogFinderException
- if a product item with a given key does not exist.
CatalogException
- on general error.
SQLException
- on database access error.public JdbcCatalogFactory getJdbcCatalogFactory()
getJdbcCatalogFactory
in interface CatalogSqlManager
public String[] getKeywords(Connection connection, CatalogRequest request, ProductItemKey productKey) throws CatalogFinderException, CatalogException, SQLException
getKeywords
in interface CatalogSqlManager
connection
- The database connection object.request
- The catalog request object.productKey
- The key of the target product.
CatalogFinderException
- if the product item could not be found.
CatalogException
- on general error.
SQLException
- on database access error.public int getOrphanedItemCount(Connection connection, CatalogRequest request) throws CatalogException, SQLException
getOrphanedItemCount
in interface CatalogSqlManager
connection
- The database connection object.request
- The catalog request object.
CatalogException
- on general error.
SQLException
- on database access error.public ProductItemKey[] getOrphanedItemKeys(Connection connection, CatalogRequest request, int beginIndex, int endIndex) throws CatalogException, SQLException
getOrphanedItemKeys
in interface CatalogSqlManager
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.
CatalogException
- on general error.
SQLException
- on database access error.public Category getParent(Connection connection, CatalogRequest request, CategoryKey categoryKey) throws CatalogFinderException, CatalogException, SQLException
getParent
in interface CatalogSqlManager
connection
- The database connection object.request
- The catalog request object.categoryKey
- The key of the target category.
CatalogFinderException
- if the parent could not be found. This could happen if the specified category does not exist or is the root category.
CatalogException
- on general error.
SQLException
- on database access error.public Category getRootCategory(Connection connection, CatalogRequest request) throws CatalogException, SQLException
getRootCategory
in interface CatalogSqlManager
connection
- The database connection object.request
- The catalog request object.
CatalogCreateException
- if the root category could not be created.
CatalogException
- on general error.
SQLException
- on database access error.public int getSiblingCount(Connection connection, CatalogRequest request, CategoryKey categoryKey) throws CatalogFinderException, CatalogException, SQLException
getSiblingCount
in interface CatalogSqlManager
connection
- The database connection object.request
- The catalog request object.categoryKey
- The key of the target category.
CatalogFinderException
- if the specified category could not be found.
CatalogException
- on general error.
SQLException
- on database access error.public CategoryKey[] getSiblingKeys(Connection connection, CatalogRequest request, CategoryKey categoryKey, int beginIndex, int endIndex) throws CatalogException, SQLException
getSiblingKeys
in interface CatalogSqlManager
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.
CatalogException
- on general error.
SQLException
- on database access error.public int getSubCategoryCount(Connection connection, CatalogRequest request, CategoryKey categoryKey) throws CatalogFinderException, CatalogException, SQLException
getSubCategoryCount
in interface CatalogSqlManager
connection
- The database connection object.request
- The catalog request object.categoryKey
- The key of the target category.
CatalogFinderException
- if the specified category could not be found.
CatalogException
- on general error.
SQLException
- on database access error.public CategoryKey[] getSubCategoryKeys(Connection connection, CatalogRequest request, CategoryKey categoryKey, int beginIndex, int endIndex) throws CatalogException, SQLException
getSubCategoryKeys
in interface CatalogSqlManager
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.
CatalogException
- on general error.
SQLException
- on database access error.public void initialize(String schemaName)
initialize
in interface CatalogSqlManager
public void moveCategory(Connection connection, CatalogRequest request, CategoryKey categoryKey, CategoryKey newParentKey) throws CatalogFinderException, CatalogException, SQLException
moveCategory
in interface CatalogSqlManager
connection
- The database connection object.request
- The catalog request object.categoryKey
- The key of the target category.
CatalogFinderException
- if the specified target or parent category could not be found.
CatalogException
- on general error.
SQLException
- on database access error.public void removeCategory(Connection connection, CatalogRequest request, CategoryKey categoryKey) throws CatalogRemoveException, CatalogException, SQLException
removeCategory
in interface CatalogSqlManager
connection
- The database connection object.request
- The catalog request object.categoryKey
- The key of the target category.
CatalogRemoveException
- if the specified category could not be removed.
CatalogException
- on general error.
SQLException
- on database access error.public void removeItem(Connection connection, CatalogRequest request, CategoryKey categoryKey, ProductItemKey itemKey) throws CatalogFinderException, CatalogException, SQLException
removeItem
in interface CatalogSqlManager
connection
- The database connection object.request
- The catalog request object.categoryKey
- The key of target category.itemKey
- The key of the target item.
CatalogFinderException
- if the target category could not be found.
CatalogException
- on general error.
SQLException
- on database access error.public void removeItem(Connection connection, CatalogRequest request, ProductItemKey productKey) throws CatalogRemoveException, CatalogFinderException, CatalogException, SQLException
removeItem
in interface CatalogSqlManager
connection
- The database connection object.request
- The catalog request object.
CatalogRemoveException
- if the product item could not be removed.
CatalogFinderException
- if the product item could not be found.
CatalogException
- on general error.
SQLException
- on database access error.public void setKeywords(Connection connection, CatalogRequest request, ProductItemKey productKey, String[] keywords) throws CatalogFinderException, CatalogException, SQLException
setKeywords
in interface CatalogSqlManager
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.
CatalogFinderException
- if the product item could not be found.
CatalogException
- on general error.
SQLException
- on database access error.public void updateCategory(Connection connection, CatalogRequest request, Category category) throws CatalogFinderException, CatalogException, SQLException
updateCategory
in interface CatalogSqlManager
connection
- The database connection object.request
- The catalog request object.category
- The category to update.
CatalogFinderException
- if the specified category could not be found.
CatalogException
- on general error.
SQLException
- on database access error.public void updateItem(Connection connection, CatalogRequest request, ProductItem product) throws CatalogFinderException, CatalogException, SQLException
updateItem
in interface CatalogSqlManager
connection
- The database connection object.request
- The catalog request object.product
- The product item to update.
CatalogFinderException
- if the product item could not be found.
CatalogException
- on general error.
SQLException
- on database access error.
|
© 2005 BEA Systems, Inc. | |||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |