pagedao.java

企业内部邮件系统（初级开发）企业内部邮件系统（初级开发）企业内部邮件系统（初级开发）

package com.struts.action;

import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;

import com.hibernate.HibernateUtils;

public class PageDao {
	public List getData() {
		return null;
	}

	public List getData(int sendtoid,int pageno, int pagesize) {
		Session session = HibernateUtils.getSession();

		Query query = session.createQuery("from Message m where m.sendtoid=?");
		query.setParameter(0, sendtoid);
		query.setFirstResult((pageno - 1) * pagesize);
		query.setMaxResults(pagesize);

		List list = query.list();

		session.close();
		return list;
	}

	public int getTotalCount() {
		Session session = HibernateUtils.getSession();

		Query query = session.createQuery("select count(*) from Message");

		int count = (Integer)query.uniqueResult();
		session.close();
		return (int)count;

	}
}