KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > mvnforum > db > MemberTutorDAO


1 /*
2  * $Header: /cvsroot/mvnforum/mvnforum/src/com/mvnforum/db/MemberTutorDAO.java,v 1.9 2006/04/14 17:05:26 minhnn Exp $
3  * $Author: minhnn $
4  * $Revision: 1.9 $
5  * $Date: 2006/04/14 17:05:26 $
6  *
7  * ====================================================================
8  *
9  * Copyright (C) 2002-2006 by MyVietnam.net
10  *
11  * All copyright notices regarding mvnForum MUST remain
12  * intact in the scripts and in the outputted HTML.
13  * The "powered by" text/logo with a link back to
14  * http://www.mvnForum.com and http://www.MyVietnam.net in
15  * the footer of the pages MUST remain visible when the pages
16  * are viewed on the internet or intranet.
17  *
18  * This program is free software; you can redistribute it and/or modify
19  * it under the terms of the GNU General Public License as published by
20  * the Free Software Foundation; either version 2 of the License, or
21  * any later version.
22  *
23  * This program is distributed in the hope that it will be useful,
24  * but WITHOUT ANY WARRANTY; without even the implied warranty of
25  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
26  * GNU General Public License for more details.
27  *
28  * You should have received a copy of the GNU General Public License
29  * along with this program; if not, write to the Free Software
30  * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
31  *
32  * Support can be obtained from support forums at:
33  * http://www.mvnForum.com/mvnforum/index
34  *
35  * Correspondence and Marketing Questions can be sent to:
36  * info at MyVietnam net
37  *
38  * @author: Minh Nguyen
39  */
40 package com.mvnforum.db;
41
42 import java.sql.Timestamp JavaDoc;
43 import java.util.Collection JavaDoc;
44
45 import net.myvietnam.mvncore.exception.AssertionException;
46 import net.myvietnam.mvncore.exception.CreateException;
47 import net.myvietnam.mvncore.exception.DatabaseException;
48 import net.myvietnam.mvncore.exception.DuplicateKeyException;
49 import net.myvietnam.mvncore.exception.ObjectNotFoundException;
50 import net.myvietnam.mvncore.exception.ForeignKeyNotFoundException;
51
52 public interface MemberTutorDAO {
53
54     public static final String JavaDoc TABLE_NAME = DatabaseConfig.TABLE_PREFIX + "MemberTutor";
55
56     public void findByPrimaryKey(int memberID)
57         throws ObjectNotFoundException, DatabaseException;
58
59     public void findByAlternateKey_MemberName(String JavaDoc memberName)
60         throws ObjectNotFoundException, DatabaseException;
61
62     public void create(int memberID, String JavaDoc memberName, int tutorID,
63                        String JavaDoc tutorName, Timestamp JavaDoc creationDate, Timestamp JavaDoc expireDate,
64                        int relationType, int relationOption, int relationStatus)
65         throws CreateException, DatabaseException, DuplicateKeyException, ForeignKeyNotFoundException;
66
67     public void delete(int memberID)
68         throws DatabaseException, ObjectNotFoundException;
69
70     public void deleteMembers_inTutor(int tutorID)
71         throws DatabaseException, ObjectNotFoundException;
72
73     public MemberTutorBean getBean(int memberID)
74         throws ObjectNotFoundException, DatabaseException;
75
76     public Collection JavaDoc getBeans_inTutor_limit(int tutorID, int offset, int rowsToReturn)
77         throws IllegalArgumentException JavaDoc, DatabaseException;
78
79     public Collection JavaDoc getMembers_inTutor(int tutorID)
80         throws DatabaseException;
81
82     public int getNumberOfBeans_inTutor(int tutorID)
83         throws AssertionException, DatabaseException;
84
85     public int getNumberOfMembers()
86         throws AssertionException, DatabaseException;
87
88     public Collection JavaDoc getBeans(int offset, int rowsToReturn)
89         throws DatabaseException;
90
91     public Collection JavaDoc getBeans_inExpire_limit(Timestamp JavaDoc expireDate, int offset, int rowsToReturn)
92         throws IllegalArgumentException JavaDoc, DatabaseException;
93
94     public int getNumberOfBeans_inExpire(Timestamp JavaDoc expireDate)
95         throws AssertionException, DatabaseException;
96
97     // unused
98 public void updateMember_expireDate(int memberID, // primary key
99 Timestamp JavaDoc expireDate)
100         throws ObjectNotFoundException, DatabaseException;
101
102 }
103
Popular Tags