KickJava   Java API By Example, From Geeks To Geeks.

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


1 /*
2  * $Header: /cvsroot/mvnforum/mvnforum/src/com/mvnforum/db/GroupsDAO.java,v 1.16 2006/04/14 17:05:26 minhnn Exp $
3  * $Author: minhnn $
4  * $Revision: 1.16 $
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 GroupsDAO {
53
54     public static final String JavaDoc TABLE_NAME = DatabaseConfig.TABLE_PREFIX + "Groups";
55
56     public static final String JavaDoc TUTOR_GROUP_NAME = "Tutor"; // it's hardcode
57
58     public void findByPrimaryKey(int groupID)
59         throws ObjectNotFoundException, DatabaseException;
60
61     public void findByAlternateKey_GroupName(String JavaDoc groupName)
62         throws ObjectNotFoundException, DatabaseException;
63
64     public void create(String JavaDoc groupOwnerName, String JavaDoc groupName,
65                        String JavaDoc groupDesc, int groupOption, Timestamp JavaDoc groupCreationDate,
66                        Timestamp JavaDoc groupModifiedDate)
67         throws CreateException, DatabaseException, DuplicateKeyException, ForeignKeyNotFoundException;
68
69     public void delete(int groupID)
70         throws DatabaseException, ObjectNotFoundException;
71
72     public void update(int groupID, // primary key
73 String JavaDoc groupName, String JavaDoc groupDesc, Timestamp JavaDoc groupModifiedDate)
74         throws ObjectNotFoundException, DatabaseException, DuplicateKeyException;
75
76     public void updateOwner(int groupID, // primary key
77 String JavaDoc groupOwnerName, Timestamp JavaDoc groupModifiedDate)
78         throws ObjectNotFoundException, DatabaseException, ForeignKeyNotFoundException;
79
80     public GroupsBean getGroup(int groupID)
81         throws ObjectNotFoundException, DatabaseException;
82
83     public Collection JavaDoc getMyGroups(int memberID)
84         throws DatabaseException;
85
86     public Collection JavaDoc getGroups()
87         throws DatabaseException;
88
89     // Note that this method is not used anywhere
90 public int getNumberOfGroups()
91         throws AssertionException, DatabaseException;
92
93     public int getGroupIDFromGroupName(String JavaDoc groupName)
94         throws ObjectNotFoundException, DatabaseException;
95
96 }
97
Popular Tags