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