newsdao.java

struts spring hibernate实现的简单新闻系统

package com.pure.dao.hibernate;

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

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.dao.DataAccessException;
import org.springframework.orm.hibernate3.HibernateCallback;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.pure.bean.News;
import com.pure.comm.Page;
import com.pure.dao.INewsDAO;

public class NewsDAO extends HibernateDaoSupport implements INewsDAO {
	protected final Log logger = LogFactory.getLog(getClass());

	public NewsDAO() {
		super();
	}

	public News save(News news) {
		try {
			this.getHibernateTemplate().save(news);
			return news;
		} catch (DataAccessException e) {
			return null;
		}
	}

	public List getList(final Page page) {
		return getHibernateTemplate().executeFind(new HibernateCallback() {
			public Object doInHibernate(Session s) throws HibernateException,
					SQLException {
				Query query = s.createQuery(page.getHql());
				query.setFirstResult(page.getStartRs());
				query.setMaxResults(page.getPerPage());
				List list = query.list();
				return list;

			}
		});
	}

	public int getTotal(String hql) {
		try {
			List result = this.getHibernateTemplate().find(hql);
			if (null != result && !result.isEmpty()) {
				return ((Integer) result.get(0)).intValue();
			} else {
				return 0;
			}
		} catch (DataAccessException e) {
			return 0;
		}
	}
	
	public void remove(final int id) {
		getHibernateTemplate().executeFind(new HibernateCallback() {
			public Object doInHibernate(Session s) throws HibernateException,
					SQLException {
				Query query = s.createQuery("delete News where id=:id");
				query.setInteger("id",id);
				query.executeUpdate();
				return null;

			}
		});
	}
}