net.myvietnam.mvnplugin.mvnforum.db
Class MemberWebHelper

java.lang.Object
  |
  +--net.myvietnam.mvnplugin.mvnforum.db.MemberWebHelper

public class MemberWebHelper
extends java.lang.Object


Field Summary
static java.lang.String TABLE_NAME
           
 
Constructor Summary
protected MemberWebHelper()
           
 
Method Summary
protected static void create(java.lang.String memberName, java.lang.String memberPassword, java.lang.String memberFirstEmail, java.lang.String memberEmail, int memberEmailVisible, int memberNameVisible, java.lang.String memberFirstIP, java.lang.String memberLastIP, int memberViewCount, int memberPostCount, java.sql.Timestamp memberCreationDate, java.sql.Timestamp memberModifiedDate, java.sql.Timestamp memberLastLogon, int memberOption, int memberStatus, java.lang.String memberActivateCode, java.lang.String memberTempPassword, int memberMessageCount, int memberMessageOption, int memberPostsPerPage, int memberWarnCount, int memberVoteCount, int memberVoteTotalStars, int memberRewardPoints, java.lang.String memberTitle, int memberTimeZone, java.lang.String memberSignature, java.lang.String memberAvatar, java.lang.String memberSkin, java.lang.String memberLanguage, java.lang.String memberFirstname, java.lang.String memberLastname, int memberGender, java.sql.Date memberBirthday, java.lang.String memberAddress, java.lang.String memberCity, java.lang.String memberState, java.lang.String memberCountry, java.lang.String memberPhone, java.lang.String memberMobile, java.lang.String memberFax, java.lang.String memberCareer, java.lang.String memberHomepage, java.lang.String memberYahoo, java.lang.String memberAol, java.lang.String memberIcq, java.lang.String memberMsn, java.lang.String memberCoolLink1, java.lang.String memberCoolLink2)
           
protected static void findByAlternateKey_MemberEmail(java.lang.String memberEmail)
           
static void findByAlternateKey_MemberName(java.lang.String memberName)
           
protected static void findByPrimaryKey(int memberID)
           
protected static MemberBean getBean_forEditCurrentMember(int memberID)
           
protected static MemberBean getBean_forPublic(int memberID)
           
protected static MemberBean getBean_forViewCurrentMember(int memberID)
           
protected static java.util.Collection getBeans_forPublic()
           
protected static java.util.Collection getBeans_withSortSupport_limit(int offset, int rowsToReturn, java.lang.String sort, java.lang.String order)
           
static int getMemberIDFromMemberEmail(java.lang.String memberEmail)
           
static int getMemberIDFromMemberName(java.lang.String memberName)
           
protected static int getNumberOfBeans()
           
protected static java.lang.String getPassword(int memberID)
           
protected static java.lang.String getTempPassword(int memberID)
           
protected static boolean isDirty()
           
protected static void setDirty(boolean dirty)
           
protected static void update(int memberID, int memberEmailVisible, int memberNameVisible, java.sql.Timestamp memberModifiedDate, int memberOption, int memberStatus, int memberMessageOption, int memberPostsPerPage, int memberTimeZone, java.lang.String memberSkin, java.lang.String memberLanguage, java.lang.String memberFirstname, java.lang.String memberLastname, int memberGender, java.sql.Date memberBirthday, java.lang.String memberAddress, java.lang.String memberCity, java.lang.String memberState, java.lang.String memberCountry, java.lang.String memberPhone, java.lang.String memberMobile, java.lang.String memberFax, java.lang.String memberCareer, java.lang.String memberHomepage, java.lang.String memberYahoo, java.lang.String memberAol, java.lang.String memberIcq, java.lang.String memberMsn, java.lang.String memberCoolLink1, java.lang.String memberCoolLink2)
           
protected static void updateAvatar(int memberID, java.lang.String memberAvatar)
           
protected static void updateEmail(int memberID, java.lang.String memberEmail)
           
protected static void updateLastLogon(int memberID, java.sql.Timestamp memberLastLogon)
           
protected static void updatePassword(int memberID, java.lang.String memberPassword)
           
protected static void updateSignature(int memberID, java.lang.String memberSignature)
           
protected static void updateTempPassword(int memberID, java.lang.String memberTempPassword)
           
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

TABLE_NAME

public static final java.lang.String TABLE_NAME
See Also:
Constant Field Values
Constructor Detail

MemberWebHelper

protected MemberWebHelper()
Method Detail

isDirty

protected static boolean isDirty()

setDirty

protected static void setDirty(boolean dirty)

findByPrimaryKey

protected static void findByPrimaryKey(int memberID)
                                throws net.myvietnam.mvncore.exception.ObjectNotFoundException,
                                       net.myvietnam.mvncore.exception.DatabaseException
net.myvietnam.mvncore.exception.ObjectNotFoundException
net.myvietnam.mvncore.exception.DatabaseException

findByAlternateKey_MemberName

public static final void findByAlternateKey_MemberName(java.lang.String memberName)
                                                throws net.myvietnam.mvncore.exception.ObjectNotFoundException,
                                                       net.myvietnam.mvncore.exception.DatabaseException
net.myvietnam.mvncore.exception.ObjectNotFoundException
net.myvietnam.mvncore.exception.DatabaseException

findByAlternateKey_MemberEmail

protected static void findByAlternateKey_MemberEmail(java.lang.String memberEmail)
                                              throws net.myvietnam.mvncore.exception.ObjectNotFoundException,
                                                     net.myvietnam.mvncore.exception.DatabaseException
net.myvietnam.mvncore.exception.ObjectNotFoundException
net.myvietnam.mvncore.exception.DatabaseException

create

protected static void create(java.lang.String memberName,
                             java.lang.String memberPassword,
                             java.lang.String memberFirstEmail,
                             java.lang.String memberEmail,
                             int memberEmailVisible,
                             int memberNameVisible,
                             java.lang.String memberFirstIP,
                             java.lang.String memberLastIP,
                             int memberViewCount,
                             int memberPostCount,
                             java.sql.Timestamp memberCreationDate,
                             java.sql.Timestamp memberModifiedDate,
                             java.sql.Timestamp memberLastLogon,
                             int memberOption,
                             int memberStatus,
                             java.lang.String memberActivateCode,
                             java.lang.String memberTempPassword,
                             int memberMessageCount,
                             int memberMessageOption,
                             int memberPostsPerPage,
                             int memberWarnCount,
                             int memberVoteCount,
                             int memberVoteTotalStars,
                             int memberRewardPoints,
                             java.lang.String memberTitle,
                             int memberTimeZone,
                             java.lang.String memberSignature,
                             java.lang.String memberAvatar,
                             java.lang.String memberSkin,
                             java.lang.String memberLanguage,
                             java.lang.String memberFirstname,
                             java.lang.String memberLastname,
                             int memberGender,
                             java.sql.Date memberBirthday,
                             java.lang.String memberAddress,
                             java.lang.String memberCity,
                             java.lang.String memberState,
                             java.lang.String memberCountry,
                             java.lang.String memberPhone,
                             java.lang.String memberMobile,
                             java.lang.String memberFax,
                             java.lang.String memberCareer,
                             java.lang.String memberHomepage,
                             java.lang.String memberYahoo,
                             java.lang.String memberAol,
                             java.lang.String memberIcq,
                             java.lang.String memberMsn,
                             java.lang.String memberCoolLink1,
                             java.lang.String memberCoolLink2)
                      throws net.myvietnam.mvncore.exception.CreateException,
                             net.myvietnam.mvncore.exception.DatabaseException,
                             net.myvietnam.mvncore.exception.DuplicateKeyException
net.myvietnam.mvncore.exception.CreateException
net.myvietnam.mvncore.exception.DatabaseException
net.myvietnam.mvncore.exception.DuplicateKeyException

update

protected static void update(int memberID,
                             int memberEmailVisible,
                             int memberNameVisible,
                             java.sql.Timestamp memberModifiedDate,
                             int memberOption,
                             int memberStatus,
                             int memberMessageOption,
                             int memberPostsPerPage,
                             int memberTimeZone,
                             java.lang.String memberSkin,
                             java.lang.String memberLanguage,
                             java.lang.String memberFirstname,
                             java.lang.String memberLastname,
                             int memberGender,
                             java.sql.Date memberBirthday,
                             java.lang.String memberAddress,
                             java.lang.String memberCity,
                             java.lang.String memberState,
                             java.lang.String memberCountry,
                             java.lang.String memberPhone,
                             java.lang.String memberMobile,
                             java.lang.String memberFax,
                             java.lang.String memberCareer,
                             java.lang.String memberHomepage,
                             java.lang.String memberYahoo,
                             java.lang.String memberAol,
                             java.lang.String memberIcq,
                             java.lang.String memberMsn,
                             java.lang.String memberCoolLink1,
                             java.lang.String memberCoolLink2)
                      throws net.myvietnam.mvncore.exception.BadInputException,
                             net.myvietnam.mvncore.exception.DatabaseException
net.myvietnam.mvncore.exception.BadInputException
net.myvietnam.mvncore.exception.DatabaseException

updateEmail

protected static void updateEmail(int memberID,
                                  java.lang.String memberEmail)
                           throws net.myvietnam.mvncore.exception.BadInputException,
                                  net.myvietnam.mvncore.exception.DatabaseException,
                                  net.myvietnam.mvncore.exception.DuplicateKeyException
net.myvietnam.mvncore.exception.BadInputException
net.myvietnam.mvncore.exception.DatabaseException
net.myvietnam.mvncore.exception.DuplicateKeyException

updatePassword

protected static void updatePassword(int memberID,
                                     java.lang.String memberPassword)
                              throws net.myvietnam.mvncore.exception.BadInputException,
                                     net.myvietnam.mvncore.exception.DatabaseException
net.myvietnam.mvncore.exception.BadInputException
net.myvietnam.mvncore.exception.DatabaseException

updateTempPassword

protected static void updateTempPassword(int memberID,
                                         java.lang.String memberTempPassword)
                                  throws net.myvietnam.mvncore.exception.BadInputException,
                                         net.myvietnam.mvncore.exception.DatabaseException
net.myvietnam.mvncore.exception.BadInputException
net.myvietnam.mvncore.exception.DatabaseException

updateAvatar

protected static void updateAvatar(int memberID,
                                   java.lang.String memberAvatar)
                            throws net.myvietnam.mvncore.exception.BadInputException,
                                   net.myvietnam.mvncore.exception.DatabaseException
net.myvietnam.mvncore.exception.BadInputException
net.myvietnam.mvncore.exception.DatabaseException

updateSignature

protected static void updateSignature(int memberID,
                                      java.lang.String memberSignature)
                               throws net.myvietnam.mvncore.exception.BadInputException,
                                      net.myvietnam.mvncore.exception.DatabaseException
net.myvietnam.mvncore.exception.BadInputException
net.myvietnam.mvncore.exception.DatabaseException

updateLastLogon

protected static void updateLastLogon(int memberID,
                                      java.sql.Timestamp memberLastLogon)
                               throws net.myvietnam.mvncore.exception.BadInputException,
                                      net.myvietnam.mvncore.exception.DatabaseException
net.myvietnam.mvncore.exception.BadInputException
net.myvietnam.mvncore.exception.DatabaseException

getPassword

protected static java.lang.String getPassword(int memberID)
                                       throws net.myvietnam.mvncore.exception.BadInputException,
                                              net.myvietnam.mvncore.exception.DatabaseException
net.myvietnam.mvncore.exception.BadInputException
net.myvietnam.mvncore.exception.DatabaseException

getTempPassword

protected static java.lang.String getTempPassword(int memberID)
                                           throws net.myvietnam.mvncore.exception.BadInputException,
                                                  net.myvietnam.mvncore.exception.DatabaseException
net.myvietnam.mvncore.exception.BadInputException
net.myvietnam.mvncore.exception.DatabaseException

getBean_forViewCurrentMember

protected static MemberBean getBean_forViewCurrentMember(int memberID)
                                                  throws net.myvietnam.mvncore.exception.BadInputException,
                                                         net.myvietnam.mvncore.exception.DatabaseException
net.myvietnam.mvncore.exception.BadInputException
net.myvietnam.mvncore.exception.DatabaseException

getBean_forEditCurrentMember

protected static MemberBean getBean_forEditCurrentMember(int memberID)
                                                  throws net.myvietnam.mvncore.exception.BadInputException,
                                                         net.myvietnam.mvncore.exception.DatabaseException
net.myvietnam.mvncore.exception.BadInputException
net.myvietnam.mvncore.exception.DatabaseException

getBean_forPublic

protected static MemberBean getBean_forPublic(int memberID)
                                       throws net.myvietnam.mvncore.exception.BadInputException,
                                              net.myvietnam.mvncore.exception.DatabaseException
net.myvietnam.mvncore.exception.BadInputException
net.myvietnam.mvncore.exception.DatabaseException

getBeans_forPublic

protected static java.util.Collection getBeans_forPublic()
                                                  throws net.myvietnam.mvncore.exception.DatabaseException
net.myvietnam.mvncore.exception.DatabaseException

getNumberOfBeans

protected static int getNumberOfBeans()
                               throws net.myvietnam.mvncore.exception.AssertionException,
                                      net.myvietnam.mvncore.exception.DatabaseException
net.myvietnam.mvncore.exception.AssertionException
net.myvietnam.mvncore.exception.DatabaseException

getMemberIDFromMemberName

public static final int getMemberIDFromMemberName(java.lang.String memberName)
                                           throws net.myvietnam.mvncore.exception.BadInputException,
                                                  net.myvietnam.mvncore.exception.DatabaseException
net.myvietnam.mvncore.exception.BadInputException
net.myvietnam.mvncore.exception.DatabaseException

getMemberIDFromMemberEmail

public static final int getMemberIDFromMemberEmail(java.lang.String memberEmail)
                                            throws net.myvietnam.mvncore.exception.BadInputException,
                                                   net.myvietnam.mvncore.exception.DatabaseException
net.myvietnam.mvncore.exception.BadInputException
net.myvietnam.mvncore.exception.DatabaseException

getBeans_withSortSupport_limit

protected static java.util.Collection getBeans_withSortSupport_limit(int offset,
                                                                     int rowsToReturn,
                                                                     java.lang.String sort,
                                                                     java.lang.String order)
                                                              throws net.myvietnam.mvncore.exception.BadInputException,
                                                                     java.lang.IllegalArgumentException,
                                                                     net.myvietnam.mvncore.exception.DatabaseException
net.myvietnam.mvncore.exception.BadInputException
java.lang.IllegalArgumentException
net.myvietnam.mvncore.exception.DatabaseException