productdao.java

模仿当当网基于struts+hierbernate与mysql的商务网站。

package org.whatisjava.dang.dao;

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

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

public class ProductDao implements Serializable {
	private static final long serialVersionUID = 1L;

	private static Logger logger = Logger.getLogger(ProductDao.class);

	public Product getProduct(Integer id) {
		logger.info("getProduct("+id+")");
		Session session = null;
		try {
			session = HbSessionFactory.getSession();
			session.setFlushMode(FlushMode.NEVER);
			logger.debug(session);
			Query query = session
					.createQuery("select new Product(id,product_name,fixed_price,dang_price,has_deleted,product_pic) from Product where id = ?");
			logger.debug(query);
			query.setParameter(0, id);
			List<?> list = query.list();
			logger.debug(list);
			if (list.size() > 0) {
				logger.debug(list.get(0));
				return (Product) list.get(0);
			}
			return null;

		} catch (HibernateException e) {
			logger.error(e.toString(), e);
			return null;
		} finally {
			session.close();
		}

	}
}