productdao.java

网上购物系统struts+spring+hibernate实现

package com.sdi0708.bdifn.bookstore.dao.impl;

import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;

import com.sdi0708.bdifn.bookstore.dao.IProductDao;
import com.sdi0708.bdifn.bookstore.domain.Product;

public class ProductDao extends BaseDao implements IProductDao {

	public void addProduct(Product p) {
		Product pp = p;
		Session session = openSession();
		session.save(pp);
	}

	public void deleteProduct(Long id) {
		Session session = openSession();
		String hql = "delete from Product p where p.id = ?";
		Query q = session.createQuery(hql);
		q.setLong(0, id);
		q.executeUpdate();
	}

	@SuppressWarnings("unchecked")
	public List<Product> findAllProduct(Long cid) {
		Session session = openSession();
		List<Product> products = null;
		String hql = "from Product p where p.catalog.id = ? ";
		Query q = session.createQuery(hql);
		q.setLong(0, cid);
		products = q.list();
		return products;
	}

	public Product findById(Long id) {
		Session session = openSession();
		Product p = (Product) session.get(Product.class, id);
		return p;
	}

	public void modifyProduct(Product p) {
		Session session = openSession();
		session.update(p);
	}

	@SuppressWarnings("unchecked")
	public List<Product> findAllProduct(Long cid, String keyword) {
		Session session = openSession();
		List<Product> products = null;
		if(cid == null) {
			String hql = "from Product p where p.productName like ? ";
			Query q = session.createQuery(hql);
			q.setString(0, "%" + keyword + "%");
			products = q.list();
		} else {
			String hql = "from Product p where p.catalog.id = ? and p.productName like ? ";
			Query q = session.createQuery(hql);
			q.setLong(0, cid);
			q.setString(1, "%" + keyword + "%");
			products = q.list();
		}
		return products;
	}

}