|
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object | +--com.ibm.ivj.ejb.runtime.AbstractAccessBean | +--com.ibm.ivj.ejb.runtime.AbstractSessionAccessBean | +--com.ibm.commerce.tools.optools.user.helpers.UserSearchAccessBean
UserSearchAccessBean
Fields inherited from class com.ibm.ivj.ejb.runtime.AbstractAccessBean |
DEFAULT_NAMESERVICE_PROVIDER_URL, DEFAULT_NAMESERVICE_TYPE, ejbRef |
Constructor Summary | |
UserSearchAccessBean()
Default constructor. |
|
UserSearchAccessBean(javax.ejb.EJBObject Object)
Creates an access bean for the specified EJB. |
Method Summary | |
com.ibm.commerce.tools.optools.common.helpers.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)
Contains the SQL. |
com.ibm.commerce.tools.optools.common.helpers.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.Integer start,
java.lang.Integer maxLength)
Contains the SQL for DB2. |
com.ibm.commerce.tools.optools.common.helpers.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.Integer start,
java.lang.Integer maxLength)
Contains the SQL for DB2. |
Methods inherited from class com.ibm.ivj.ejb.runtime.AbstractAccessBean |
defaultJNDIName, defaultNameServiceType, defaultNameServiceURL, getEJBRef, getGlobalHome, getHome, getInit_GlobalNameServiceTypeName, getInit_GlobalNameServiceURLName, getInit_JNDIName, getInit_NameServiceTypeName, getInit_NameServiceURLName, getInitContext, getInitContext, instantiateEJB, resetEJBRef, resetHomeCache, setEJBRef, setInit_GlobalNameServiceTypeName, setInit_GlobalNameServiceURLName, setInit_JNDIName, setInit_NameServiceTypeName, setInit_NameServiceURLName |
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
public UserSearchAccessBean()
Default constructor. Maps to findByPrimaryKey.
public UserSearchAccessBean(javax.ejb.EJBObject Object) throws java.rmi.RemoteException
Creates an access bean for the specified EJB.
object
- javax.ejb.EJBObjectjava.rmi.RemoteException
- The java.rmi.RemoteException exceptionMethod Detail |
public com.ibm.commerce.tools.optools.common.helpers.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, java.rmi.RemoteException
Contains the SQL.
SELECT DISTINCT USERS.USERS_ID
FROM USERS, ADDRESS, MBRREL, MBRROLE
WHERE USERS.PROFILETYPE='B' AND USERS.USERS_ID=MBRREL.DESCENDANT_ID
AND USERS.USERS_ID=ADDRESS.MEMBER_ID AND ADDRESS.LASTNAME like ?
AND MBRREL.ANCESTOR_ID = ? AND USERS.USERS_ID=MBRROLE.MEMBER_ID
AND MBRROLE.ROLE_ID = ?
lastName
- java.lang.StringorgIdjava.lang.String
- roleId
- java.lang.Stringorderby
- java.lang.Stringstart
- java.lang.IntegermaxLength
- java.lang.Integerjavax.naming.NamingException
- The javax.naming.NamingException exceptionjava.sql.SQLException
- The java.sql.SQLException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjava.rmi.RemoteException
- The java.rmi.RemoteException exceptionpublic com.ibm.commerce.tools.optools.common.helpers.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.Integer start, java.lang.Integer maxLength) throws javax.naming.NamingException, java.sql.SQLException, javax.ejb.CreateException, java.rmi.RemoteException
Contains the SQL for DB2.
UNION SELECT USERS.USERS_ID, ADDRESS_ID, LOGONID, FIRSTNAME, LASTNAME, PHONE1, CITY, EMAIL1, ZIPCODE
FROM USERS, USERREG, ADDRESS, ACCOUNT, MBRREL, ORGENTITY, TRADING, PARTICIPNT
WHERE USERS.REGISTERTYPE IN ('R','A','S') AND USERS.USERS_ID=USERREG.USERS_ID
AND USERS.USERS_ID=ADDRESS.MEMBER_ID AND ADDRESS.STATUS='P' AND ADDRESS.SELFADDRESS = 1
AND ORGENTITY.ORGENTITYTYPE = 'O' AND USERS.USERS_ID = MBRREL.DESCENDANT_ID
AND ACCOUNT.ACCOUNT_ID = TRADING.TRADING_ID AND TRADING.TRADING_ID = PARTICIPNT.TRADING_ID
AND PARTICIPNT.PARTROLE_ID = 5 AND PARTICIPNT.MEMBER_ID = MBRREL.ANCESTOR_ID
AND ORGENTITY.ORGENTITY_ID = PARTICIPNT.MEMBER_ID AND SUBSTR(LOGONID, 1, LOCATE(',', LOGONID)) LIKE ?
AND FIRSTNAME LIKE ? AND LASTNAME like ? AND PHONE1 LIKE ? AND EMAIL1 LIKE ?
AND CITY LIKE ? AND ZIPCODE LIKE ? AND ACCOUNT.ACCOUNT_ID = ? ORDERBY LOGONID
SQL for ORACLE:
UNION SELECT USERS.USERS_ID, ADDRESS_ID, LOGONID, FIRSTNAME, LASTNAME, PHONE1, CITY, EMAIL1, ZIPCODE
FROM USERS, USERREG, ADDRESS, ACCOUNT, MBRREL, ORGENTITY, TRADING, PARTICIPNT
WHERE USERS.REGISTERTYPE IN ('R','A','S') AND USERS.USERS_ID=USERREG.USERS_ID
AND USERS.USERS_ID=ADDRESS.MEMBER_ID AND ADDRESS.STATUS='P' AND ADDRESS.SELFADDRESS = 1
AND ORGENTITY.ORGENTITYTYPE = 'O' AND USERS.USERS_ID = MBRREL.DESCENDANT_ID
AND ACCOUNT.ACCOUNT_ID = TRADING.TRADING_ID AND TRADING.TRADING_ID = PARTICIPNT.TRADING_ID
AND PARTICIPNT.PARTROLE_ID = 5 AND PARTICIPNT.MEMBER_ID = MBRREL.ANCESTOR_ID
AND ORGENTITY.ORGENTITY_ID = PARTICIPNT.MEMBER_ID AND AND SUBSTR( LOGONID, 1, INSTR(LOGONID, ',')) LIKE ?
AND FIRSTNAME LIKE ? AND LASTNAME like ? AND PHONE1 LIKE ? AND EMAIL1 LIKE ?
AND CITY LIKE ? AND ZIPCODE LIKE ? AND ACCOUNT.ACCOUNT_ID = ? ORDERBY LOGONID
logonId
- java.lang.StringfirstName
- 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.Stringstart
- java.lang.IntegermaxLength
- java.lang.Integerjavax.naming.NamingException
- The javax.naming.NamingException exceptionjava.sql.SQLException
- The java.sql.SQLException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjava.rmi.RemoteException
- The java.rmi.RemoteException exceptionpublic com.ibm.commerce.tools.optools.common.helpers.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.Integer start, java.lang.Integer maxLength) throws javax.naming.NamingException, java.sql.SQLException, java.rmi.RemoteException, javax.ejb.CreateException
Contains the SQL for DB2.
SELECT DISTINCT USERS.USERS_ID, LOGONID, FIRSTNAME, LASTNAME, PHONE1, CITY, EMAIL1, ZIPCODE
FROM USERS, USERREG LEFT OUTER JOIN ADDRESS ON USERREG.USERS_ID = ADDRESS.MEMBER_ID AND ADDRESS.STATUS='P' AND ADDRESS.SELFADDRESS = 1
WHERE USERS.REGISTERTYPE='R' AND USERS.USERS_ID=USERREG.USERS_ID AND USERS.PROFILETYPE = 'C'
AND ((LOGONID LIKE ? ESCAPE '\\') OR (LOGONID LIKE ? ESCAPE '\\'))
AND FIRSTNAME LIKE ? ESCAPE '\\' AND LASTNAME LIKE ? ESCAPE '\\'
AND PHONE1 LIKE ? ESCAPE '\\' AND EMAIL1 LIKE ? ESCAPE '\\'
AND CITY LIKE ? ESCAPE '\\' AND ZIPCODE LIKE ? ESCAPE '\\'
ORDER BY LOGONID
The SQL for ORACLE:
SELECT DISTINCT USERS.USERS_ID, LOGONID, FIRSTNAME, LASTNAME, PHONE1, CITY, EMAIL1, ZIPCODE
FROM USERS, USERREG, ADDRESS
WHERE USERREG.USERS_ID = ADDRESS.MEMBER_ID(+) AND ADDRESS.STATUS(+)='P'
AND ADDRESS.SELFADDRESS(+) = 1 AND USERS.REGISTERTYPE='R'
AND SERS.USERS_ID=USERREG.USERS_ID AND USERS.PROFILETYPE = 'C'
AND ((LOGONID LIKE ? ESCAPE '\\') OR (LOGONID LIKE ? ESCAPE '\\'))
AND FIRSTNAME LIKE ? ESCAPE '\\' AND LASTNAME LIKE ? ESCAPE '\\'
AND PHONE1 LIKE ? ESCAPE '\\' AND EMAIL1 LIKE ? ESCAPE '\\'
AND CITY LIKE ? ESCAPE '\\' AND ZIPCODE LIKE ? ESCAPE '\\'
ORDER BY LOGONID
logonId
- java.lang.StringfirstName
- 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.Stringstart
- java.lang.IntegermaxLength
- java.lang.Integerjavax.naming.NamingException
- The javax.naming.NamingException exceptionjava.sql.SQLException
- The java.sql.SQLException exceptionjava.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exception
|
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |