com.ibm.commerce.tools.optools.user.helpers
Class UserSearchBean

java.lang.Object
  com.ibm.commerce.base.helpers.BaseJDBCHelper
      com.ibm.commerce.tools.optools.user.helpers.UserSearchBean

public class UserSearchBean
extends BaseJDBCHelper

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, ISDB2_390
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

COPYRIGHT

public static final java.lang.String COPYRIGHT
IBM copyright notice field.
See Also:
Constant Field Values
Constructor Detail

UserSearchBean

public UserSearchBean()
Method Detail

ejbActivate

public void ejbActivate()
ejbActivate method comment
Throws:
java.rmi.RemoteException - The exception description.

ejbCreate

public void ejbCreate()
               throws javax.ejb.CreateException
ejbCreate method comment
Throws:
javax.ejb.CreateException - The exception description.
java.rmi.RemoteException - The exception description.

ejbPassivate

public void ejbPassivate()
ejbPassivate method comment
Throws:
java.rmi.RemoteException - The exception description.

ejbRemove

public void ejbRemove()
ejbRemove method comment
Throws:
java.rmi.RemoteException - The exception description.

findBusinessUsers

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
Search users (Only registered customers who has a REGISTERTYPE="R" in the USERS table
Parameters:
lastName - java.lang.String
orgId - java.lang.String
roleId - java.lang.String
orderby - java.lang.String
start - java.lang.Integer
maxLength - java.lang.Integer
Returns:
java.util.Vector
Throws:
javax.naming.NamingException - The exception description.
java.rmi.RemoteException - The exception description.
java.sql.SQLException - The exception description.
javax.ejb.CreateException

findCollaborativeMembers

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
Search for Collaborative Users - Registered Users and Administrators - Users who are not buyers - if an account is specified, anyone under the account
Parameters:
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.String
start - java.lang.Integer
maxLength - java.lang.Integer
Returns:
java.util.Vector
Throws:
javax.naming.NamingException - The exception description.
java.rmi.RemoteException - The exception description.
java.sql.SQLException - The exception description.
javax.ejb.CreateException

findCustomers

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
Search users (Only registered customers who has a REGISTERTYPE="R" in the USERS table
Parameters:
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.String
start - java.lang.Integer
maxLength - java.lang.Integer
Returns:
java.util.Vector
Throws:
javax.naming.NamingException - The exception description.
java.rmi.RemoteException - The exception description.
java.sql.SQLException - The exception description.

findCustomersAdvancedSearch

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
Finds customers using advanced search. For each search fields, user can choose one of the following search type:
  • Match case, beginning with
  • Match case, containing
  • Ignore case, beginning with
  • Ignorecase, containing
  • Exact Match
  • The search will be based on the search criteria. Some may have performance impact.
    Parameters:
    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.
    Returns:
    com.ibm.commerce.tools.optools.common.helpers.DynamicListData
    Throws:
    javax.naming.NamingException - The exception description.
    java.sql.SQLException - The exception description.

getSessionContext

public javax.ejb.SessionContext getSessionContext()
getSessionContext method comment
Specified by:
getSessionContext in class BaseJDBCHelper
Returns:
javax.ejb.SessionContext

getUpperCaseFunction

public static final java.lang.String getUpperCaseFunction()
Insert the method's description here. Creation date: (6/14/00 2:29:12 PM)
Returns:
java.lang.String

getLowerCaseFunction

protected static final java.lang.String getLowerCaseFunction()
Gets the lower case function sql string for the database used.
Returns:
"LCASE" if uses DB2 or "LOWER" if uses Oracle. Default to DB2.

setSessionContext

public void setSessionContext(javax.ejb.SessionContext ctx)
                       throws java.rmi.RemoteException
setSessionContext method comment
Parameters:
ctx - javax.ejb.SessionContext
Throws:
java.rmi.RemoteException - The exception description.

Feedback