messagedao.java

用struts

package com.accp.dao;

import java.util.List;

import org.hibernate.Query;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.accp.dto.Message;


public class MessageDAO extends HibernateDaoSupport implements MessageIDAO {

	
	public void saveOrUpdate(Message msg){
		getHibernateTemplate().saveOrUpdate(msg);
	}
	
	
	
	public List findAll(){
		return  getHibernateTemplate().find("from Message as msg order by msg.time desc");
	}
	
	
	public List findPage(int curpage,int pagesize){
		Query query=getSession().createQuery("from Message as msg order by msg.time desc");
		
		query.setFirstResult((curpage-1)*pagesize).setMaxResults(pagesize);
		
		return query.list();
	}
	
	
	public int findPageCount(int pagesize){
		Query query=getSession().createQuery("from Message");
		
		int rowCount= query.list().size();
		
		if(rowCount%pagesize==0){
			return rowCount/pagesize;
		}
		return rowCount/pagesize+1;
	}
}