java.lang.Object | +--com.ibm.commerce.base.helpers.BaseJDBCHelper | +--com.ibm.commerce.tools.optools.user.helpers.UserSearchBean
This is a Session Bean Class
Field Summary | |
---|---|
static java.lang.String |
COPYRIGHT IBM copyright notice field. |
Fields inherited from class com.ibm.commerce.base.helpers. BaseJDBCHelper |
autoFlush,
DATASOURCE,
dataSourceConfigData,
DB_DB2,
DB_DB2_390,
DB_DB2J,
DB_ORACLE,
DBTYPE,
mySessionCtx |
Constructor Summary | |
---|---|
UserSearchBean() |
Method Summary | |
---|---|
void |
ejbActivate() ejbActivate method comment |
void |
ejbCreate() ejbCreate method comment |
void |
ejbPassivate() ejbPassivate method comment |
void |
ejbRemove() ejbRemove method comment |
DynamicListData |
findBusinessUsers(java.lang.String lastName, java.lang.String orgId,
java.lang.String roleId, java.lang.String orderby, java.lang.Integer start,
java.lang.Integer maxLength) Search users (Only registered customers who has a REGISTERTYPE="R" in the USERS table |
DynamicListData |
findCollaborativeMembers(java.lang.String logonId,
java.lang.String firstName, java.lang.String lastName, java.lang.String phone,
java.lang.String email, java.lang.String city, java.lang.String zip,
java.lang.String accountId, java.lang.String orderby,
java.lang.String storeType, java.lang.String storeMemberId,
java.lang.Integer start, java.lang.Integer maxLength) Search for Collaborative Users - Registered Users and Administrators - Users who are not buyers - if an account is specified, anyone under the account |
DynamicListData |
findCustomers(java.lang.String logonId, java.lang.String firstName,
java.lang.String lastName, java.lang.String phone, java.lang.String email,
java.lang.String city, java.lang.String zip, java.lang.String accountId,
java.lang.String orderby, java.lang.String storeType,
java.lang.String storeMemberId, java.lang.Integer start,
java.lang.Integer maxLength) Search users (Only registered customers who has a REGISTERTYPE="R" in the USERS table |
DynamicListData |
findCustomersAdvancedSearch(java.lang.String logonId,
java.lang.String logonIdSearchType, java.lang.String firstName,
java.lang.String firstNameSearchType, java.lang.String lastName,
java.lang.String lastNameSearchType, java.lang.String phone,
java.lang.String phoneSearchType, java.lang.String email,
java.lang.String emailSearchType, java.lang.String city,
java.lang.String citySearchType, java.lang.String zip,
java.lang.String zipSearchType, java.lang.String accountId,
java.lang.String orderBy, java.lang.String storeType,
java.lang.String storeMemberId, java.lang.Integer start,
java.lang.Integer maxLength) Finds customers using advanced search. |
protected
static java.lang.String |
getLowerCaseFunction() Gets the lower case function sql string for the database used. |
javax.ejb.SessionContext |
getSessionContext() getSessionContext method comment |
static java.lang.String |
getUpperCaseFunction() Insert the method's description here. |
void |
setSessionContext(javax.ejb.SessionContext ctx) setSessionContext method comment |
Methods inherited from class com.ibm.commerce.base.helpers. BaseJDBCHelper |
buildCommaSeparatedWhereClause,
closeConnection,
convertFirstRowToHashtable,
convertResultSetToTable,
convertRowFromHashtable,
debugInitConnection,
executeQuery,
executeUpdate,
flush,
getCallableStatement,
getCharacterStreamFromResultSet,
getConnection,
getDataSource,
getPreparedStatement,
getPreparedStatement,
init,
init,
makeConnection,
useCloudscape,
useDB2_390,
useDB2,
useOracle |
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 COPYRIGHT
Constructor Detail |
---|
public UserSearchBean()
Method Detail |
---|
public void ejbActivate()
java.rmi.RemoteException
- The exception
description.public void ejbCreate() throws javax.ejb.CreateException
javax.ejb.CreateException
- The exception description.java.rmi.RemoteException
- The exception
description.public void ejbPassivate()
java.rmi.RemoteException
- The exception
description.public void ejbRemove()
java.rmi.RemoteException
- The exception
description.public DynamicListData findBusinessUsers(java.lang.String lastName, java.lang.String orgId, java.lang.String roleId, java.lang.String orderby, java.lang.Integer start, java.lang.Integer maxLength) throws javax.naming.NamingException, java.sql.SQLException, javax.ejb.CreateException
lastName
- java.lang.StringorgId
- java.lang.StringroleId
- java.lang.Stringorderby
- java.lang.Stringstart
- java.lang.IntegermaxLength
- java.lang.Integerjavax.naming.NamingException
- The exception description.java.rmi.RemoteException
- The exception description.java.sql.SQLException
- The exception description.javax.ejb.CreateException
public DynamicListData findCollaborativeMembers(java.lang.String logonId, java.lang.String firstName, java.lang.String lastName, java.lang.String phone, java.lang.String email, java.lang.String city, java.lang.String zip, java.lang.String accountId, java.lang.String orderby, java.lang.String storeType, java.lang.String storeMemberId, java.lang.Integer start, java.lang.Integer maxLength) throws javax.naming.NamingException, java.sql.SQLException, javax.ejb.CreateException
firstName
- java.lang.StringlastName
- java.lang.Stringphone
- java.lang.Stringemail
- java.lang.Stringcity
- java.lang.Stringzip
- java.lang.StringaccountId
- java.lang.Stringorderby
- java.lang.StringstoreType
- java.lang.StringstoreMemberId
- java.lang.Stringstart
- java.lang.IntegermaxLength
- java.lang.Integerjavax.naming.NamingException
- The exception description.java.rmi.RemoteException
- The exception description.java.sql.SQLException
- The exception description.javax.ejb.CreateException
public DynamicListData findCustomers(java.lang.String logonId, java.lang.String firstName, java.lang.String lastName, java.lang.String phone, java.lang.String email, java.lang.String city, java.lang.String zip, java.lang.String accountId, java.lang.String orderby, java.lang.String storeType, java.lang.String storeMemberId, java.lang.Integer start, java.lang.Integer maxLength) throws javax.naming.NamingException, java.sql.SQLException
firstName
- java.lang.StringlastName
- java.lang.Stringphone
- java.lang.Stringemail
- java.lang.Stringcity
- java.lang.Stringzip
- java.lang.StringaccountId
- java.lang.Stringorderby
- java.lang.StringstoreType
- java.lang.StringstoreMemberId
- java.lang.Stringstart
- java.lang.IntegermaxLength
- java.lang.Integerjavax.naming.NamingException
- The exception description.java.rmi.RemoteException
- The exception description.java.sql.SQLException
- The exception
description.public DynamicListData findCustomersAdvancedSearch(java.lang.String logonId, java.lang.String logonIdSearchType, java.lang.String firstName, java.lang.String firstNameSearchType, java.lang.String lastName, java.lang.String lastNameSearchType, java.lang.String phone, java.lang.String phoneSearchType, java.lang.String email, java.lang.String emailSearchType, java.lang.String city, java.lang.String citySearchType, java.lang.String zip, java.lang.String zipSearchType, java.lang.String accountId, java.lang.String orderBy, java.lang.String storeType, java.lang.String storeMemberId, java.lang.Integer start, java.lang.Integer maxLength) throws javax.naming.NamingException, java.sql.SQLException
logonId
- The customer's logon ID.logonIdSearchType
- logonId field search type.firstName
- The customer's firstName.firstNameSearchType
- firstName search type.lastName
- The customer's last name.lastNameSearchType
- lastName search type.phone
- The customer's phone number.phoneSearchType
- phone search type.email
- The customer's email address.emailSearchType
- email search type.city
- The city where the customer lives in.citySearchType
- city search type.zip
- The customer's address zip code.zipSearchType
- zip search type.accountId
- The customer's account ID.orderBy
- The field name to be sorted.storeType
- The store type.storeMemberId
- The store member ID.start
- Start index.maxLength
- The max length for result return.javax.naming.NamingException
- The exception description.java.sql.SQLException
- The exception
description.public javax.ejb.SessionContext getSessionContext()
getSessionContext
in class
BaseJDBCHelper
public static final java.lang.String getUpperCaseFunction()
protected static final java.lang.String getLowerCaseFunction()
public void setSessionContext(javax.ejb.SessionContext ctx) throws java.rmi.RemoteException
ctx
- javax.ejb.SessionContextjava.rmi.RemoteException
- The exception
description.