java.lang.Objectcom.ibm.ivj.ejb.runtime.AbstractSessionAccessBean
com.ibm.commerce.tools.optools.order.helpers.OrderProductSearchAccessBean
Constructor Summary | |
OrderProductSearchAccessBean() Default constructor. |
|
OrderProductSearchAccessBean(javax.ejb.EJBObject o) This method was generated by the VisualAge for Java Access Bean SmartGuide. |
Method Summary | |
protected java.lang.String | defaultJNDIName() This method was generated by the VisualAge for Java Access Bean SmartGuide. |
com.ibm.commerce.tools.optools.common.helpers.DynamicListData | findItemBySkuNameDesc(java.lang.String SKULike, java.lang.String nameLike, java.lang.String descLike, java.lang.String orderBy, java.lang.String langId, java.lang.String storeId) Searches the catalog and return a list of products that are currently available for sale depending on the criterias specified. |
com.ibm.commerce.tools.optools.common.helpers.DynamicListData | findItemBySkuNameDesc(java.lang.String SKULike, java.lang.String nameLike, java.lang.String descLike, java.lang.String orderBy, java.lang.String langId, java.util.Vector storeIds) Performs a fuzzy search on SKU, name, and description. |
com.ibm.commerce.tools.optools.common.helpers.DynamicListData | findItemBySkuNameDescWithMax(java.lang.String SKULike, java.lang.String nameLike, java.lang.String descLike, java.lang.String orderBy, java.lang.String langId, java.lang.String storeId, java.lang.String maxMatches) Searches the catalog and return a list of products that are currently available for sale depending on the criterias specified. |
com.ibm.commerce.tools.optools.common.helpers.DynamicListData | findItemBySkuNameDescWithMax(java.lang.String SKULike, java.lang.String nameLike, java.lang.String descLike, java.lang.String orderBy, java.lang.String langId, java.util.Vector storeIds, java.lang.String maxMatches) Performs a fuzzy search on SKU, name, and description. |
protected void | instantiateEJB() This method was generated by the VisualAge for Java Access Bean SmartGuide. |
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
public OrderProductSearchAccessBean()
Default constructor.
public OrderProductSearchAccessBean(javax.ejb.EJBObject o) throws java.rmi.RemoteException
Method Detail |
protected java.lang.String defaultJNDIName()
protected void instantiateEJB() throws javax.ejb.CreateException, java.rmi.RemoteException, javax.naming.NamingException
public com.ibm.commerce.tools.optools.common.helpers.DynamicListData findItemBySkuNameDesc(java.lang.String SKULike, java.lang.String nameLike, java.lang.String descLike, java.lang.String orderBy, java.lang.String langId, java.lang.String storeId) throws javax.naming.NamingException, java.sql.SQLException, javax.ejb.CreateException, java.rmi.RemoteException, javax.ejb.FinderException
Searches the catalog and return a list of products that are currently available for sale depending on the criterias specified.
The SQL query executed depends on the input parameters. A sample query where all input parameters are given:
SELECT CATENTRY.CATENTRY_ID, CATENTRY.PARTNUMBER, CATENTDESC.NAME, CATENTDESC.SHORTDESCRIPTION FROM CATENTRY, CATENTDESC, STORECENT WHERE (CATENTRY.BUYABLE IS NULL OR CATENTRY.BUYABLE <> 0) AND (CATENTRY.MARKFORDELETE <> 1) AND (CATENTRY.PUBLISHED = 1) AND (CATENTRY.CATENTRY_ID = CATENTDESC.CATENTRY_ID) AND (CATENTRY.CATENTRY_ID = STORECENT.CATENTRY_ID) AND (CATENTRY.CATENTRYTYPE_ID = 'ItemBean')
AND (STORECENT.STOREENT_ID = ? OR STORECENT.STOREENT_ID = ?) AND (CATENTRY.PARTNUMBER LIKE ? ESCAPE '\\') AND (CATENTRY.LANGUAGUE_ID = ?) AND (UPPER(CATENTDESC.NAME LIKE ? ESCAPE '\\')) AND (UPPER(CATENTDESC.SHORTDESCRIPTION LIKE ? ESCAPE '\\')) ORDER BY CATENTRY.PARTNUMBER
The possible values for orderBy are:
public com.ibm.commerce.tools.optools.common.helpers.DynamicListData findItemBySkuNameDesc(java.lang.String SKULike, java.lang.String nameLike, java.lang.String descLike, java.lang.String orderBy, java.lang.String langId, java.util.Vector storeIds) throws javax.naming.NamingException, javax.ejb.FinderException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
public com.ibm.commerce.tools.optools.common.helpers.DynamicListData findItemBySkuNameDescWithMax(java.lang.String SKULike, java.lang.String nameLike, java.lang.String descLike, java.lang.String orderBy, java.lang.String langId, java.util.Vector storeIds, java.lang.String maxMatches) throws javax.naming.NamingException, javax.ejb.FinderException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
public com.ibm.commerce.tools.optools.common.helpers.DynamicListData findItemBySkuNameDescWithMax(java.lang.String SKULike, java.lang.String nameLike, java.lang.String descLike, java.lang.String orderBy, java.lang.String langId, java.lang.String storeId, java.lang.String maxMatches) throws javax.naming.NamingException, javax.ejb.FinderException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
Searches the catalog and return a list of products that are currently available for sale depending on the criterias specified.
The SQL query executed depends on the input parameters. A sample query where all input parameters are given:
SELECT CATENTRY.CATENTRY_ID, CATENTRY.PARTNUMBER, CATENTDESC.NAME, CATENTDESC.SHORTDESCRIPTION FROM CATENTRY, CATENTDESC, STORECENT WHERE (CATENTRY.BUYABLE IS NULL OR CATENTRY.BUYABLE <> 0) AND (CATENTRY.MARKFORDELETE <> 1) AND (CATENTRY.PUBLISHED = 1) AND (CATENTRY.CATENTRY_ID = CATENTDESC.CATENTRY_ID) AND (CATENTRY.CATENTRY_ID = STORECENT.CATENTRY_ID) AND (CATENTRY.CATENTRYTYPE_ID = 'ItemBean')
AND (STORECENT.STOREENT_ID = ? OR STORECENT.STOREENT_ID = ?) AND (CATENTRY.PARTNUMBER LIKE ? ESCAPE '\\') AND (CATENTRY.LANGUAGUE_ID = ?) AND (UPPER(CATENTDESC.NAME LIKE ? ESCAPE '\\')) AND (UPPER(CATENTDESC.SHORTDESCRIPTION LIKE ? ESCAPE '\\')) FETCH FIRST n ROWS ONLY ORDER BY CATENTRY.PARTNUMBER
The possible values for orderBy are:
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.