KickJava   Java API By Example, From Geeks To Geeks.

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


1 /*
2  * $Header: /cvsroot/mvnforum/mvnforum/src/com/mvnforum/db/AttachmentDAO.java,v 1.13 2006/04/14 17:05:26 minhnn Exp $
3  * $Author: minhnn $
4  * $Revision: 1.13 $
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.ObjectNotFoundException;
49 import net.myvietnam.mvncore.exception.ForeignKeyNotFoundException;
50
51 public interface AttachmentDAO {
52
53     public static final String JavaDoc TABLE_NAME = DatabaseConfig.TABLE_PREFIX + "Attachment";
54
55     public void create(int postID, int memberID, String JavaDoc attachFilename,
56                         int attachFileSize, String JavaDoc attachMimeType, String JavaDoc attachDesc,
57                         String JavaDoc attachCreationIP, Timestamp JavaDoc attachCreationDate, Timestamp JavaDoc attachModifiedDate,
58                         int attachDownloadCount, int attachOption, int attachStatus)
59         throws CreateException, DatabaseException, ForeignKeyNotFoundException;
60
61     public int createAttachment(int postID, int memberID, String JavaDoc attachFilename,
62                          int attachFileSize, String JavaDoc attachMimeType, String JavaDoc attachDesc,
63                          String JavaDoc attachCreationIP, Timestamp JavaDoc attachCreationDate, Timestamp JavaDoc attachModifiedDate,
64                          int attachDownloadCount, int attachOption, int attachStatus)
65         throws CreateException, DatabaseException, ForeignKeyNotFoundException, ObjectNotFoundException;
66
67     public void delete(int attachID)
68         throws DatabaseException, ObjectNotFoundException;
69
70     public AttachmentBean getAttachment(int attachID)
71         throws ObjectNotFoundException, DatabaseException;
72
73     // this method is not used now
74 public Collection JavaDoc getAttachments()
75         throws DatabaseException;
76
77     public int getNumberOfAttachments()
78         throws AssertionException, DatabaseException;
79
80     public int getNumberOfAttachments_inPost(int postID)
81         throws AssertionException, DatabaseException;
82
83     public int getNumberOfAttachments_inThread(int threadID)
84         throws AssertionException, DatabaseException;
85
86     public void delete_inPost(int postID)
87         throws DatabaseException;
88
89     public Collection JavaDoc getAttachments_inPost(int postID)
90         throws DatabaseException;
91
92     public Collection JavaDoc getAttachments_inThread(int threadID)
93         throws DatabaseException;
94
95     public Collection JavaDoc getAttachments_inForum(int forumID)
96         throws DatabaseException;
97
98     public void increaseDownloadCount(int attachID)
99         throws DatabaseException, ObjectNotFoundException;
100
101     public void updateAttachDesc(int attachID, String JavaDoc newDesc)
102         throws DatabaseException, ObjectNotFoundException;
103     
104     public void updateAttachOption(int attachID, int attachOption)
105         throws DatabaseException, ObjectNotFoundException;
106 }
107
Popular Tags