productdaoimpl.java

达内网上购物系统

package org.whatisjava.dang.dao.hibernate;

import java.io.Serializable;
import java.util.List;

import org.apache.log4j.Logger;
import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.whatisjava.dang.dao.ProductDao;
import org.whatisjava.dang.domain.Product;
import org.whatisjava.dang.util.DaoException;

public class ProductDaoImpl implements ProductDao, Serializable {
	private static final long serialVersionUID = 1L;
	private static Logger logger = Logger.getLogger(ProductDaoImpl.class);

	public Product getProduct(Integer id) throws DaoException {

		Session session = null;
		try {
			session = HbSessionFactory.getSession();

			Query query = session
					.createQuery("select new Product(id,categoryId, name, "
							+ "description, addTime, fixedPrice, "
							+ "dangPrice, keywords, hasDeleted, pic) "
							+ "from Product where id = ?");
			query.setParameter(0, id);
			List<?> list = query.list();
			if (list.size() > 0) {
				return (Product) list.get(0);
			}
			return null;

		} catch (HibernateException e) {
			logger.error("", e);
			throw new DaoException("", e);
		} finally {
			HbSessionFactory.closeSession();
		}

	}
}