Package com.liusoft.dlog4j.dao

Source Code of com.liusoft.dlog4j.dao.DlogDAO

/*
*  DlogDAO.java
*  This program is free software; you can redistribute it and/or modify
*  it under the terms of the GNU General Public License as published by
*  the Free Software Foundation; either version 2 of the License, or
*  (at your option) any later version.
*
*  This program is distributed in the hope that it will be useful,
*  but WITHOUT ANY WARRANTY; without even the implied warranty of
*  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
*  GNU Library General Public License for more details.
*
*  You should have received a copy of the GNU General Public License
*  along with this program; if not, write to the Free Software
*  Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
*  Author: Winter Lau (javayou@gmail.com)
*  http://dlog4j.sourceforge.net
*/
package com.liusoft.dlog4j.dao;

import java.util.ArrayList;
import java.util.List;

import org.hibernate.SQLQuery;
import org.hibernate.Session;

import com.liusoft.dlog4j.base.DlogStatInfo;

/**
* DLOG4Jƽ̨���������ݿ���ʷ���
* @author Winter Lau
*/
public class DlogDAO extends DAO {

  /**
   * ��ȡ�ƶ���վ�����ŵı�ǩ,�����վûָ��(site=-1)���ѯ������վ
   * @param site
   * @param count
   * @return
   */
  public static List listHotTags(int site, int count){
    Session ssn = getSession();
    StringBuffer sql = new StringBuffer("SELECT tag_name,COUNT(*) FROM dlog_tag");
    if(site>0)
      sql.append(" WHERE site_id=?");
    sql.append(" GROUP BY tag_name ORDER BY 2 DESC");
    SQLQuery query = ssn.createSQLQuery(sql.toString());
    if(site>0)
      query.setInteger(0, site);
    query.setMaxResults(count);
    List tags = new ArrayList();
    List results = query.list();
    for(int i=0;results!=null && i<results.size();i++){
      tags.add(((Object[])results.get(i))[0]);
    }
    return tags;
  }
 
  /**
   * ����ָ����վ��ͳ����Ϣ,���siteֵС��0��ȡ������վ
   * @param site
   * @return
   */
  public static DlogStatInfo getDlogStatInfo(int site){
    DlogStatInfo count = new DlogStatInfo();
    //============== �ռ���
    count.setArticle(DiaryDAO.getDiaryCount(site));
    //============== �ռ�������
    count.setArticleReply(DiaryDAO.getDiaryReplyCount(site));
    //============== ��Ƭ��
    count.setPhoto(PhotoDAO.getPhotoCount(site));
    //============== ��Ƭ������
    count.setPhotoReply(PhotoDAO.getPhotoReplyCount(site));
    //============== ��̳������
    count.setTopic(BBSTopicDAO.getTopicCount(site));
    //============== ��̳������
    count.setTopicReply(BBSReplyDAO.getReplyCount(site));
    //============== ע���û���
    count.setUser(UserDAO.getUserCount(site));
    //============== ע����վ��
    count.setSite(SiteDAO.getSiteCount());
    return count;
  }

}
TOP

Related Classes of com.liusoft.dlog4j.dao.DlogDAO

TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.