nsforumhibernatedao.java

一个成熟的论坛

package com.singnet.dao.hibernate;

import java.sql.SQLException;
import java.util.List;

import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.dao.DataAccessException;
import org.springframework.orm.hibernate3.HibernateCallback;

import com.singnet.dao.INsForumDAO;

public class NsForumHibernateDAO extends BaseHibernateDAO implements
		INsForumDAO
{

	public List findTopCountForums(final int num)
	{
		// TODO Auto-generated method stub
		try {
			return getHibernateTemplate().executeFind(new HibernateCallback() {

				public Object doInHibernate(Session session) throws HibernateException, SQLException
				{
					// TODO Auto-generated method stub
					String hql = "from NsForum f order by f.forumCount desc";
					Query q = session.createQuery(hql);
					q.setMaxResults(num);
					
					return q.list();
				}
				
			});
		}
		catch(DataAccessException e) {
			logger.equals(e);
			return null;
		}
		
	}

}