userdaoimpl.java

taglib分页例子

package com.dengmin.pager.dao;

import java.util.List;

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

import com.dengmin.pager.PageModel;
import com.dengmin.pager.User;

public class UserDaoImpl extends HibernateDaoSupport implements UserDao {

	public void addUser(User user) {
		this.getHibernateTemplate().save(user);
	}

	public void deleteUser(int userId) {
		User user = findUserById(userId);
		this.getHibernateTemplate().delete(user);

	}

	public PageModel findAllUser(int offset, int pagesize) {
		String queryCountHql = "select count(*) from User";
		
		Query query = getSession().createQuery(queryCountHql);
		int total = ((Long)query.uniqueResult()).intValue();
		
		List datas = getSession().createQuery("from User")
					.setFirstResult(offset)
					.setMaxResults(pagesize)
					.list();
		
		PageModel pm = new PageModel();
		pm.setTotal(total);
		pm.setDatas(datas);
		
		return pm;
	}

	public User findUserById(int id) {
		return (User)this.getHibernateTemplate().load(User.class, id);
	}

	public void updateUser(User user) {
		this.getHibernateTemplate().update(user);
	}

}