KickJava   Java API By Example, From Geeks To Geeks.

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


1 /*
2  * $Header: /cvsroot/mvnforum/mvnforum/src/com/mvnforum/db/PmAttachmentDAO.java,v 1.11 2006/04/14 17:05:26 minhnn Exp $
3  * $Author: minhnn $
4  * $Revision: 1.11 $
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.CreateException;
46 import net.myvietnam.mvncore.exception.DatabaseException;
47 import net.myvietnam.mvncore.exception.ObjectNotFoundException;
48 import net.myvietnam.mvncore.exception.ForeignKeyNotFoundException;
49
50 public interface PmAttachmentDAO {
51
52     public static final String JavaDoc TABLE_NAME = DatabaseConfig.TABLE_PREFIX + "PmAttachment";
53
54     public void findByPrimaryKey(int pmAttachID)
55         throws ObjectNotFoundException, DatabaseException;
56
57     public int create(int memberID, String JavaDoc pmAttachFilename, int pmAttachFileSize,
58                       String JavaDoc pmAttachMimeType, String JavaDoc pmAttachDesc, String JavaDoc pmAttachCreationIP,
59                       Timestamp JavaDoc pmAttachCreationDate, Timestamp JavaDoc pmAttachModifiedDate, int pmAttachDownloadCount,
60                       int pmAttachOption, int pmAttachStatus)
61         throws CreateException, DatabaseException, ForeignKeyNotFoundException, ObjectNotFoundException;
62
63     public void delete(int pmAttachID)
64         throws DatabaseException, ObjectNotFoundException;
65
66     public PmAttachmentBean getPmAttachment(int pmAttachID)
67         throws ObjectNotFoundException, DatabaseException;
68
69     public void increaseDownloadCount(int pmAttachID)
70         throws DatabaseException, ObjectNotFoundException;
71
72      public Collection JavaDoc getPmAttachments_inMessage(int messageID)
73         throws DatabaseException;
74
75     // Note: this method using LEFT JOIN
76 public Collection JavaDoc getOrphanPmAttachments()
77         throws DatabaseException;
78     
79     public void updatePmAttachOption(int pmAttachID, int pmAttachOption)
80         throws DatabaseException, ObjectNotFoundException;
81 }
82
Popular Tags