businessdaohibernate.java

这个是完整的wap项目的源码 开发语言 Java 系统架构 Struts + hibernate + spring 数据库 Mysql5.0 应用服务器Tomcat5.0 开发工具 MyEc

package com.longtime.wap.module.front.dao.hibernate;

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.longtime.wap.common.web.Page;
import com.longtime.wap.module.front.dao.BusinessDao;

/**
 * BusinessDao层代码
 * 
 * @author bulc
 * @date Nov 26, 2007
 */
public class BusinessDaoHibernate extends HibernateDaoSupport implements
		BusinessDao {

	/**
	 * 通过业务类别列表显示业务信息
	 * 
	 * @param categoryId
	 * 				业务类别编号
	 * @param page
	 * 			分页参数
	 * @return 业务信息列表
	 */
	public List retrieveBusinessesByCategory(final Integer categoryId,
			final Page page) {
		return this.getHibernateTemplate().executeFind(new HibernateCallback() {
			public Object doInHibernate(Session session)
					throws HibernateException, SQLException {
				Query query = session.createQuery("from Business " 
						+ "where category=? order by pubDate desc");
				query.setInteger(0, categoryId);
				return query.setFirstResult(page.getFirstResult())
						.setMaxResults(page.getPageSize()).list();
			}
		});
	}

	/**
	 * 分页显示业务信息
	 * 
	 * @param page
	 * 			分页参数
	 * @return 业务列表
	 */
	public List retrieveBusinesses(final Page page) {
		return this.getHibernateTemplate().executeFind(new HibernateCallback() {
			public Object doInHibernate(Session session)
					throws HibernateException, SQLException {
				Query query = session.createQuery("from Business " 
						+ "order by pubDate desc");
				return query.setFirstResult(page.getFirstResult())
						.setMaxResults(page.getPageSize()).list();
			}
		});
	}

	/**
	 * 统计各业务类别下的信息数量
	 * 
	 * @param category
	 * 				业务类别
	 * @return 业务类别下的信息数量
	 */
	public int retrieveBusinessesCountByCategory(final Integer category) {
		return (Integer) getHibernateTemplate().execute(
				new HibernateCallback() {
					public Object doInHibernate(Session session)
							throws HibernateException, SQLException {
						StringBuilder hql = new StringBuilder();
						hql.append("select count(*) from Business business");
						if (null != category) {
							hql.append(" where business.category=?");
						}
						Query query = session.createQuery(hql.toString());
						if (null != category) {
							query.setInteger(0, category);
						}
						return query.uniqueResult();
					}

				});
	}
}