// Finder Helper class
public interface UPBaseChildBeanFinderHelper
{
// All the query Strings are pointing
to table UserProfile.
// Using Visual Age for Java, you
can map your CMP fields
// to existing UserProfile table.
public static String findUserProfilesByPrimaryKeyQueryString="select * from userprofile where username = ?";
// In base implementation,
this String is modified dynamically in the persister class to handle datawrapper
// extensions adding new columns
using UserProfileExtender (i.e. to handle queries by newly added columns
// when the UserProfile EJB
is extended and specified in administrative console, base implementation is
not
// used at all). So for the
EJB extensions of UserProfile, this query function is not supported. Thus, the
function
// UPBaseChildBeanHome.findUserProfiles(String,String)
is not useful.
public static String findUserProfilesQueryString="select
* from userprofile where newColumn = ? and value = ?";
public static String findUserProfilesQueryString="select
* from userprofile where type = ? and userName = ?";
public static String findUserProfilesByAddress1QueryString="select
* from userprofile where address1=?";
public static String findUserProfilesByAddress2QueryString="select
* from userprofile where address2=?";
public static String findUserProfilesByNationQueryString="select
* from userprofile where nation=?";
public static String findUserProfilesByDayPhoneQueryString="select
* from userprofile where dayPhone=?";
public static String findUserProfilesByEMailQueryString="select
* from userprofile where email=?";
public static String findUserProfilesByEmployerQueryString="select
* from userprofile where employer=?";
public static String findUserProfilesByFaxQueryString="select
* from userprofile where fax=?";
public static String findUserProfilesByFirstNameQueryString="select
* from userprofile where firstname=?";
public static String findUserProfilesByLanguageQueryString="select
* from userprofile where language=?";
public static String findUserProfilesBySurNameQueryString="select
* from userprofile where surname=?";
public static String findUserProfilesByNightPhoneQueryString="select
* from userprofile where nightphone=?";
public static String findUserProfilesByStateOrProvinceQueryString="select
* from userprofile where stateorprovince=?";
public static String findUserProfilesByCityQueryString="select
* from userprofile where city=?";
public static String findUserProfilesByPostalCodeQueryString="select
* from userprofile where postalcode=?";
}