forumhibernatedao.java

一个jsp写的bbs

        if (auditing != -1) {
          c.add(Restrictions.eq("auditing", new Integer(auditing)));
        }
        if (StringUtils.isNotBlank(orderby)) {
          if (ascOrDesc == Constant.ORDER_ASC) {
            c.addOrder(Order.asc(orderby));
          }
          if (ascOrDesc == Constant.ORDER_DESC) {
            c.addOrder(Order.desc(orderby));
          }
        }
        c.setFirstResult(firstResult);
        c.setMaxResults(maxResults);
        return c.list();
      }
    });
  }

  public List findForumsInBids(final List bids, final int isNew, final int delSign,
                               final int auditing, final OrderObj[] oo, final int firstResult,
                               final int maxResults) {
    return getHibernateTemplate().executeFind(new HibernateCallback() {
      public Object doInHibernate(Session s) throws HibernateException {
        Criteria c = s.createCriteria(Forum.class);
        if (bids != null && !bids.isEmpty()) {
          c.add(Restrictions.in("boardID", bids));
        }
        if (isNew != -1) {
          c.add(Restrictions.eq("isNew", new Integer(isNew)));
        }
        if (delSign != -1) {
          c.add(Restrictions.eq("delSign", new Integer(delSign)));
        }
        if (auditing != -1) {
          c.add(Restrictions.eq("auditing", new Integer(auditing)));
        }
        if (oo != null && oo.length > 0) {
          for (int i = 0; i < oo.length; i++) {
            if (StringUtils.isNotBlank(oo[i].getOrderBy())) {
              if (oo[i].getAscOrDesc() == Constant.ORDER_ASC) {
                c.addOrder(Order.asc(oo[i].getOrderBy()));
              }
              if (oo[i].getAscOrDesc() == Constant.ORDER_DESC) {
                c.addOrder(Order.desc(oo[i].getOrderBy()));
              }
            }
          }
        }
        c.setFirstResult(firstResult);
        c.setMaxResults(maxResults);
        return c.list();
      }
    });
  }

  /**
   *
   * @param bid long
   * @param elite long
   * @param eliteId long
   * @return List
   * @todo Implement this com.laoer.bbscs.dao.ForumDAO method
   */
  public List findForumsElite(long bid, long elite, long eliteId) {
    Object[] o = {new Long(bid), new Long(elite), new Long(eliteId)};
    return this.getHibernateTemplate().find(LOADS_ELITE, o);
  }

  /**
   *
   * @param bid long
   * @param con String
   * @param text String
   * @param delSign int
   * @param auditing int
   * @return int
   * @todo Implement this com.laoer.bbscs.dao.ForumDAO method
   */
  public int getSearchNum(final long bid, final String con, final String text, final int delSign,
                          final int auditing) {
    List l = getHibernateTemplate().executeFind(new HibernateCallback() {
      public Object doInHibernate(Session s) throws HibernateException {
        Criteria c = s.createCriteria(Forum.class);
        c.setProjection(Projections.count("id"));
        c.add(Restrictions.eq("boardID", new Long(bid)));
        c.add(Restrictions.like(con, "%" + text + "%"));
        if (delSign != -1) {
          c.add(Restrictions.eq("delSign", new Integer(delSign)));
        }
        if (auditing != -1) {
          c.add(Restrictions.eq("auditing", new Integer(auditing)));
        }
        return c.list();
      }
    });
    if (l == null || l.isEmpty()) {
      return 0;
    }
    else {
      return ( (Integer) l.get(0)).intValue();
    }
  }

  /**
   *
   * @param bid long
   * @param con String
   * @param text String
   * @param delSign int
   * @param auditing int
   * @param orderby String
   * @param ascOrDesc int
   * @param firstResult int
   * @param maxResults int
   * @return List
   * @todo Implement this com.laoer.bbscs.dao.ForumDAO method
   */
  public List getSearchList(final long bid, final String con, final String text, final int delSign,
                            final int auditing, final String orderby, final int ascOrDesc,
                            final int firstResult, final int maxResults) {
    return getHibernateTemplate().executeFind(new HibernateCallback() {
      public Object doInHibernate(Session s) throws HibernateException {
        Criteria c = s.createCriteria(Forum.class);
        c.add(Restrictions.eq("boardID", new Long(bid)));
        c.add(Restrictions.like(con, "%" + text + "%"));
        if (delSign != -1) {
          c.add(Restrictions.eq("delSign", new Integer(delSign)));
        }
        if (auditing != -1) {
          c.add(Restrictions.eq("auditing", new Integer(auditing)));
        }
        if (StringUtils.isNotBlank(orderby)) {
          if (ascOrDesc == Constant.ORDER_ASC) {
            c.addOrder(Order.asc(orderby));
          }
          if (ascOrDesc == Constant.ORDER_DESC) {
            c.addOrder(Order.desc(orderby));
          }
        }
        c.setFirstResult(firstResult);
        c.setMaxResults(maxResults);
        return c.list();
      }
    });
  }

  /**
   *
   * @param userID String
   * @return int
   * @todo Implement this com.laoer.bbscs.dao.ForumDAO method
   */
  public int getForumOwnerNum(final String userID, final int isNew, final int delSign,
                              final int auditing) {
    List l = getHibernateTemplate().executeFind(new HibernateCallback() {
      public Object doInHibernate(Session s) throws HibernateException {
        Criteria c = s.createCriteria(Forum.class);
        c.setProjection(Projections.count("id"));
        c.add(Restrictions.eq("userID", userID));
        if (isNew != -1) {
          c.add(Restrictions.eq("isNew", new Integer(isNew)));
        }
        if (delSign != -1) {
          c.add(Restrictions.eq("delSign", new Integer(delSign)));
        }
        if (auditing != -1) {
          c.add(Restrictions.eq("auditing", new Integer(auditing)));
        }
        return c.list();
      }
    });
    if (l == null || l.isEmpty()) {
      return 0;
    }
    else {
      return ( (Integer) l.get(0)).intValue();
    }

  }

  /**
   *
   * @param userID String
   * @param firstResult int
   * @param maxResults int
   * @return List
   * @todo Implement this com.laoer.bbscs.dao.ForumDAO method
   */
  public List findForumsOwner(final String userID, final int isNew, final int delSign,
                              final int auditing, final String orderby, final int ascOrDesc,
                              final int firstResult, final int maxResults) {
    return getHibernateTemplate().executeFind(new HibernateCallback() {
      public Object doInHibernate(Session s) throws HibernateException {
        Criteria c = s.createCriteria(Forum.class);
        c.add(Restrictions.eq("userID", userID));
        if (isNew != -1) {
          c.add(Restrictions.eq("isNew", new Integer(isNew)));
        }
        if (delSign != -1) {
          c.add(Restrictions.eq("delSign", new Integer(delSign)));
        }
        if (auditing != -1) {
          c.add(Restrictions.eq("auditing", new Integer(auditing)));
        }
        if (StringUtils.isNotBlank(orderby)) {
          if (ascOrDesc == Constant.ORDER_ASC) {
            c.addOrder(Order.asc(orderby));
          }
          if (ascOrDesc == Constant.ORDER_DESC) {
            c.addOrder(Order.desc(orderby));
          }
        }
        c.setFirstResult(firstResult);
        c.setMaxResults(maxResults);
        return c.list();
      }
    });

  }

  /**
   *
   * @param id String
   * @param bid long
   * @todo Implement this com.laoer.bbscs.dao.ForumDAO method
   */
  public void removeForum(final String id, final long bid) {
    getHibernateTemplate().execute(new HibernateCallback() {
      public Object doInHibernate(Session s) throws HibernateException, SQLException {
        Query query = s.createQuery(DEL_BY_ID_BID);
        query.setString(1, id);
        query.setLong(2, bid);
        query.executeUpdate();
        return null;
      }
    });
  }

  /**
   *
   * @param id String
   * @todo Implement this com.laoer.bbscs.dao.ForumDAO method
   */
  public void removeForum(final String id) {
    getHibernateTemplate().execute(new HibernateCallback() {
      public Object doInHibernate(Session s) throws HibernateException, SQLException {
        Query query = s.createQuery(DEL_BY_ID);
        query.setString(1, id);
        query.executeUpdate();
        return null;
      }
    });
  }

  /**
   *
   * @param forum Forum
   * @todo Implement this com.laoer.bbscs.dao.ForumDAO method
   */
  public void removeForum(Forum forum) {
    this.getHibernateTemplate().delete(forum);
  }

  public int getForumNumRcc(final List bids, final int reNum, final int click, final long commend) {
    List l = getHibernateTemplate().executeFind(new HibernateCallback() {
      public Object doInHibernate(Session s) throws HibernateException {
        Criteria c = s.createCriteria(Forum.class);
        c.setProjection(Projections.count("id"));
        if (bids != null && !bids.isEmpty()) {
          c.add(Restrictions.in("boardID", bids));
        }
        if (reNum != -1) {
          c.add(Restrictions.ge("reNum", new Integer(reNum)));
        }
        if (click != -1) {
          c.add(Restrictions.eq("click", new Integer(click)));
        }
        if (commend != -1) {
          c.add(Restrictions.eq("commend", new Long(commend)));
        }
        //c.add(Restrictions.eq("isNew", new Integer(1)));
        c.add(Restrictions.eq("delSign", new Integer(0)));
        c.add(Restrictions.eq("auditing", new Integer(0)));

        return c.list();
      }
    });
    if (l == null || l.isEmpty()) {
      return 0;
    }
    else {
      return ( (Integer) l.get(0)).intValue();
    }

  }

  public List findForumsRcc(final List bids, final int reNum, final int click, final long commend,
                            final String orderby, final int ascOrDesc, final int firstResult,
                            final int maxResults) {
    return getHibernateTemplate().executeFind(new HibernateCallback() {
      public Object doInHibernate(Session s) throws HibernateException {
        Criteria c = s.createCriteria(Forum.class);
        if (bids != null && !bids.isEmpty()) {
          c.add(Restrictions.in("boardID", bids));
        }
        if (reNum != -1) {
          c.add(Restrictions.ge("reNum", new Integer(reNum)));
        }
        if (click != -1) {
          c.add(Restrictions.eq("click", new Integer(click)));
        }
        if (commend != -1) {
          c.add(Restrictions.eq("commend", new Long(commend)));
        }
        //c.add(Restrictions.eq("isNew", new Integer(1)));
        c.add(Restrictions.eq("delSign", new Integer(0)));
        c.add(Restrictions.eq("auditing", new Integer(0)));

        if (StringUtils.isNotBlank(orderby)) {
          if (ascOrDesc == Constant.ORDER_ASC) {
            c.addOrder(Order.asc(orderby));
          }
          if (ascOrDesc == Constant.ORDER_DESC) {
            c.addOrder(Order.desc(orderby));
          }
        }

        c.setFirstResult(firstResult);
        c.setMaxResults(maxResults);
        return c.list();
      }
    });
  }

  /**
   *
   * @param bid long
   * @param reNum int
   * @param click int
   * @param commend int
   * @return int
   */
  public int getForumNumRcc(final long bid, final int reNum, final int click, final long commend) {
    List l = getHibernateTemplate().executeFind(new HibernateCallback() {
      public Object doInHibernate(Session s) throws HibernateException {
        Criteria c = s.createCriteria(Forum.class);
        c.setProjection(Projections.count("id"));
        c.add(Restrictions.eq("boardID", new Long(bid)));
        if (reNum != -1) {
          c.add(Restrictions.ge("reNum", new Integer(reNum)));
        }
        if (click != -1) {
          c.add(Restrictions.ge("click", new Integer(click)));
        }
        if (commend != -1) {
          c.add(Restrictions.eq("commend", new Long(commend)));
        }
        //c.add(Restrictions.eq("isNew", new Integer(1)));
        c.add(Restrictions.eq("delSign", new Integer(0)));
        c.add(Restrictions.eq("auditing", new Integer(0)));

        return c.list();
      }
    });
    if (l == null || l.isEmpty()) {
      return 0;
    }
    else {
      return ( (Integer) l.get(0)).intValue();
    }