nsthreadhibernatedao.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.hibernate.criterion.DetachedCriteria;
import org.springframework.dao.DataAccessException;
import org.springframework.orm.hibernate3.HibernateCallback;

import com.singnet.dao.INsThreadDAO;
import com.singnet.data.PageData;

public class NsThreadHibernateDAO extends BaseHibernateDAO implements
		INsThreadDAO
{

	public PageData findPageList(DetachedCriteria dc, int pageSize,
			int startIndex)
	{
		// TODO Auto-generated method stub
		return findPageByCriteria(dc, pageSize, startIndex);
	}

	public List findLatestThreads(final long forumID, 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 NsThread t where t.postPid=:forumID order by t.postReply desc";
					Query q = session.createQuery(hql)
					.setLong("forumID", forumID);
					q.setMaxResults(num);
					return q.list();
				}
				
			});
		}
		catch(DataAccessException e) {
			logger.equals(e);
			return null;
		}
	}

}