|
Copyright © 2000, 2008, Oracle and/or its affiliates. All rights reserved. | ||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object com.beasys.commerce.ebusiness.catalog.sql.JdbcSqlManager
@Deprecated public class 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()
Deprecated |
Method Summary | |
---|---|
void |
addItem(Connection connection,
CatalogRequest request,
CategoryKey categoryKey,
ProductItemKey itemKey)
Deprecated Adds an item to the specified category. |
void |
createCategory(Connection connection,
CatalogRequest request,
CategoryKey parentKey,
Category category)
Deprecated Creates a sub category within the supplied parent category. |
void |
createItem(Connection connection,
CatalogRequest request,
ProductItem product)
Deprecated Creates a new product item. |
Category[] |
getAncestors(Connection connection,
CatalogRequest request,
CategoryKey categoryKey)
Deprecated Returns the ancestors of the specified category in ascending order. |
CatalogSchemaManager |
getCatalogSchemaManager()
Deprecated |
Category[] |
getCategories(Connection connection,
CatalogRequest request,
CategoryKey[] categoryKeys)
Deprecated Returns the categories with the given category keys. |
Category |
getCategory(Connection connection,
CatalogRequest request,
CategoryKey categoryKey)
Deprecated Returns the category with the given category key. |
int |
getCategoryCount(Connection connection,
CatalogRequest request)
Deprecated Returns the total number of categories in the product catalog. |
CategoryKey[] |
getCategoryKeys(Connection connection,
CatalogRequest request,
int beginIndex,
int endIndex)
Deprecated Returns an array of all existing category keys within the specified ordered range. |
ProductItem |
getItem(Connection connection,
CatalogRequest request,
ProductItemKey productKey)
Deprecated Returns the product item with the specified key. |
CategoryKey[] |
getItemCategories(Connection connection,
CatalogRequest request,
ProductItemKey productKey)
Deprecated Gets all the categories that the item is a part of. |
CategoryKey[][] |
getItemCategories(Connection connection,
CatalogRequest request,
ProductItemKey[] productKeys)
Deprecated Returns an array of arrays of all the categories that items are part of. |
int |
getItemCount(Connection connection,
CatalogRequest request)
Deprecated Returns the number of product items in the product catalog. |
int |
getItemCount(Connection connection,
CatalogRequest request,
CategoryKey categoryKey)
Deprecated Returns the number of product items associated with the specified category. |
ProductItemKey[] |
getItemKeys(Connection connection,
CatalogRequest request,
CategoryKey categoryKey,
int beginIndex,
int endIndex)
Deprecated 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)
Deprecated Returns an array over all existing product item keys within the specified ordered range. |
ProductItem[] |
getItems(Connection connection,
CatalogRequest request,
ProductItemKey[] productKeys)
Deprecated Returns the product items with the given product item keys. |
JdbcCatalogFactory |
getJdbcCatalogFactory()
Deprecated |
String[] |
getKeywords(Connection connection,
CatalogRequest request,
ProductItemKey productKey)
Deprecated Returns the keywords associated with a given product item. |
int |
getOrphanedItemCount(Connection connection,
CatalogRequest request)
Deprecated Returns the number of orphaned items in the catalog. |
ProductItemKey[] |
getOrphanedItemKeys(Connection connection,
CatalogRequest request,
int beginIndex,
int endIndex)
Deprecated Returns an array of all existing orphaned item keys within the specified ordered range. |
Category |
getParent(Connection connection,
CatalogRequest request,
CategoryKey categoryKey)
Deprecated Returns the parent of the specified category. |
Category |
getRootCategory(Connection connection,
CatalogRequest request)
Deprecated Returns the root category. |
int |
getSiblingCount(Connection connection,
CatalogRequest request,
CategoryKey categoryKey)
Deprecated Returns the number of siblings associated with the specified category. |
CategoryKey[] |
getSiblingKeys(Connection connection,
CatalogRequest request,
CategoryKey categoryKey,
int beginIndex,
int endIndex)
Deprecated 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)
Deprecated Returns the number of sub categories associated with the specified category. |
CategoryKey[] |
getSubCategoryKeys(Connection connection,
CatalogRequest request,
CategoryKey categoryKey,
int beginIndex,
int endIndex)
Deprecated Returns an array of all sub category keys of the specified category within the specified ordered range. |
void |
initialize(String schemaName)
Deprecated |
void |
moveCategory(Connection connection,
CatalogRequest request,
CategoryKey categoryKey,
CategoryKey newParentKey)
Deprecated Moves the specifed category. |
void |
removeCategory(Connection connection,
CatalogRequest request,
CategoryKey categoryKey)
Deprecated Removes the specifed category. |
void |
removeItem(Connection connection,
CatalogRequest request,
CategoryKey categoryKey,
ProductItemKey itemKey)
Deprecated Removes an item from the specified category. |
void |
removeItem(Connection connection,
CatalogRequest request,
ProductItemKey productKey)
Deprecated Removes a product item. |
void |
setKeywords(Connection connection,
CatalogRequest request,
ProductItemKey productKey,
String[] keywords)
Deprecated Sets the keywords for a given product item. |
void |
updateCategory(Connection connection,
CatalogRequest request,
Category category)
Deprecated Updates the specifed category. |
void |
updateItem(Connection connection,
CatalogRequest request,
ProductItem product)
Deprecated 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(String schemaName)
initialize
in interface CatalogSqlManager
public CatalogSchemaManager getCatalogSchemaManager()
getCatalogSchemaManager
in interface CatalogSqlManager
public JdbcCatalogFactory getJdbcCatalogFactory()
getJdbcCatalogFactory
in interface CatalogSqlManager
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 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 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.keys
- The keys of the target product items.
CatalogFinderException
- if a product item with a given key does not exist.
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 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 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 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 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.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.product
- The product item to remove.
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 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 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 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 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 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 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 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 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 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.keys
- The keys of the target categories.
CatalogFinderException
- if a category with a given key does not exist.
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 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 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 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 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 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[] 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 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 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 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 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.parentKey
- The key of the new parent category.
CatalogFinderException
- if the specified target or parent category could not be found.
CatalogException
- on general error.
SQLException
- on database access error.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 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.
|
Copyright © 2000, 2008, Oracle and/or its affiliates. All rights reserved. | ||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |