KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > org > contineo > admin > dao > MenuGroupDAO


1 /*
2  * MenGroupDAO.java
3  *
4  * Created on 26. August 2003, 15:15
5  */
6
7 package org.contineo.admin.dao;
8
9 import java.util.Collection JavaDoc;
10 import org.apache.log4j.Level;
11 import org.apache.log4j.Logger;
12 import org.apache.ojb.broker.PBKey;
13 import org.apache.ojb.broker.PersistenceBroker;
14 import org.apache.ojb.broker.PersistenceBrokerFactory;
15 import org.apache.ojb.broker.query.Criteria;
16 import org.apache.ojb.broker.query.Query;
17 import org.apache.ojb.broker.query.QueryByCriteria;
18 import org.contineo.admin.MenuGroup;
19 import org.contineo.core.LoggingManager;
20 /**
21  * This class is a DAO-service for menugroups.
22  * @author Michael Scholz
23  * @version 1.0
24  */
25 public class MenuGroupDAO {
26
27     /**
28      * @uml.property name="broker"
29      * @uml.associationEnd
30      */
31     private PersistenceBroker broker = null;
32
33     /**
34      * @uml.property name="pbkey"
35      * @uml.associationEnd
36      */
37     private PBKey pbkey;
38
39     /**
40      * @uml.property name="logger"
41      * @uml.associationEnd
42      */
43     private Logger logger;
44
45     
46     /** Creates a new instance of MenGroupDAO */
47     public MenuGroupDAO() {
48         logger = LoggingManager.getLogger(this.getClass());
49         pbkey = new PBKey("contineo");
50     }
51     
52     /** This method persists a menugroup object.
53      * @param menugroup MenuGroup which should be stored in a database.
54      * @return True if successful stored in a database.
55      */
56     public boolean store(MenuGroup menugroup) {
57         boolean result = true;
58         try {
59             broker = PersistenceBrokerFactory.createPersistenceBroker(pbkey);
60             broker.beginTransaction();
61             broker.store(menugroup);
62             broker.commitTransaction();
63         }
64         catch (Exception JavaDoc e) {
65             broker.abortTransaction();
66             if (logger.isEnabledFor(Level.ERROR))
67                 logger.error(e.getMessage());
68             result = false;
69         } finally {
70             if (broker != null) broker.close();
71         }
72         return result;
73     }
74     
75     /**
76      * This method deletes a menugroup specified by menuid and groupname.
77      */
78     public boolean delete(int menuid, String JavaDoc groupname) {
79         boolean result = true;
80         try {
81             broker = PersistenceBrokerFactory.createPersistenceBroker(pbkey);
82             Criteria crit = new Criteria();
83             crit.addEqualTo("co_menuid", new Integer JavaDoc(menuid));
84             crit.addEqualTo("co_groupname", groupname);
85             Query mgquery = new QueryByCriteria(org.contineo.admin.MenuGroup.class, crit);
86             broker.beginTransaction();
87             broker.deleteByQuery(mgquery);
88             broker.commitTransaction();
89         }
90         catch (Exception JavaDoc e) {
91             broker.abortTransaction();
92             if (logger.isEnabledFor(Level.ERROR))
93                 logger.error(e.getMessage());
94             result = false;
95         } finally {
96             if (broker != null) broker.close();
97         }
98         return result;
99     }
100     
101     /**
102      * This method finds all specified menugroups.
103      * @param groupname Groupname of menugroups.
104      * @return Collection of selected menugroups.
105      */
106     public Collection JavaDoc findByGroupName(String JavaDoc groupname) {
107         Collection JavaDoc coll = null;
108         try {
109             broker = PersistenceBrokerFactory.createPersistenceBroker(pbkey);
110             Criteria crit = new Criteria();
111             crit.addEqualTo("co_groupname", groupname);
112             Query query = new QueryByCriteria(org.contineo.admin.MenuGroup.class,crit);
113             coll = broker.getCollectionByQuery(query);
114         }
115         catch (Exception JavaDoc e) {
116             if (logger.isEnabledFor(Level.ERROR))
117                 logger.error(e.getMessage());
118         } finally {
119             if (broker != null) broker.close();
120         }
121         return coll;
122     }
123     
124     /**
125      * This method finds all specified menugroups.
126      * @param menuid MenuId of menugroups.
127      * @return Collection of selected menugroups.
128      */
129     public Collection JavaDoc findByMenuId(int menuid) {
130         Collection JavaDoc coll = null;
131         try {
132             broker = PersistenceBrokerFactory.createPersistenceBroker(pbkey);
133             Criteria crit = new Criteria();
134             crit.addEqualTo("co_menuid", new Integer JavaDoc(menuid));
135             Query query = new QueryByCriteria(org.contineo.admin.MenuGroup.class,crit);
136             coll = broker.getCollectionByQuery(query);
137         }
138         catch (Exception JavaDoc e) {
139             if (logger.isEnabledFor(Level.ERROR))
140                 logger.error(e.getMessage());
141         } finally {
142             if (broker != null) broker.close();
143         }
144         return coll;
145     }
146     
147     /**
148      * This method finds a specified menugroups.
149      * @param menuid MenuId of the menugroup.
150      * @param groupname GroupName of the menugroup.
151      */
152     public MenuGroup findByMenuIdGroupName(int menuid,String JavaDoc groupname) {
153         MenuGroup mg = new MenuGroup();
154         try {
155             broker = PersistenceBrokerFactory.createPersistenceBroker(pbkey);
156             Criteria crit = new Criteria();
157             crit.addEqualTo("co_menuid", new Integer JavaDoc(menuid));
158             crit.addEqualTo("co_groupname", groupname);
159             Query query = new QueryByCriteria(org.contineo.admin.MenuGroup.class,crit);
160             mg = (MenuGroup)broker.getObjectByQuery(query);
161         }
162         catch (Exception JavaDoc e) {
163             if (logger.isEnabledFor(Level.ERROR))
164                 logger.error(e.getMessage());
165         } finally {
166             if (broker != null) broker.close();
167         }
168         return mg;
169     }
170 }
171
Popular Tags