KickJava   Java API By Example, From Geeks To Geeks.

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


1 /*
2  * $Header: /cvsroot/mvnforum/mvnforum/src/com/mvnforum/db/CategoryDAO.java,v 1.7 2006/04/14 17:05:26 minhnn Exp $
3  * $Author: minhnn $
4  * $Revision: 1.7 $
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.DuplicateKeyException;
48 import net.myvietnam.mvncore.exception.ObjectNotFoundException;
49 import net.myvietnam.mvncore.exception.ForeignKeyNotFoundException;
50
51 public interface CategoryDAO {
52
53     public static final String JavaDoc TABLE_NAME = DatabaseConfig.TABLE_PREFIX + "Category";
54
55     public void findByPrimaryKey(int categoryID)
56         throws ObjectNotFoundException, DatabaseException;
57
58     public void findByAlternateKey_CategoryName(String JavaDoc categoryName)
59         throws ObjectNotFoundException, DatabaseException;
60
61     public void create(int parentCategoryID, String JavaDoc categoryName, String JavaDoc categoryDesc,
62                         Timestamp JavaDoc categoryCreationDate, Timestamp JavaDoc categoryModifiedDate, int categoryOrder,
63                         int categoryOption, int categoryStatus)
64         throws CreateException, DatabaseException, DuplicateKeyException, ForeignKeyNotFoundException;
65
66     public void delete(int categoryID)
67         throws DatabaseException, ObjectNotFoundException;
68
69     public void update(int categoryID, // primary key
70 String JavaDoc categoryName, String JavaDoc categoryDesc, Timestamp JavaDoc categoryModifiedDate,
71                        int categoryOrder, int categoryOption, int categoryStatus)
72         throws ObjectNotFoundException, DatabaseException, DuplicateKeyException;
73
74     public CategoryBean getCategory(int categoryID)
75         throws ObjectNotFoundException, DatabaseException;
76
77     public Collection JavaDoc getCategories()
78         throws DatabaseException;
79
80     public void decreaseCategoryOrder(int categoryID, Timestamp JavaDoc categoryModifiedDate)
81         throws DatabaseException, ObjectNotFoundException;
82
83     public void increaseCategoryOrder(int categoryID, Timestamp JavaDoc categoryModifiedDate)
84         throws DatabaseException, ObjectNotFoundException;
85
86 }
87
Popular Tags