1   /**
2    * Copyright (c) 2000-2010 Liferay, Inc. All rights reserved.
3    *
4    * The contents of this file are subject to the terms of the Liferay Enterprise
5    * Subscription License ("License"). You may not use this file except in
6    * compliance with the License. You can obtain a copy of the License by
7    * contacting Liferay, Inc. See the License for the specific language governing
8    * permissions and limitations under the License, including but not limited to
9    * distribution rights of the Software.
10   *
11   *
12   * 
13   */
14  
15  package com.liferay.portlet.messageboards.service.persistence;
16  
17  import com.liferay.portal.NoSuchModelException;
18  import com.liferay.portal.SystemException;
19  import com.liferay.portal.kernel.annotation.BeanReference;
20  import com.liferay.portal.kernel.cache.CacheRegistry;
21  import com.liferay.portal.kernel.dao.orm.DynamicQuery;
22  import com.liferay.portal.kernel.dao.orm.EntityCacheUtil;
23  import com.liferay.portal.kernel.dao.orm.FinderCacheUtil;
24  import com.liferay.portal.kernel.dao.orm.FinderPath;
25  import com.liferay.portal.kernel.dao.orm.Query;
26  import com.liferay.portal.kernel.dao.orm.QueryPos;
27  import com.liferay.portal.kernel.dao.orm.QueryUtil;
28  import com.liferay.portal.kernel.dao.orm.Session;
29  import com.liferay.portal.kernel.log.Log;
30  import com.liferay.portal.kernel.log.LogFactoryUtil;
31  import com.liferay.portal.kernel.util.GetterUtil;
32  import com.liferay.portal.kernel.util.OrderByComparator;
33  import com.liferay.portal.kernel.util.StringBundler;
34  import com.liferay.portal.kernel.util.StringPool;
35  import com.liferay.portal.kernel.util.StringUtil;
36  import com.liferay.portal.model.ModelListener;
37  import com.liferay.portal.service.persistence.BatchSessionUtil;
38  import com.liferay.portal.service.persistence.impl.BasePersistenceImpl;
39  
40  import com.liferay.portlet.messageboards.NoSuchBanException;
41  import com.liferay.portlet.messageboards.model.MBBan;
42  import com.liferay.portlet.messageboards.model.impl.MBBanImpl;
43  import com.liferay.portlet.messageboards.model.impl.MBBanModelImpl;
44  
45  import java.io.Serializable;
46  
47  import java.util.ArrayList;
48  import java.util.Collections;
49  import java.util.List;
50  
51  /**
52   * <a href="MBBanPersistenceImpl.java.html"><b><i>View Source</i></b></a>
53   *
54   * <p>
55   * ServiceBuilder generated this class. Modifications in this class will be
56   * overwritten the next time is generated.
57   * </p>
58   *
59   * @author    Brian Wing Shun Chan
60   * @see       MBBanPersistence
61   * @see       MBBanUtil
62   * @generated
63   */
64  public class MBBanPersistenceImpl extends BasePersistenceImpl<MBBan>
65      implements MBBanPersistence {
66      public static final String FINDER_CLASS_NAME_ENTITY = MBBanImpl.class.getName();
67      public static final String FINDER_CLASS_NAME_LIST = FINDER_CLASS_NAME_ENTITY +
68          ".List";
69      public static final FinderPath FINDER_PATH_FIND_BY_GROUPID = new FinderPath(MBBanModelImpl.ENTITY_CACHE_ENABLED,
70              MBBanModelImpl.FINDER_CACHE_ENABLED, FINDER_CLASS_NAME_LIST,
71              "findByGroupId", new String[] { Long.class.getName() });
72      public static final FinderPath FINDER_PATH_FIND_BY_OBC_GROUPID = new FinderPath(MBBanModelImpl.ENTITY_CACHE_ENABLED,
73              MBBanModelImpl.FINDER_CACHE_ENABLED, FINDER_CLASS_NAME_LIST,
74              "findByGroupId",
75              new String[] {
76                  Long.class.getName(),
77                  
78              "java.lang.Integer", "java.lang.Integer",
79                  "com.liferay.portal.kernel.util.OrderByComparator"
80              });
81      public static final FinderPath FINDER_PATH_COUNT_BY_GROUPID = new FinderPath(MBBanModelImpl.ENTITY_CACHE_ENABLED,
82              MBBanModelImpl.FINDER_CACHE_ENABLED, FINDER_CLASS_NAME_LIST,
83              "countByGroupId", new String[] { Long.class.getName() });
84      public static final FinderPath FINDER_PATH_FIND_BY_USERID = new FinderPath(MBBanModelImpl.ENTITY_CACHE_ENABLED,
85              MBBanModelImpl.FINDER_CACHE_ENABLED, FINDER_CLASS_NAME_LIST,
86              "findByUserId", new String[] { Long.class.getName() });
87      public static final FinderPath FINDER_PATH_FIND_BY_OBC_USERID = new FinderPath(MBBanModelImpl.ENTITY_CACHE_ENABLED,
88              MBBanModelImpl.FINDER_CACHE_ENABLED, FINDER_CLASS_NAME_LIST,
89              "findByUserId",
90              new String[] {
91                  Long.class.getName(),
92                  
93              "java.lang.Integer", "java.lang.Integer",
94                  "com.liferay.portal.kernel.util.OrderByComparator"
95              });
96      public static final FinderPath FINDER_PATH_COUNT_BY_USERID = new FinderPath(MBBanModelImpl.ENTITY_CACHE_ENABLED,
97              MBBanModelImpl.FINDER_CACHE_ENABLED, FINDER_CLASS_NAME_LIST,
98              "countByUserId", new String[] { Long.class.getName() });
99      public static final FinderPath FINDER_PATH_FIND_BY_BANUSERID = new FinderPath(MBBanModelImpl.ENTITY_CACHE_ENABLED,
100             MBBanModelImpl.FINDER_CACHE_ENABLED, FINDER_CLASS_NAME_LIST,
101             "findByBanUserId", new String[] { Long.class.getName() });
102     public static final FinderPath FINDER_PATH_FIND_BY_OBC_BANUSERID = new FinderPath(MBBanModelImpl.ENTITY_CACHE_ENABLED,
103             MBBanModelImpl.FINDER_CACHE_ENABLED, FINDER_CLASS_NAME_LIST,
104             "findByBanUserId",
105             new String[] {
106                 Long.class.getName(),
107                 
108             "java.lang.Integer", "java.lang.Integer",
109                 "com.liferay.portal.kernel.util.OrderByComparator"
110             });
111     public static final FinderPath FINDER_PATH_COUNT_BY_BANUSERID = new FinderPath(MBBanModelImpl.ENTITY_CACHE_ENABLED,
112             MBBanModelImpl.FINDER_CACHE_ENABLED, FINDER_CLASS_NAME_LIST,
113             "countByBanUserId", new String[] { Long.class.getName() });
114     public static final FinderPath FINDER_PATH_FETCH_BY_G_B = new FinderPath(MBBanModelImpl.ENTITY_CACHE_ENABLED,
115             MBBanModelImpl.FINDER_CACHE_ENABLED, FINDER_CLASS_NAME_ENTITY,
116             "fetchByG_B",
117             new String[] { Long.class.getName(), Long.class.getName() });
118     public static final FinderPath FINDER_PATH_COUNT_BY_G_B = new FinderPath(MBBanModelImpl.ENTITY_CACHE_ENABLED,
119             MBBanModelImpl.FINDER_CACHE_ENABLED, FINDER_CLASS_NAME_LIST,
120             "countByG_B",
121             new String[] { Long.class.getName(), Long.class.getName() });
122     public static final FinderPath FINDER_PATH_FIND_ALL = new FinderPath(MBBanModelImpl.ENTITY_CACHE_ENABLED,
123             MBBanModelImpl.FINDER_CACHE_ENABLED, FINDER_CLASS_NAME_LIST,
124             "findAll", new String[0]);
125     public static final FinderPath FINDER_PATH_COUNT_ALL = new FinderPath(MBBanModelImpl.ENTITY_CACHE_ENABLED,
126             MBBanModelImpl.FINDER_CACHE_ENABLED, FINDER_CLASS_NAME_LIST,
127             "countAll", new String[0]);
128 
129     public void cacheResult(MBBan mbBan) {
130         EntityCacheUtil.putResult(MBBanModelImpl.ENTITY_CACHE_ENABLED,
131             MBBanImpl.class, mbBan.getPrimaryKey(), mbBan);
132 
133         FinderCacheUtil.putResult(FINDER_PATH_FETCH_BY_G_B,
134             new Object[] {
135                 new Long(mbBan.getGroupId()), new Long(mbBan.getBanUserId())
136             }, mbBan);
137     }
138 
139     public void cacheResult(List<MBBan> mbBans) {
140         for (MBBan mbBan : mbBans) {
141             if (EntityCacheUtil.getResult(MBBanModelImpl.ENTITY_CACHE_ENABLED,
142                         MBBanImpl.class, mbBan.getPrimaryKey(), this) == null) {
143                 cacheResult(mbBan);
144             }
145         }
146     }
147 
148     public void clearCache() {
149         CacheRegistry.clear(MBBanImpl.class.getName());
150         EntityCacheUtil.clearCache(MBBanImpl.class.getName());
151         FinderCacheUtil.clearCache(FINDER_CLASS_NAME_ENTITY);
152         FinderCacheUtil.clearCache(FINDER_CLASS_NAME_LIST);
153     }
154 
155     public MBBan create(long banId) {
156         MBBan mbBan = new MBBanImpl();
157 
158         mbBan.setNew(true);
159         mbBan.setPrimaryKey(banId);
160 
161         return mbBan;
162     }
163 
164     public MBBan remove(Serializable primaryKey)
165         throws NoSuchModelException, SystemException {
166         return remove(((Long)primaryKey).longValue());
167     }
168 
169     public MBBan remove(long banId) throws NoSuchBanException, SystemException {
170         Session session = null;
171 
172         try {
173             session = openSession();
174 
175             MBBan mbBan = (MBBan)session.get(MBBanImpl.class, new Long(banId));
176 
177             if (mbBan == null) {
178                 if (_log.isWarnEnabled()) {
179                     _log.warn(_NO_SUCH_ENTITY_WITH_PRIMARY_KEY + banId);
180                 }
181 
182                 throw new NoSuchBanException(_NO_SUCH_ENTITY_WITH_PRIMARY_KEY +
183                     banId);
184             }
185 
186             return remove(mbBan);
187         }
188         catch (NoSuchBanException nsee) {
189             throw nsee;
190         }
191         catch (Exception e) {
192             throw processException(e);
193         }
194         finally {
195             closeSession(session);
196         }
197     }
198 
199     public MBBan remove(MBBan mbBan) throws SystemException {
200         for (ModelListener<MBBan> listener : listeners) {
201             listener.onBeforeRemove(mbBan);
202         }
203 
204         mbBan = removeImpl(mbBan);
205 
206         for (ModelListener<MBBan> listener : listeners) {
207             listener.onAfterRemove(mbBan);
208         }
209 
210         return mbBan;
211     }
212 
213     protected MBBan removeImpl(MBBan mbBan) throws SystemException {
214         mbBan = toUnwrappedModel(mbBan);
215 
216         Session session = null;
217 
218         try {
219             session = openSession();
220 
221             if (mbBan.isCachedModel() || BatchSessionUtil.isEnabled()) {
222                 Object staleObject = session.get(MBBanImpl.class,
223                         mbBan.getPrimaryKeyObj());
224 
225                 if (staleObject != null) {
226                     session.evict(staleObject);
227                 }
228             }
229 
230             session.delete(mbBan);
231 
232             session.flush();
233         }
234         catch (Exception e) {
235             throw processException(e);
236         }
237         finally {
238             closeSession(session);
239         }
240 
241         FinderCacheUtil.clearCache(FINDER_CLASS_NAME_LIST);
242 
243         MBBanModelImpl mbBanModelImpl = (MBBanModelImpl)mbBan;
244 
245         FinderCacheUtil.removeResult(FINDER_PATH_FETCH_BY_G_B,
246             new Object[] {
247                 new Long(mbBanModelImpl.getOriginalGroupId()),
248                 new Long(mbBanModelImpl.getOriginalBanUserId())
249             });
250 
251         EntityCacheUtil.removeResult(MBBanModelImpl.ENTITY_CACHE_ENABLED,
252             MBBanImpl.class, mbBan.getPrimaryKey());
253 
254         return mbBan;
255     }
256 
257     /**
258      * @deprecated Use {@link BasePersistence#update(com.liferay.portal.model.BaseModel, boolean)}.
259      */
260     public MBBan update(MBBan mbBan) throws SystemException {
261         if (_log.isWarnEnabled()) {
262             _log.warn(
263                 "Using the deprecated update(MBBan mbBan) method. Use update(MBBan mbBan, boolean merge) instead.");
264         }
265 
266         return update(mbBan, false);
267     }
268 
269     public MBBan updateImpl(
270         com.liferay.portlet.messageboards.model.MBBan mbBan, boolean merge)
271         throws SystemException {
272         mbBan = toUnwrappedModel(mbBan);
273 
274         boolean isNew = mbBan.isNew();
275 
276         MBBanModelImpl mbBanModelImpl = (MBBanModelImpl)mbBan;
277 
278         Session session = null;
279 
280         try {
281             session = openSession();
282 
283             BatchSessionUtil.update(session, mbBan, merge);
284 
285             mbBan.setNew(false);
286         }
287         catch (Exception e) {
288             throw processException(e);
289         }
290         finally {
291             closeSession(session);
292         }
293 
294         FinderCacheUtil.clearCache(FINDER_CLASS_NAME_LIST);
295 
296         EntityCacheUtil.putResult(MBBanModelImpl.ENTITY_CACHE_ENABLED,
297             MBBanImpl.class, mbBan.getPrimaryKey(), mbBan);
298 
299         if (!isNew &&
300                 ((mbBan.getGroupId() != mbBanModelImpl.getOriginalGroupId()) ||
301                 (mbBan.getBanUserId() != mbBanModelImpl.getOriginalBanUserId()))) {
302             FinderCacheUtil.removeResult(FINDER_PATH_FETCH_BY_G_B,
303                 new Object[] {
304                     new Long(mbBanModelImpl.getOriginalGroupId()),
305                     new Long(mbBanModelImpl.getOriginalBanUserId())
306                 });
307         }
308 
309         if (isNew ||
310                 ((mbBan.getGroupId() != mbBanModelImpl.getOriginalGroupId()) ||
311                 (mbBan.getBanUserId() != mbBanModelImpl.getOriginalBanUserId()))) {
312             FinderCacheUtil.putResult(FINDER_PATH_FETCH_BY_G_B,
313                 new Object[] {
314                     new Long(mbBan.getGroupId()), new Long(mbBan.getBanUserId())
315                 }, mbBan);
316         }
317 
318         return mbBan;
319     }
320 
321     protected MBBan toUnwrappedModel(MBBan mbBan) {
322         if (mbBan instanceof MBBanImpl) {
323             return mbBan;
324         }
325 
326         MBBanImpl mbBanImpl = new MBBanImpl();
327 
328         mbBanImpl.setNew(mbBan.isNew());
329         mbBanImpl.setPrimaryKey(mbBan.getPrimaryKey());
330 
331         mbBanImpl.setBanId(mbBan.getBanId());
332         mbBanImpl.setGroupId(mbBan.getGroupId());
333         mbBanImpl.setCompanyId(mbBan.getCompanyId());
334         mbBanImpl.setUserId(mbBan.getUserId());
335         mbBanImpl.setUserName(mbBan.getUserName());
336         mbBanImpl.setCreateDate(mbBan.getCreateDate());
337         mbBanImpl.setModifiedDate(mbBan.getModifiedDate());
338         mbBanImpl.setBanUserId(mbBan.getBanUserId());
339 
340         return mbBanImpl;
341     }
342 
343     public MBBan findByPrimaryKey(Serializable primaryKey)
344         throws NoSuchModelException, SystemException {
345         return findByPrimaryKey(((Long)primaryKey).longValue());
346     }
347 
348     public MBBan findByPrimaryKey(long banId)
349         throws NoSuchBanException, SystemException {
350         MBBan mbBan = fetchByPrimaryKey(banId);
351 
352         if (mbBan == null) {
353             if (_log.isWarnEnabled()) {
354                 _log.warn(_NO_SUCH_ENTITY_WITH_PRIMARY_KEY + banId);
355             }
356 
357             throw new NoSuchBanException(_NO_SUCH_ENTITY_WITH_PRIMARY_KEY +
358                 banId);
359         }
360 
361         return mbBan;
362     }
363 
364     public MBBan fetchByPrimaryKey(Serializable primaryKey)
365         throws SystemException {
366         return fetchByPrimaryKey(((Long)primaryKey).longValue());
367     }
368 
369     public MBBan fetchByPrimaryKey(long banId) throws SystemException {
370         MBBan mbBan = (MBBan)EntityCacheUtil.getResult(MBBanModelImpl.ENTITY_CACHE_ENABLED,
371                 MBBanImpl.class, banId, this);
372 
373         if (mbBan == null) {
374             Session session = null;
375 
376             try {
377                 session = openSession();
378 
379                 mbBan = (MBBan)session.get(MBBanImpl.class, new Long(banId));
380             }
381             catch (Exception e) {
382                 throw processException(e);
383             }
384             finally {
385                 if (mbBan != null) {
386                     cacheResult(mbBan);
387                 }
388 
389                 closeSession(session);
390             }
391         }
392 
393         return mbBan;
394     }
395 
396     public List<MBBan> findByGroupId(long groupId) throws SystemException {
397         Object[] finderArgs = new Object[] { new Long(groupId) };
398 
399         List<MBBan> list = (List<MBBan>)FinderCacheUtil.getResult(FINDER_PATH_FIND_BY_GROUPID,
400                 finderArgs, this);
401 
402         if (list == null) {
403             Session session = null;
404 
405             try {
406                 session = openSession();
407 
408                 StringBundler query = new StringBundler(2);
409 
410                 query.append(_SQL_SELECT_MBBAN_WHERE);
411 
412                 query.append(_FINDER_COLUMN_GROUPID_GROUPID_2);
413 
414                 String sql = query.toString();
415 
416                 Query q = session.createQuery(sql);
417 
418                 QueryPos qPos = QueryPos.getInstance(q);
419 
420                 qPos.add(groupId);
421 
422                 list = q.list();
423             }
424             catch (Exception e) {
425                 throw processException(e);
426             }
427             finally {
428                 if (list == null) {
429                     list = new ArrayList<MBBan>();
430                 }
431 
432                 cacheResult(list);
433 
434                 FinderCacheUtil.putResult(FINDER_PATH_FIND_BY_GROUPID,
435                     finderArgs, list);
436 
437                 closeSession(session);
438             }
439         }
440 
441         return list;
442     }
443 
444     public List<MBBan> findByGroupId(long groupId, int start, int end)
445         throws SystemException {
446         return findByGroupId(groupId, start, end, null);
447     }
448 
449     public List<MBBan> findByGroupId(long groupId, int start, int end,
450         OrderByComparator obc) throws SystemException {
451         Object[] finderArgs = new Object[] {
452                 new Long(groupId),
453                 
454                 String.valueOf(start), String.valueOf(end), String.valueOf(obc)
455             };
456 
457         List<MBBan> list = (List<MBBan>)FinderCacheUtil.getResult(FINDER_PATH_FIND_BY_OBC_GROUPID,
458                 finderArgs, this);
459 
460         if (list == null) {
461             Session session = null;
462 
463             try {
464                 session = openSession();
465 
466                 StringBundler query = null;
467 
468                 if (obc != null) {
469                     query = new StringBundler(3 +
470                             (obc.getOrderByFields().length * 3));
471                 }
472                 else {
473                     query = new StringBundler(2);
474                 }
475 
476                 query.append(_SQL_SELECT_MBBAN_WHERE);
477 
478                 query.append(_FINDER_COLUMN_GROUPID_GROUPID_2);
479 
480                 if (obc != null) {
481                     appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS, obc);
482                 }
483 
484                 String sql = query.toString();
485 
486                 Query q = session.createQuery(sql);
487 
488                 QueryPos qPos = QueryPos.getInstance(q);
489 
490                 qPos.add(groupId);
491 
492                 list = (List<MBBan>)QueryUtil.list(q, getDialect(), start, end);
493             }
494             catch (Exception e) {
495                 throw processException(e);
496             }
497             finally {
498                 if (list == null) {
499                     list = new ArrayList<MBBan>();
500                 }
501 
502                 cacheResult(list);
503 
504                 FinderCacheUtil.putResult(FINDER_PATH_FIND_BY_OBC_GROUPID,
505                     finderArgs, list);
506 
507                 closeSession(session);
508             }
509         }
510 
511         return list;
512     }
513 
514     public MBBan findByGroupId_First(long groupId, OrderByComparator obc)
515         throws NoSuchBanException, SystemException {
516         List<MBBan> list = findByGroupId(groupId, 0, 1, obc);
517 
518         if (list.isEmpty()) {
519             StringBundler msg = new StringBundler(4);
520 
521             msg.append(_NO_SUCH_ENTITY_WITH_KEY);
522 
523             msg.append("groupId=");
524             msg.append(groupId);
525 
526             msg.append(StringPool.CLOSE_CURLY_BRACE);
527 
528             throw new NoSuchBanException(msg.toString());
529         }
530         else {
531             return list.get(0);
532         }
533     }
534 
535     public MBBan findByGroupId_Last(long groupId, OrderByComparator obc)
536         throws NoSuchBanException, SystemException {
537         int count = countByGroupId(groupId);
538 
539         List<MBBan> list = findByGroupId(groupId, count - 1, count, obc);
540 
541         if (list.isEmpty()) {
542             StringBundler msg = new StringBundler(4);
543 
544             msg.append(_NO_SUCH_ENTITY_WITH_KEY);
545 
546             msg.append("groupId=");
547             msg.append(groupId);
548 
549             msg.append(StringPool.CLOSE_CURLY_BRACE);
550 
551             throw new NoSuchBanException(msg.toString());
552         }
553         else {
554             return list.get(0);
555         }
556     }
557 
558     public MBBan[] findByGroupId_PrevAndNext(long banId, long groupId,
559         OrderByComparator obc) throws NoSuchBanException, SystemException {
560         MBBan mbBan = findByPrimaryKey(banId);
561 
562         int count = countByGroupId(groupId);
563 
564         Session session = null;
565 
566         try {
567             session = openSession();
568 
569             StringBundler query = null;
570 
571             if (obc != null) {
572                 query = new StringBundler(3 +
573                         (obc.getOrderByFields().length * 3));
574             }
575             else {
576                 query = new StringBundler(2);
577             }
578 
579             query.append(_SQL_SELECT_MBBAN_WHERE);
580 
581             query.append(_FINDER_COLUMN_GROUPID_GROUPID_2);
582 
583             if (obc != null) {
584                 appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS, obc);
585             }
586 
587             String sql = query.toString();
588 
589             Query q = session.createQuery(sql);
590 
591             QueryPos qPos = QueryPos.getInstance(q);
592 
593             qPos.add(groupId);
594 
595             Object[] objArray = QueryUtil.getPrevAndNext(q, count, obc, mbBan);
596 
597             MBBan[] array = new MBBanImpl[3];
598 
599             array[0] = (MBBan)objArray[0];
600             array[1] = (MBBan)objArray[1];
601             array[2] = (MBBan)objArray[2];
602 
603             return array;
604         }
605         catch (Exception e) {
606             throw processException(e);
607         }
608         finally {
609             closeSession(session);
610         }
611     }
612 
613     public List<MBBan> findByUserId(long userId) throws SystemException {
614         Object[] finderArgs = new Object[] { new Long(userId) };
615 
616         List<MBBan> list = (List<MBBan>)FinderCacheUtil.getResult(FINDER_PATH_FIND_BY_USERID,
617                 finderArgs, this);
618 
619         if (list == null) {
620             Session session = null;
621 
622             try {
623                 session = openSession();
624 
625                 StringBundler query = new StringBundler(2);
626 
627                 query.append(_SQL_SELECT_MBBAN_WHERE);
628 
629                 query.append(_FINDER_COLUMN_USERID_USERID_2);
630 
631                 String sql = query.toString();
632 
633                 Query q = session.createQuery(sql);
634 
635                 QueryPos qPos = QueryPos.getInstance(q);
636 
637                 qPos.add(userId);
638 
639                 list = q.list();
640             }
641             catch (Exception e) {
642                 throw processException(e);
643             }
644             finally {
645                 if (list == null) {
646                     list = new ArrayList<MBBan>();
647                 }
648 
649                 cacheResult(list);
650 
651                 FinderCacheUtil.putResult(FINDER_PATH_FIND_BY_USERID,
652                     finderArgs, list);
653 
654                 closeSession(session);
655             }
656         }
657 
658         return list;
659     }
660 
661     public List<MBBan> findByUserId(long userId, int start, int end)
662         throws SystemException {
663         return findByUserId(userId, start, end, null);
664     }
665 
666     public List<MBBan> findByUserId(long userId, int start, int end,
667         OrderByComparator obc) throws SystemException {
668         Object[] finderArgs = new Object[] {
669                 new Long(userId),
670                 
671                 String.valueOf(start), String.valueOf(end), String.valueOf(obc)
672             };
673 
674         List<MBBan> list = (List<MBBan>)FinderCacheUtil.getResult(FINDER_PATH_FIND_BY_OBC_USERID,
675                 finderArgs, this);
676 
677         if (list == null) {
678             Session session = null;
679 
680             try {
681                 session = openSession();
682 
683                 StringBundler query = null;
684 
685                 if (obc != null) {
686                     query = new StringBundler(3 +
687                             (obc.getOrderByFields().length * 3));
688                 }
689                 else {
690                     query = new StringBundler(2);
691                 }
692 
693                 query.append(_SQL_SELECT_MBBAN_WHERE);
694 
695                 query.append(_FINDER_COLUMN_USERID_USERID_2);
696 
697                 if (obc != null) {
698                     appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS, obc);
699                 }
700 
701                 String sql = query.toString();
702 
703                 Query q = session.createQuery(sql);
704 
705                 QueryPos qPos = QueryPos.getInstance(q);
706 
707                 qPos.add(userId);
708 
709                 list = (List<MBBan>)QueryUtil.list(q, getDialect(), start, end);
710             }
711             catch (Exception e) {
712                 throw processException(e);
713             }
714             finally {
715                 if (list == null) {
716                     list = new ArrayList<MBBan>();
717                 }
718 
719                 cacheResult(list);
720 
721                 FinderCacheUtil.putResult(FINDER_PATH_FIND_BY_OBC_USERID,
722                     finderArgs, list);
723 
724                 closeSession(session);
725             }
726         }
727 
728         return list;
729     }
730 
731     public MBBan findByUserId_First(long userId, OrderByComparator obc)
732         throws NoSuchBanException, SystemException {
733         List<MBBan> list = findByUserId(userId, 0, 1, obc);
734 
735         if (list.isEmpty()) {
736             StringBundler msg = new StringBundler(4);
737 
738             msg.append(_NO_SUCH_ENTITY_WITH_KEY);
739 
740             msg.append("userId=");
741             msg.append(userId);
742 
743             msg.append(StringPool.CLOSE_CURLY_BRACE);
744 
745             throw new NoSuchBanException(msg.toString());
746         }
747         else {
748             return list.get(0);
749         }
750     }
751 
752     public MBBan findByUserId_Last(long userId, OrderByComparator obc)
753         throws NoSuchBanException, SystemException {
754         int count = countByUserId(userId);
755 
756         List<MBBan> list = findByUserId(userId, count - 1, count, obc);
757 
758         if (list.isEmpty()) {
759             StringBundler msg = new StringBundler(4);
760 
761             msg.append(_NO_SUCH_ENTITY_WITH_KEY);
762 
763             msg.append("userId=");
764             msg.append(userId);
765 
766             msg.append(StringPool.CLOSE_CURLY_BRACE);
767 
768             throw new NoSuchBanException(msg.toString());
769         }
770         else {
771             return list.get(0);
772         }
773     }
774 
775     public MBBan[] findByUserId_PrevAndNext(long banId, long userId,
776         OrderByComparator obc) throws NoSuchBanException, SystemException {
777         MBBan mbBan = findByPrimaryKey(banId);
778 
779         int count = countByUserId(userId);
780 
781         Session session = null;
782 
783         try {
784             session = openSession();
785 
786             StringBundler query = null;
787 
788             if (obc != null) {
789                 query = new StringBundler(3 +
790                         (obc.getOrderByFields().length * 3));
791             }
792             else {
793                 query = new StringBundler(2);
794             }
795 
796             query.append(_SQL_SELECT_MBBAN_WHERE);
797 
798             query.append(_FINDER_COLUMN_USERID_USERID_2);
799 
800             if (obc != null) {
801                 appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS, obc);
802             }
803 
804             String sql = query.toString();
805 
806             Query q = session.createQuery(sql);
807 
808             QueryPos qPos = QueryPos.getInstance(q);
809 
810             qPos.add(userId);
811 
812             Object[] objArray = QueryUtil.getPrevAndNext(q, count, obc, mbBan);
813 
814             MBBan[] array = new MBBanImpl[3];
815 
816             array[0] = (MBBan)objArray[0];
817             array[1] = (MBBan)objArray[1];
818             array[2] = (MBBan)objArray[2];
819 
820             return array;
821         }
822         catch (Exception e) {
823             throw processException(e);
824         }
825         finally {
826             closeSession(session);
827         }
828     }
829 
830     public List<MBBan> findByBanUserId(long banUserId)
831         throws SystemException {
832         Object[] finderArgs = new Object[] { new Long(banUserId) };
833 
834         List<MBBan> list = (List<MBBan>)FinderCacheUtil.getResult(FINDER_PATH_FIND_BY_BANUSERID,
835                 finderArgs, this);
836 
837         if (list == null) {
838             Session session = null;
839 
840             try {
841                 session = openSession();
842 
843                 StringBundler query = new StringBundler(2);
844 
845                 query.append(_SQL_SELECT_MBBAN_WHERE);
846 
847                 query.append(_FINDER_COLUMN_BANUSERID_BANUSERID_2);
848 
849                 String sql = query.toString();
850 
851                 Query q = session.createQuery(sql);
852 
853                 QueryPos qPos = QueryPos.getInstance(q);
854 
855                 qPos.add(banUserId);
856 
857                 list = q.list();
858             }
859             catch (Exception e) {
860                 throw processException(e);
861             }
862             finally {
863                 if (list == null) {
864                     list = new ArrayList<MBBan>();
865                 }
866 
867                 cacheResult(list);
868 
869                 FinderCacheUtil.putResult(FINDER_PATH_FIND_BY_BANUSERID,
870                     finderArgs, list);
871 
872                 closeSession(session);
873             }
874         }
875 
876         return list;
877     }
878 
879     public List<MBBan> findByBanUserId(long banUserId, int start, int end)
880         throws SystemException {
881         return findByBanUserId(banUserId, start, end, null);
882     }
883 
884     public List<MBBan> findByBanUserId(long banUserId, int start, int end,
885         OrderByComparator obc) throws SystemException {
886         Object[] finderArgs = new Object[] {
887                 new Long(banUserId),
888                 
889                 String.valueOf(start), String.valueOf(end), String.valueOf(obc)
890             };
891 
892         List<MBBan> list = (List<MBBan>)FinderCacheUtil.getResult(FINDER_PATH_FIND_BY_OBC_BANUSERID,
893                 finderArgs, this);
894 
895         if (list == null) {
896             Session session = null;
897 
898             try {
899                 session = openSession();
900 
901                 StringBundler query = null;
902 
903                 if (obc != null) {
904                     query = new StringBundler(3 +
905                             (obc.getOrderByFields().length * 3));
906                 }
907                 else {
908                     query = new StringBundler(2);
909                 }
910 
911                 query.append(_SQL_SELECT_MBBAN_WHERE);
912 
913                 query.append(_FINDER_COLUMN_BANUSERID_BANUSERID_2);
914 
915                 if (obc != null) {
916                     appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS, obc);
917                 }
918 
919                 String sql = query.toString();
920 
921                 Query q = session.createQuery(sql);
922 
923                 QueryPos qPos = QueryPos.getInstance(q);
924 
925                 qPos.add(banUserId);
926 
927                 list = (List<MBBan>)QueryUtil.list(q, getDialect(), start, end);
928             }
929             catch (Exception e) {
930                 throw processException(e);
931             }
932             finally {
933                 if (list == null) {
934                     list = new ArrayList<MBBan>();
935                 }
936 
937                 cacheResult(list);
938 
939                 FinderCacheUtil.putResult(FINDER_PATH_FIND_BY_OBC_BANUSERID,
940                     finderArgs, list);
941 
942                 closeSession(session);
943             }
944         }
945 
946         return list;
947     }
948 
949     public MBBan findByBanUserId_First(long banUserId, OrderByComparator obc)
950         throws NoSuchBanException, SystemException {
951         List<MBBan> list = findByBanUserId(banUserId, 0, 1, obc);
952 
953         if (list.isEmpty()) {
954             StringBundler msg = new StringBundler(4);
955 
956             msg.append(_NO_SUCH_ENTITY_WITH_KEY);
957 
958             msg.append("banUserId=");
959             msg.append(banUserId);
960 
961             msg.append(StringPool.CLOSE_CURLY_BRACE);
962 
963             throw new NoSuchBanException(msg.toString());
964         }
965         else {
966             return list.get(0);
967         }
968     }
969 
970     public MBBan findByBanUserId_Last(long banUserId, OrderByComparator obc)
971         throws NoSuchBanException, SystemException {
972         int count = countByBanUserId(banUserId);
973 
974         List<MBBan> list = findByBanUserId(banUserId, count - 1, count, obc);
975 
976         if (list.isEmpty()) {
977             StringBundler msg = new StringBundler(4);
978 
979             msg.append(_NO_SUCH_ENTITY_WITH_KEY);
980 
981             msg.append("banUserId=");
982             msg.append(banUserId);
983 
984             msg.append(StringPool.CLOSE_CURLY_BRACE);
985 
986             throw new NoSuchBanException(msg.toString());
987         }
988         else {
989             return list.get(0);
990         }
991     }
992 
993     public MBBan[] findByBanUserId_PrevAndNext(long banId, long banUserId,
994         OrderByComparator obc) throws NoSuchBanException, SystemException {
995         MBBan mbBan = findByPrimaryKey(banId);
996 
997         int count = countByBanUserId(banUserId);
998 
999         Session session = null;
1000
1001        try {
1002            session = openSession();
1003
1004            StringBundler query = null;
1005
1006            if (obc != null) {
1007                query = new StringBundler(3 +
1008                        (obc.getOrderByFields().length * 3));
1009            }
1010            else {
1011                query = new StringBundler(2);
1012            }
1013
1014            query.append(_SQL_SELECT_MBBAN_WHERE);
1015
1016            query.append(_FINDER_COLUMN_BANUSERID_BANUSERID_2);
1017
1018            if (obc != null) {
1019                appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS, obc);
1020            }
1021
1022            String sql = query.toString();
1023
1024            Query q = session.createQuery(sql);
1025
1026            QueryPos qPos = QueryPos.getInstance(q);
1027
1028            qPos.add(banUserId);
1029
1030            Object[] objArray = QueryUtil.getPrevAndNext(q, count, obc, mbBan);
1031
1032            MBBan[] array = new MBBanImpl[3];
1033
1034            array[0] = (MBBan)objArray[0];
1035            array[1] = (MBBan)objArray[1];
1036            array[2] = (MBBan)objArray[2];
1037
1038            return array;
1039        }
1040        catch (Exception e) {
1041            throw processException(e);
1042        }
1043        finally {
1044            closeSession(session);
1045        }
1046    }
1047
1048    public MBBan findByG_B(long groupId, long banUserId)
1049        throws NoSuchBanException, SystemException {
1050        MBBan mbBan = fetchByG_B(groupId, banUserId);
1051
1052        if (mbBan == null) {
1053            StringBundler msg = new StringBundler(6);
1054
1055            msg.append(_NO_SUCH_ENTITY_WITH_KEY);
1056
1057            msg.append("groupId=");
1058            msg.append(groupId);
1059
1060            msg.append(", banUserId=");
1061            msg.append(banUserId);
1062
1063            msg.append(StringPool.CLOSE_CURLY_BRACE);
1064
1065            if (_log.isWarnEnabled()) {
1066                _log.warn(msg.toString());
1067            }
1068
1069            throw new NoSuchBanException(msg.toString());
1070        }
1071
1072        return mbBan;
1073    }
1074
1075    public MBBan fetchByG_B(long groupId, long banUserId)
1076        throws SystemException {
1077        return fetchByG_B(groupId, banUserId, true);
1078    }
1079
1080    public MBBan fetchByG_B(long groupId, long banUserId,
1081        boolean retrieveFromCache) throws SystemException {
1082        Object[] finderArgs = new Object[] {
1083                new Long(groupId), new Long(banUserId)
1084            };
1085
1086        Object result = null;
1087
1088        if (retrieveFromCache) {
1089            result = FinderCacheUtil.getResult(FINDER_PATH_FETCH_BY_G_B,
1090                    finderArgs, this);
1091        }
1092
1093        if (result == null) {
1094            Session session = null;
1095
1096            try {
1097                session = openSession();
1098
1099                StringBundler query = new StringBundler(3);
1100
1101                query.append(_SQL_SELECT_MBBAN_WHERE);
1102
1103                query.append(_FINDER_COLUMN_G_B_GROUPID_2);
1104
1105                query.append(_FINDER_COLUMN_G_B_BANUSERID_2);
1106
1107                String sql = query.toString();
1108
1109                Query q = session.createQuery(sql);
1110
1111                QueryPos qPos = QueryPos.getInstance(q);
1112
1113                qPos.add(groupId);
1114
1115                qPos.add(banUserId);
1116
1117                List<MBBan> list = q.list();
1118
1119                result = list;
1120
1121                MBBan mbBan = null;
1122
1123                if (list.isEmpty()) {
1124                    FinderCacheUtil.putResult(FINDER_PATH_FETCH_BY_G_B,
1125                        finderArgs, list);
1126                }
1127                else {
1128                    mbBan = list.get(0);
1129
1130                    cacheResult(mbBan);
1131
1132                    if ((mbBan.getGroupId() != groupId) ||
1133                            (mbBan.getBanUserId() != banUserId)) {
1134                        FinderCacheUtil.putResult(FINDER_PATH_FETCH_BY_G_B,
1135                            finderArgs, mbBan);
1136                    }
1137                }
1138
1139                return mbBan;
1140            }
1141            catch (Exception e) {
1142                throw processException(e);
1143            }
1144            finally {
1145                if (result == null) {
1146                    FinderCacheUtil.putResult(FINDER_PATH_FETCH_BY_G_B,
1147                        finderArgs, new ArrayList<MBBan>());
1148                }
1149
1150                closeSession(session);
1151            }
1152        }
1153        else {
1154            if (result instanceof List<?>) {
1155                return null;
1156            }
1157            else {
1158                return (MBBan)result;
1159            }
1160        }
1161    }
1162
1163    public List<Object> findWithDynamicQuery(DynamicQuery dynamicQuery)
1164        throws SystemException {
1165        Session session = null;
1166
1167        try {
1168            session = openSession();
1169
1170            dynamicQuery.compile(session);
1171
1172            return dynamicQuery.list();
1173        }
1174        catch (Exception e) {
1175            throw processException(e);
1176        }
1177        finally {
1178            closeSession(session);
1179        }
1180    }
1181
1182    public List<Object> findWithDynamicQuery(DynamicQuery dynamicQuery,
1183        int start, int end) throws SystemException {
1184        Session session = null;
1185
1186        try {
1187            session = openSession();
1188
1189            dynamicQuery.setLimit(start, end);
1190
1191            dynamicQuery.compile(session);
1192
1193            return dynamicQuery.list();
1194        }
1195        catch (Exception e) {
1196            throw processException(e);
1197        }
1198        finally {
1199            closeSession(session);
1200        }
1201    }
1202
1203    public List<MBBan> findAll() throws SystemException {
1204        return findAll(QueryUtil.ALL_POS, QueryUtil.ALL_POS, null);
1205    }
1206
1207    public List<MBBan> findAll(int start, int end) throws SystemException {
1208        return findAll(start, end, null);
1209    }
1210
1211    public List<MBBan> findAll(int start, int end, OrderByComparator obc)
1212        throws SystemException {
1213        Object[] finderArgs = new Object[] {
1214                String.valueOf(start), String.valueOf(end), String.valueOf(obc)
1215            };
1216
1217        List<MBBan> list = (List<MBBan>)FinderCacheUtil.getResult(FINDER_PATH_FIND_ALL,
1218                finderArgs, this);
1219
1220        if (list == null) {
1221            Session session = null;
1222
1223            try {
1224                session = openSession();
1225
1226                StringBundler query = null;
1227                String sql = null;
1228
1229                if (obc != null) {
1230                    query = new StringBundler(2 +
1231                            (obc.getOrderByFields().length * 3));
1232
1233                    query.append(_SQL_SELECT_MBBAN);
1234
1235                    appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS, obc);
1236
1237                    sql = query.toString();
1238                }
1239
1240                sql = _SQL_SELECT_MBBAN;
1241
1242                Query q = session.createQuery(sql);
1243
1244                if (obc == null) {
1245                    list = (List<MBBan>)QueryUtil.list(q, getDialect(), start,
1246                            end, false);
1247
1248                    Collections.sort(list);
1249                }
1250                else {
1251                    list = (List<MBBan>)QueryUtil.list(q, getDialect(), start,
1252                            end);
1253                }
1254            }
1255            catch (Exception e) {
1256                throw processException(e);
1257            }
1258            finally {
1259                if (list == null) {
1260                    list = new ArrayList<MBBan>();
1261                }
1262
1263                cacheResult(list);
1264
1265                FinderCacheUtil.putResult(FINDER_PATH_FIND_ALL, finderArgs, list);
1266
1267                closeSession(session);
1268            }
1269        }
1270
1271        return list;
1272    }
1273
1274    public void removeByGroupId(long groupId) throws SystemException {
1275        for (MBBan mbBan : findByGroupId(groupId)) {
1276            remove(mbBan);
1277        }
1278    }
1279
1280    public void removeByUserId(long userId) throws SystemException {
1281        for (MBBan mbBan : findByUserId(userId)) {
1282            remove(mbBan);
1283        }
1284    }
1285
1286    public void removeByBanUserId(long banUserId) throws SystemException {
1287        for (MBBan mbBan : findByBanUserId(banUserId)) {
1288            remove(mbBan);
1289        }
1290    }
1291
1292    public void removeByG_B(long groupId, long banUserId)
1293        throws NoSuchBanException, SystemException {
1294        MBBan mbBan = findByG_B(groupId, banUserId);
1295
1296        remove(mbBan);
1297    }
1298
1299    public void removeAll() throws SystemException {
1300        for (MBBan mbBan : findAll()) {
1301            remove(mbBan);
1302        }
1303    }
1304
1305    public int countByGroupId(long groupId) throws SystemException {
1306        Object[] finderArgs = new Object[] { new Long(groupId) };
1307
1308        Long count = (Long)FinderCacheUtil.getResult(FINDER_PATH_COUNT_BY_GROUPID,
1309                finderArgs, this);
1310
1311        if (count == null) {
1312            Session session = null;
1313
1314            try {
1315                session = openSession();
1316
1317                StringBundler query = new StringBundler(2);
1318
1319                query.append(_SQL_COUNT_MBBAN_WHERE);
1320
1321                query.append(_FINDER_COLUMN_GROUPID_GROUPID_2);
1322
1323                String sql = query.toString();
1324
1325                Query q = session.createQuery(sql);
1326
1327                QueryPos qPos = QueryPos.getInstance(q);
1328
1329                qPos.add(groupId);
1330
1331                count = (Long)q.uniqueResult();
1332            }
1333            catch (Exception e) {
1334                throw processException(e);
1335            }
1336            finally {
1337                if (count == null) {
1338                    count = Long.valueOf(0);
1339                }
1340
1341                FinderCacheUtil.putResult(FINDER_PATH_COUNT_BY_GROUPID,
1342                    finderArgs, count);
1343
1344                closeSession(session);
1345            }
1346        }
1347
1348        return count.intValue();
1349    }
1350
1351    public int countByUserId(long userId) throws SystemException {
1352        Object[] finderArgs = new Object[] { new Long(userId) };
1353
1354        Long count = (Long)FinderCacheUtil.getResult(FINDER_PATH_COUNT_BY_USERID,
1355                finderArgs, this);
1356
1357        if (count == null) {
1358            Session session = null;
1359
1360            try {
1361                session = openSession();
1362
1363                StringBundler query = new StringBundler(2);
1364
1365                query.append(_SQL_COUNT_MBBAN_WHERE);
1366
1367                query.append(_FINDER_COLUMN_USERID_USERID_2);
1368
1369                String sql = query.toString();
1370
1371                Query q = session.createQuery(sql);
1372
1373                QueryPos qPos = QueryPos.getInstance(q);
1374
1375                qPos.add(userId);
1376
1377                count = (Long)q.uniqueResult();
1378            }
1379            catch (Exception e) {
1380                throw processException(e);
1381            }
1382            finally {
1383                if (count == null) {
1384                    count = Long.valueOf(0);
1385                }
1386
1387                FinderCacheUtil.putResult(FINDER_PATH_COUNT_BY_USERID,
1388                    finderArgs, count);
1389
1390                closeSession(session);
1391            }
1392        }
1393
1394        return count.intValue();
1395    }
1396
1397    public int countByBanUserId(long banUserId) throws SystemException {
1398        Object[] finderArgs = new Object[] { new Long(banUserId) };
1399
1400        Long count = (Long)FinderCacheUtil.getResult(FINDER_PATH_COUNT_BY_BANUSERID,
1401                finderArgs, this);
1402
1403        if (count == null) {
1404            Session session = null;
1405
1406            try {
1407                session = openSession();
1408
1409                StringBundler query = new StringBundler(2);
1410
1411                query.append(_SQL_COUNT_MBBAN_WHERE);
1412
1413                query.append(_FINDER_COLUMN_BANUSERID_BANUSERID_2);
1414
1415                String sql = query.toString();
1416
1417                Query q = session.createQuery(sql);
1418
1419                QueryPos qPos = QueryPos.getInstance(q);
1420
1421                qPos.add(banUserId);
1422
1423                count = (Long)q.uniqueResult();
1424            }
1425            catch (Exception e) {
1426                throw processException(e);
1427            }
1428            finally {
1429                if (count == null) {
1430                    count = Long.valueOf(0);
1431                }
1432
1433                FinderCacheUtil.putResult(FINDER_PATH_COUNT_BY_BANUSERID,
1434                    finderArgs, count);
1435
1436                closeSession(session);
1437            }
1438        }
1439
1440        return count.intValue();
1441    }
1442
1443    public int countByG_B(long groupId, long banUserId)
1444        throws SystemException {
1445        Object[] finderArgs = new Object[] {
1446                new Long(groupId), new Long(banUserId)
1447            };
1448
1449        Long count = (Long)FinderCacheUtil.getResult(FINDER_PATH_COUNT_BY_G_B,
1450                finderArgs, this);
1451
1452        if (count == null) {
1453            Session session = null;
1454
1455            try {
1456                session = openSession();
1457
1458                StringBundler query = new StringBundler(3);
1459
1460                query.append(_SQL_COUNT_MBBAN_WHERE);
1461
1462                query.append(_FINDER_COLUMN_G_B_GROUPID_2);
1463
1464                query.append(_FINDER_COLUMN_G_B_BANUSERID_2);
1465
1466                String sql = query.toString();
1467
1468                Query q = session.createQuery(sql);
1469
1470                QueryPos qPos = QueryPos.getInstance(q);
1471
1472                qPos.add(groupId);
1473
1474                qPos.add(banUserId);
1475
1476                count = (Long)q.uniqueResult();
1477            }
1478            catch (Exception e) {
1479                throw processException(e);
1480            }
1481            finally {
1482                if (count == null) {
1483                    count = Long.valueOf(0);
1484                }
1485
1486                FinderCacheUtil.putResult(FINDER_PATH_COUNT_BY_G_B, finderArgs,
1487                    count);
1488
1489                closeSession(session);
1490            }
1491        }
1492
1493        return count.intValue();
1494    }
1495
1496    public int countAll() throws SystemException {
1497        Object[] finderArgs = new Object[0];
1498
1499        Long count = (Long)FinderCacheUtil.getResult(FINDER_PATH_COUNT_ALL,
1500                finderArgs, this);
1501
1502        if (count == null) {
1503            Session session = null;
1504
1505            try {
1506                session = openSession();
1507
1508                Query q = session.createQuery(_SQL_COUNT_MBBAN);
1509
1510                count = (Long)q.uniqueResult();
1511            }
1512            catch (Exception e) {
1513                throw processException(e);
1514            }
1515            finally {
1516                if (count == null) {
1517                    count = Long.valueOf(0);
1518                }
1519
1520                FinderCacheUtil.putResult(FINDER_PATH_COUNT_ALL, finderArgs,
1521                    count);
1522
1523                closeSession(session);
1524            }
1525        }
1526
1527        return count.intValue();
1528    }
1529
1530    public void afterPropertiesSet() {
1531        String[] listenerClassNames = StringUtil.split(GetterUtil.getString(
1532                    com.liferay.portal.util.PropsUtil.get(
1533                        "value.object.listener.com.liferay.portlet.messageboards.model.MBBan")));
1534
1535        if (listenerClassNames.length > 0) {
1536            try {
1537                List<ModelListener<MBBan>> listenersList = new ArrayList<ModelListener<MBBan>>();
1538
1539                for (String listenerClassName : listenerClassNames) {
1540                    listenersList.add((ModelListener<MBBan>)Class.forName(
1541                            listenerClassName).newInstance());
1542                }
1543
1544                listeners = listenersList.toArray(new ModelListener[listenersList.size()]);
1545            }
1546            catch (Exception e) {
1547                _log.error(e);
1548            }
1549        }
1550    }
1551
1552    @BeanReference(name = "com.liferay.portlet.messageboards.service.persistence.MBBanPersistence")
1553    protected com.liferay.portlet.messageboards.service.persistence.MBBanPersistence mbBanPersistence;
1554    @BeanReference(name = "com.liferay.portlet.messageboards.service.persistence.MBCategoryPersistence")
1555    protected com.liferay.portlet.messageboards.service.persistence.MBCategoryPersistence mbCategoryPersistence;
1556    @BeanReference(name = "com.liferay.portlet.messageboards.service.persistence.MBDiscussionPersistence")
1557    protected com.liferay.portlet.messageboards.service.persistence.MBDiscussionPersistence mbDiscussionPersistence;
1558    @BeanReference(name = "com.liferay.portlet.messageboards.service.persistence.MBMessagePersistence")
1559    protected com.liferay.portlet.messageboards.service.persistence.MBMessagePersistence mbMessagePersistence;
1560    @BeanReference(name = "com.liferay.portlet.messageboards.service.persistence.MBMessageFlagPersistence")
1561    protected com.liferay.portlet.messageboards.service.persistence.MBMessageFlagPersistence mbMessageFlagPersistence;
1562    @BeanReference(name = "com.liferay.portlet.messageboards.service.persistence.MBStatsUserPersistence")
1563    protected com.liferay.portlet.messageboards.service.persistence.MBStatsUserPersistence mbStatsUserPersistence;
1564    @BeanReference(name = "com.liferay.portlet.messageboards.service.persistence.MBThreadPersistence")
1565    protected com.liferay.portlet.messageboards.service.persistence.MBThreadPersistence mbThreadPersistence;
1566    @BeanReference(name = "com.liferay.portal.service.persistence.ResourcePersistence")
1567    protected com.liferay.portal.service.persistence.ResourcePersistence resourcePersistence;
1568    @BeanReference(name = "com.liferay.portal.service.persistence.UserPersistence")
1569    protected com.liferay.portal.service.persistence.UserPersistence userPersistence;
1570    private static final String _SQL_SELECT_MBBAN = "SELECT mbBan FROM MBBan mbBan";
1571    private static final String _SQL_SELECT_MBBAN_WHERE = "SELECT mbBan FROM MBBan mbBan WHERE ";
1572    private static final String _SQL_COUNT_MBBAN = "SELECT COUNT(mbBan) FROM MBBan mbBan";
1573    private static final String _SQL_COUNT_MBBAN_WHERE = "SELECT COUNT(mbBan) FROM MBBan mbBan WHERE ";
1574    private static final String _FINDER_COLUMN_GROUPID_GROUPID_2 = "mbBan.groupId = ?";
1575    private static final String _FINDER_COLUMN_USERID_USERID_2 = "mbBan.userId = ?";
1576    private static final String _FINDER_COLUMN_BANUSERID_BANUSERID_2 = "mbBan.banUserId = ?";
1577    private static final String _FINDER_COLUMN_G_B_GROUPID_2 = "mbBan.groupId = ? AND ";
1578    private static final String _FINDER_COLUMN_G_B_BANUSERID_2 = "mbBan.banUserId = ?";
1579    private static final String _ORDER_BY_ENTITY_ALIAS = "mbBan.";
1580    private static final String _NO_SUCH_ENTITY_WITH_PRIMARY_KEY = "No MBBan exists with the primary key ";
1581    private static final String _NO_SUCH_ENTITY_WITH_KEY = "No MBBan exists with the key {";
1582    private static Log _log = LogFactoryUtil.getLog(MBBanPersistenceImpl.class);
1583}