newsdaoimpl.java

j2ee,struts2 hibernate spring2.5的电影系统简单的

package com.movie.dao.impl;

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

import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.orm.hibernate3.HibernateCallback;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.movie.dao.NewsDao;
import com.movie.dojo.News;

public class NewsDaoImpl extends HibernateDaoSupport implements NewsDao {

	public void addNews(News news) {
		getHibernateTemplate().save(news);
	}

	public void delNews(News news) {
		getHibernateTemplate().delete(news);
	}

	public int getNewsTotals() {
		return getHibernateTemplate().find("from News").size();
	}

	public News getThisNews(int id) {
		return (News) getHibernateTemplate().get(News.class, id);
	}

	public List getlistNews(int pageSize, int startRow) {
		final int pageSize1 = pageSize;
		final int startRow1 = startRow;
		return getHibernateTemplate().executeFind(new HibernateCallback() {

			public List doInHibernate(Session session)
					throws HibernateException, SQLException {
				Query query = session.createQuery("from News n order by n.newsTime desc");
				query.setFirstResult(startRow1);
				query.setMaxResults(pageSize1);
				return query.list();
			}

		});
	}

	public void modifyNews(News news) {
		getHibernateTemplate().update(news);
	}

}