KickJava   Java API By Example, From Geeks To Geeks.

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


1 /*
2  * $Header: /cvsroot/mvnforum/mvnforum/src/com/mvnforum/db/WatchDAO.java,v 1.12 2006/04/14 17:05:26 minhnn Exp $
3  * $Author: minhnn $
4  * $Revision: 1.12 $
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 WatchDAO {
53
54     public static final String JavaDoc TABLE_NAME = DatabaseConfig.TABLE_PREFIX + "Watch";
55
56     public void findByPrimaryKey(int watchID)
57         throws ObjectNotFoundException, DatabaseException;
58
59     public void findByAlternateKey_MemberID_CategoryID_ForumID_ThreadID(int memberID, int categoryID, int forumID, int threadID)
60         throws ObjectNotFoundException, DatabaseException;
61
62     public void create(int memberID, int categoryID, int forumID,
63                        int threadID, int watchType, int watchOption,
64                        int watchStatus, Timestamp JavaDoc watchCreationDate, Timestamp JavaDoc watchLastSentDate,
65                        Timestamp JavaDoc watchEndDate)
66         throws IllegalArgumentException JavaDoc, CreateException, DatabaseException, DuplicateKeyException, ForeignKeyNotFoundException;
67
68     public void delete(int watchID)
69         throws DatabaseException, ObjectNotFoundException;
70
71     public void delete_inMember(int memberID)
72         throws DatabaseException;
73
74     public void delete_inCategory(int categoryID)
75         throws DatabaseException;
76
77     public void delete_inForum(int forumID)
78         throws DatabaseException;
79
80     public void delete_inThread(int threadID)
81         throws DatabaseException;
82
83     public void updateLastSentDate(int watchID, // primary key
84 Timestamp JavaDoc watchLastSentDate)
85         throws ObjectNotFoundException, DatabaseException;
86
87     public WatchBean getWatch(int watchID)
88         throws ObjectNotFoundException, DatabaseException;
89
90     // this method is not used anywhere, should we remove it ???
91 public WatchBean getWatch_byAlternateKey_MemberID_CategoryID_ForumID_ThreadID(int memberID, int categoryID, int forumID, int threadID)
92         throws ObjectNotFoundException, DatabaseException;
93
94     // this method is not used anywhere, should we remove it ???
95 public Collection JavaDoc getWatches()
96         throws DatabaseException;
97
98     // this method is not used anywhere, should we remove it ???
99 public int getNumberOfWatches()
100         throws AssertionException, DatabaseException;
101
102     public int getNumberOfWatches_forMember(int memberID)
103         throws AssertionException, DatabaseException;
104
105     // must only affect enable threads ???
106 public Collection JavaDoc getMemberBeans()
107         throws DatabaseException;
108
109     // must only affect enable threads ???
110 public Collection JavaDoc getWatches_forMember(int memberID)
111         throws DatabaseException;
112
113     // must only affect enable threads ???
114 public void updateLastSentDate_forMember(int memberID, Timestamp JavaDoc watchLastSentDate)
115         throws ObjectNotFoundException, DatabaseException;
116
117 }
118
Popular Tags