forumdao.java

在线读书交流平台

package com.olr.dao;

import java.util.List;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.hibernate.Criteria;
import org.hibernate.LockMode;
import org.hibernate.Session;
import org.hibernate.criterion.Order;
import org.hibernate.criterion.Projections;
import org.hibernate.criterion.Restrictions;
import org.springframework.context.ApplicationContext;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.olr.beans.Forum;
import com.olr.beans.Message;
import com.olr.util.Pager;

/**
 * A data access object (DAO) providing persistence and search support for Forum
 * entities. Transaction control of the save(), update() and delete() operations
 * can directly support Spring container-managed transactions or they can be
 * augmented to handle user-managed Spring transactions. Each of these methods
 * provides additional information for how to configure it for the desired type
 * of transaction control.
 * 
 * @see com.olr.beans.Forum
 * @author MyEclipse Persistence Tools
 */

public class ForumDAO extends HibernateDaoSupport implements IForumDAO{

	public void deleteForum(int forumId) {
		Object f=this.getHibernateTemplate().load(Forum.class,new Integer(forumId));
		this.getHibernateTemplate().delete(f);
	}
	
	public Forum getForumById(int forumId){
		return (Forum) this.getHibernateTemplate().load(Forum.class,forumId);
		
	}

	public Pager getAllForumsPager(int pageNo, int pageSize) {
        Session session=this.getHibernateTemplate().getSessionFactory().openSession();
		
		Criteria criteria=session.createCriteria(Forum.class);
		int rowCount=((Integer)criteria.setProjection(
				Projections.rowCount()).uniqueResult()).intValue();
		criteria.setProjection(null);
		int startIndex=pageSize*(pageNo-1);
		criteria.addOrder(Order.asc("topicCount"));
		criteria.setFirstResult(startIndex);
		criteria.setMaxResults(pageSize);
		List result=criteria.list();
		session.close();
		return new Pager(pageSize,pageNo,rowCount,result); 
	}

	public Forum getForumByName(String forumName) {
		return (Forum) this.getHibernateTemplate().load(Forum.class,forumName);
		
	}

	public List<Forum> getTopForums(int topNum,String sort) {
		Session session=this.getHibernateTemplate().getSessionFactory().openSession();
		Criteria criteria=session.createCriteria(Forum.class);
		//criteria.addOrder(Order.asc("topicCount"));
		criteria.setMaxResults(topNum);
		criteria.addOrder(Order.desc(sort));
		List result=criteria.list();
		return result;                                  
	}

	public void insertForum(Forum forum) {
		this.getHibernateTemplate().save(forum);
		
	}

	public void updateForum(Forum forum) {
		this.getHibernateTemplate().update(forum);
		
	}

	public List<Forum> getTopForums(int topNum) {
		// TODO Auto-generated method stub
		return null;
	}
	
}