productdaoimpl.java

这是一个基于Java的网络书店系统

package com.netshop.domain.dao.hibernate;

import java.util.List;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.netshop.domain.dao.ProductDao;
import com.netshop.domain.model.Product;

public class ProductDAOImpl extends HibernateDaoSupport implements ProductDao {

	private static Log log = LogFactory.getLog(ProductDAOImpl.class);

	public Product getProduct(int productId) {
		return (Product) this.getHibernateTemplate().get(Product.class,
				productId);
	}

	public List getProductListByCategory(int categoryId) {
		return this.getHibernateTemplate()
				.find(
						" from Product pro where pro.categoryId = '"
								+ categoryId + "'");
	}

	public List searchProductList(String keywords) {
		String str = this.getSearchSql(keywords);
		return this.getHibernateTemplate().find(str);
	}

	private String getSearchSql(String keyword) {
		String key = "%" + keyword + "%";
		StringBuffer buff = new StringBuffer();
		buff.append("from Product p where ");
		buff.append(" p.name like ");
		buff.append(key);
		buff.append(" or p.description like ");
		buff.append(key);
		return buff.toString();
	}
}