001: /*
002: * $Header: /cvsroot/mvnforum/mvnforum/contrib/phpbb2mvnforum/src/org/mvnforum/phpbb2mvnforum/db/MemberDAO.java,v 1.7 2007/01/15 10:27:34 dungbtm Exp $
003: * $Author: dungbtm $
004: * $Revision: 1.7 $
005: * $Date: 2007/01/15 10:27:34 $
006: *
007: * ====================================================================
008: *
009: * Copyright (C) 2002-2007 by MyVietnam.net
010: *
011: * All copyright notices regarding mvnForum MUST remain
012: * intact in the scripts and in the outputted HTML.
013: * The "powered by" text/logo with a link back to
014: * http://www.mvnForum.com and http://www.MyVietnam.net in
015: * the footer of the pages MUST remain visible when the pages
016: * are viewed on the internet or intranet.
017: *
018: * This program is free software; you can redistribute it and/or modify
019: * it under the terms of the GNU General Public License as published by
020: * the Free Software Foundation; either version 2 of the License, or
021: * any later version.
022: *
023: * This program is distributed in the hope that it will be useful,
024: * but WITHOUT ANY WARRANTY; without even the implied warranty of
025: * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
026: * GNU General Public License for more details.
027: *
028: * You should have received a copy of the GNU General Public License
029: * along with this program; if not, write to the Free Software
030: * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
031: *
032: * Support can be obtained from support forums at:
033: * http://www.mvnForum.com/mvnforum/index
034: *
035: * Correspondence and Marketing Questions can be sent to:
036: * info at MyVietnam net
037: *
038: * @author:
039: */
040: package org.mvnforum.phpbb2mvnforum.db;
041:
042: import java.sql.Date;
043: import java.sql.Timestamp;
044:
045: import net.myvietnam.mvncore.exception.CreateException;
046: import net.myvietnam.mvncore.exception.DatabaseException;
047: import net.myvietnam.mvncore.exception.DuplicateKeyException;
048: import net.myvietnam.mvncore.exception.ObjectNotFoundException;
049:
050: public interface MemberDAO {
051:
052: static final String TABLE_NAME = "mvnforumMember";
053:
054: void update(
055: int memberID, // primary key
056: String memberName, String memberPassword,
057: String memberFirstEmail, String memberEmail,
058: int memberEmailVisible, int memberNameVisible,
059: String memberFirstIP, String memberLastIP,
060: int memberViewCount, int memberPostCount,
061: Timestamp memberCreationDate, Timestamp memberModifiedDate,
062: Timestamp memberExpireDate, Timestamp memberLastLogon,
063: int memberOption, int memberStatus,
064: String memberActivateCode, String memberTempPassword,
065: int memberMessageCount, int memberMessageOption,
066: int memberPostsPerPage, int memberWarnCount,
067: int memberVoteCount, int memberVoteTotalStars,
068: int memberRewardPoints, String memberTitle,
069: double memberTimeZone, String memberSignature,
070: String memberAvatar, String memberSkin,
071: String memberLanguage, String memberFirstname,
072: String memberLastname, int memberGender,
073: Date memberBirthday, String memberAddress,
074: String memberCity, String memberState,
075: String memberCountry, String memberPhone,
076: String memberMobile, String memberFax, String memberCareer,
077: String memberHomepage, String memberYahoo,
078: String memberAol, String memberIcq, String memberMsn,
079: String memberCoolLink1, String memberCoolLink2)
080: throws ObjectNotFoundException, DatabaseException,
081: DuplicateKeyException;
082:
083: void create(int memberId, String memberName, String memberPassword,
084: String memberFirstEmail, String memberEmail,
085: int memberEmailVisible, int memberNameVisible,
086: String memberFirstIP, String memberLastIP,
087: int memberViewCount, int memberPostCount,
088: Timestamp memberCreationDate, Timestamp memberModifiedDate,
089: Timestamp memberExpireDate, Timestamp memberLastLogon,
090: int memberOption, int memberStatus,
091: String memberActivateCode, String memberTempPassword,
092: int memberMessageCount, int memberMessageOption,
093: int memberPostsPerPage, int memberWarnCount,
094: int memberVoteCount, int memberVoteTotalStars,
095: int memberRewardPoints, String memberTitle, double tzone,
096: String memberSignature, String memberAvatar,
097: String memberSkin, String memberLanguage,
098: String memberFirstname, String memberLastname,
099: int memberGender, Date memberBirthday,
100: String memberAddress, String memberCity,
101: String memberState, String memberCountry,
102: String memberPhone, String memberMobile, String memberFax,
103: String memberCareer, String memberHomepage,
104: String memberYahoo, String memberAol, String memberIcq,
105: String memberMsn, String memberCoolLink1,
106: String memberCoolLink2) throws CreateException,
107: DatabaseException, DuplicateKeyException;
108:
109: void create(String memberName, String memberPassword,
110: String memberFirstEmail, String memberEmail,
111: int memberEmailVisible, int memberNameVisible,
112: String memberFirstIP, String memberLastIP,
113: int memberViewCount, int memberPostCount,
114: Timestamp memberCreationDate, Timestamp memberModifiedDate,
115: Timestamp memberExpireDate, Timestamp memberLastLogon,
116: int memberOption, int memberStatus,
117: String memberActivateCode, String memberTempPassword,
118: int memberMessageCount, int memberMessageOption,
119: int memberPostsPerPage, int memberWarnCount,
120: int memberVoteCount, int memberVoteTotalStars,
121: int memberRewardPoints, String memberTitle, double tzone,
122: String memberSignature, String memberAvatar,
123: String memberSkin, String memberLanguage,
124: String memberFirstname, String memberLastname,
125: int memberGender, Date memberBirthday,
126: String memberAddress, String memberCity,
127: String memberState, String memberCountry,
128: String memberPhone, String memberMobile, String memberFax,
129: String memberCareer, String memberHomepage,
130: String memberYahoo, String memberAol, String memberIcq,
131: String memberMsn, String memberCoolLink1,
132: String memberCoolLink2) throws CreateException,
133: DatabaseException, DuplicateKeyException;
134:
135: public String getMemberNameFromMemberID(int memberID)
136: throws ObjectNotFoundException, DatabaseException;
137:
138: public MemberBean getMemberFromMemberName(String memberName)
139: throws ObjectNotFoundException, DatabaseException;
140:
141: public void findByPrimaryKey(int memberID)
142: throws ObjectNotFoundException, DatabaseException;
143:
144: }
|