KickJava   Java API By Example, From Geeks To Geeks.

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


1 /*
2  * $Header: /cvsroot/mvnforum/mvnforum/src/com/mvnforum/db/MemberCompanyDAO.java,v 1.6 2006/04/14 17:05:26 minhnn Exp $
3  * $Author: minhnn $
4  * $Revision: 1.6 $
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 MemberCompanyDAO {
53
54     public static final String JavaDoc TABLE_NAME = DatabaseConfig.TABLE_PREFIX + "MemberCompany";
55
56     public void findByPrimaryKey(int memberID)
57         throws ObjectNotFoundException, DatabaseException;
58
59     public void create(int memberID, String JavaDoc memberName, int companyID,
60                        Timestamp JavaDoc creationDate, Timestamp JavaDoc expireDate, int isActive,
61                        int relationType, int relationOption, int relationStatus)
62         throws CreateException, DatabaseException, DuplicateKeyException, ForeignKeyNotFoundException;
63
64     public void delete(int memberID, int companyID)
65         throws DatabaseException, ObjectNotFoundException;
66
67     public void delete_inMember(int memberID)
68         throws DatabaseException;
69
70     public void delete_inCompany(int companyID)
71         throws DatabaseException;
72
73     public int getCompanyIDFromMemberID(int memberID)
74         throws ObjectNotFoundException, DatabaseException;
75
76     public Collection JavaDoc getBeans_inCompany_limit(int companyID, int offset, int rowsToReturn)
77         throws IllegalArgumentException JavaDoc, DatabaseException;
78
79     public int getNumberOfBeans_inCompany(int companyID)
80         throws AssertionException, DatabaseException;
81
82 }
83
Popular Tags