productdaoimpl.java

网上购物车的JAVA代码实现版

package feng.shoppingcart.dao.impl;

import java.util.*;

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


import feng.shoppingcart.dao.ProductDao;
import feng.shoppingcart.entity.*;
import feng.shoppingcart.util.UtilContext;

public class ProductDaoImpl implements ProductDao{


	public void deleteProduct(Product product) throws Exception{
		Session session=UtilContext.getSession();
		session.delete(product);
	}


	public Product insertProduct(Product product) throws Exception{
		Session session=UtilContext.getSession();
		session.save(product);
		return product;
	}

	public Collection<Product> queryAllProduct()throws Exception {
		Session session=UtilContext.getSession();
		Query query=session.createQuery("from Product");
		List result=query.list();
		return result;
	}


	public Product queryProductByName(String name) throws Exception{
		Session session=UtilContext.getSession();
		Product product=null;
		Query query=session.createQuery("from Product as u where u.name=:name");
		query.setString("name", name);
		List result=query.list();
		if(!result.isEmpty()){
			product=(Product)result.get(0);
		}
			
		return product;
	}


	public Product queryProductById(Integer id) throws Exception{
		Session session=UtilContext.getSession();
		Product product=null;
		product=(Product)session.get(Product.class,id);
		return product;
	}



	public Product updateProduct(Product product) throws Exception{
		Session session=UtilContext.getSession();
		session.update(product);
		return product;
	}
}