📄 forumhibernatedao.java

📁 一个jsp写的bbs
💻 JAVA
📖 第 1 页 / 共 4 页
字号:
        }

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

  public List findForums(final long bid, final int isNew, final int delSign, final int auditing,
                         final int auditingAttachFile, 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 (bid != -1) {
          c.add(Restrictions.eq("boardID", new Long(bid)));
        }
        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 (auditingAttachFile != -1) {
          c.add(Restrictions.eq("auditingAttachFile", new Integer(auditingAttachFile)));
        }

        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 mainID String
   * @param delSign int
   * @param auditing int
   * @param orderby String
   * @param ascOrDesc int
   * @return List
   * @todo Implement this com.laoer.bbscs.dao.ForumDAO method
   */
  public List findForumsTopic(final long bid, final String mainID, final int delSign,
                              final int auditing, final String orderby, final int ascOrDesc) {
    return getHibernateTemplate().executeFind(new HibernateCallback() {
      public Object doInHibernate(Session s) throws HibernateException {
        Criteria c = s.createCriteria(Forum.class);
        c.add(Restrictions.eq("mainID", mainID));
        c.add(Restrictions.eq("boardID", new Long(bid)));
        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));
          }
        }

        return c.list();
      }
    });
  }

  public List findForumsTopic(final long bid, final String mainID, final int delSign,
                              final int auditing, final OrderObj[] oo) {
    return getHibernateTemplate().executeFind(new HibernateCallback() {
      public Object doInHibernate(Session s) throws HibernateException {
        Criteria c = s.createCriteria(Forum.class);
        c.add(Restrictions.eq("mainID", mainID));
        c.add(Restrictions.eq("boardID", new Long(bid)));
        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()));
              }
            }
          }
        }
        return c.list();
      }
    });
  }

  public List findForumsTopic(final long bid, final String mainID, final int delSign, final int auditing,
                              final int auditingAttachFile, final OrderObj[] oo) {
    return getHibernateTemplate().executeFind(new HibernateCallback() {
      public Object doInHibernate(Session s) throws HibernateException {
        Criteria c = s.createCriteria(Forum.class);
        c.add(Restrictions.eq("mainID", mainID));
        c.add(Restrictions.eq("boardID", new Long(bid)));
        if (delSign != -1) {
          c.add(Restrictions.eq("delSign", new Integer(delSign)));
        }
        if (auditing != -1) {
          c.add(Restrictions.eq("auditing", new Integer(auditing)));
        }
        if (auditingAttachFile != -1) {
          c.add(Restrictions.eq("auditingAttachFile", new Integer(auditingAttachFile)));
        }

        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()));
              }
            }
          }
        }
        return c.list();
      }
    });
  }

  /**
   *
   * @param bid long
   * @param mainID 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 findForumsTopic(final long bid, final String mainID, 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("mainID", mainID));
        c.add(Restrictions.eq("boardID", new Long(bid)));
        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();
      }
    });
  }

  public List findForumsTopic(final long bid, final String mainID, 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);
        c.add(Restrictions.eq("mainID", mainID));
        c.add(Restrictions.eq("boardID", new Long(bid)));
        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 bids List
   * @param isNew int
   * @param delSign int
   * @param auditing int
   * @return int
   * @todo Implement this com.laoer.bbscs.dao.ForumDAO method
   */
  public int getForumNumInBids(final List bids, 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"));
        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)));
        }
        return c.list();
      }
    });
    if (l == null || l.isEmpty()) {
      return 0;
    }
    else {
      return ( (Integer) l.get(0)).intValue();
    }
  }

  /**
   *
   * @param bids List
   * @param isNew int
   * @param delSign int
   * @param auditing int
   * @param orderby String
   * @param ascOrDesc int
   * @return List
   * @todo Implement this com.laoer.bbscs.dao.ForumDAO method
   */
  public List findForumsInBids(final List bids, final int isNew, final int delSign,
                               final int auditing, final String orderby, final int ascOrDesc) {
    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 (StringUtils.isNotBlank(orderby)) {
          if (ascOrDesc == Constant.ORDER_ASC) {
            c.addOrder(Order.asc(orderby));
          }
          if (ascOrDesc == Constant.ORDER_DESC) {
            c.addOrder(Order.desc(orderby));
          }
        }
        return c.list();
      }
    });
  }

  public List findForumsInBids(final List bids, final int isNew, final int delSign,
                               final int auditing, final OrderObj[] oo) {
    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()));
              }
            }
          }
        }
        return c.list();
      }
    });
  }

  /**
   *
   * @param bids List
   * @param isNew int
   * @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 findForumsInBids(final List bids, 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);
        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)));
        }
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -