productdaoimp1.java

老师给的购物车

package com.tarena.shopcart.entity.daoImp1;

import java.util.List;

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

import com.tarena.shopcart.entity.Category;
import com.tarena.shopcart.entity.PagesBean;
import com.tarena.shopcart.entity.Product;
import com.tarena.shopcart.entity.Users;
import com.tarena.shopcart.entity.dao.IProductDAO;
import com.tarena.shopcart.service.IUserService;
import com.tarena.shopcart.serviceImp1.UserServiceImp1;
import com.tarena.shopcart.util.HibernateSessionFactory;



public class ProductDAOImp1 implements IProductDAO {

	public Product findProductById(int pid) {
		Product product=null;
		Session session=null;
		Transaction tran=null;
		try{
			session=HibernateSessionFactory.getSession();
			tran=session.beginTransaction();
			product=(Product)session.createQuery("from Product p where p.productId=?").setInteger(0, pid).uniqueResult();
			tran.commit();
		}catch(Exception e){
			tran.rollback();
			e.printStackTrace();
			return null;
		}finally{
			if(session!=null){
				session.close();
			}
		}
		return product;
	}

	public List getAllProduct() {
		List list=null;
		Session session=null;
		Transaction tran=null;
		try{
			session=HibernateSessionFactory.getSession();
			tran=session.beginTransaction();
			list=session.createQuery("from Product").list();
			tran.commit();
		}catch(Exception e){
			tran.rollback();
			e.printStackTrace();
			return null;
		}finally{
			if(session!=null){
				session.close();
			}
		}
		return list;
	}
	public static void main(String[] args) {
		Product product=new Product();
		product.setAuthor("sd");
		System.out.println(new ProductDAOImp1().getProductsLikeName("p"));

	}

	public List getAllCategory() {
		List list=null;
		Session session=null;
		Transaction tran=null;
		try{
			session=HibernateSessionFactory.getSession();
			tran=session.beginTransaction();
			list=session.createQuery("from Category").list();
			tran.commit();
		}catch(Exception e){
			tran.rollback();
			e.printStackTrace();
			return null;
		}finally{
			if(session!=null){
				session.close();
			}
		}
		return list;
	}

	public Category findCategoryById(int cid) {
		Category category=null;
		Session session=null;
		Transaction tran=null;
		try{
			session=HibernateSessionFactory.getSession();
			tran=session.beginTransaction();
			category=(Category)session.createQuery("from  Category c where c.categoryId=?").setInteger(0, cid).uniqueResult();
			tran.commit();
		}catch(Exception e){
			tran.rollback();
			e.printStackTrace();
			return null;
		}finally{
			if(session!=null){
				session.close();
			}
		}
		return category;
	}

	public boolean addProduct(Product product) {
		Session session=null;
		Transaction tran=null;
		try{
			session=HibernateSessionFactory.getSession();
			tran=session.beginTransaction();
			session.save(product);
			tran.commit();
		}catch(Exception e){
			tran.rollback();
			e.printStackTrace();
			return false;
		}finally{
			if(session!=null){
				session.close();
			}
		}
		return true;
	}

	public int getProductCount() {
		List list=null;
		Session session=null;
		Transaction tran=null;
		try{
			session=HibernateSessionFactory.getSession();
			tran=session.beginTransaction();
			list=session.createQuery("from Product").list();
			tran.commit();
		}catch(Exception e){
			tran.rollback();
			e.printStackTrace();
			return 0;
		}finally{
			if(session!=null){
				session.close();
			}
		}
		return list.size();
	}

	public List getProducts(PagesBean page) {
		List l = null;
		Session session = HibernateSessionFactory.getSession();
		Transaction tran = session.beginTransaction();
		try {
			Query q=session.createQuery("from Product");
			if(page.getCurrentIndex()==1){
				q.setFirstResult(0);
			}
			else{
				q.setFirstResult((page.getCurrentIndex()-1)*page.getPageCount());
			}
			q.setMaxResults(page.getPageCount());
			l = q.list();
			tran.commit();
		} catch (Exception e) {
			if (tran != null)
				tran.rollback();
			e.printStackTrace();
		}
		return l;
	}

	public boolean deleteProduct(int pid) {
		Session session = null;
		Transaction tran = null;
		try {
			session = HibernateSessionFactory.getSession();
			tran = session.beginTransaction();
			Query query=session.createQuery("delete from Product p where p.productId=?").setInteger(0, pid);
			int flag=query.executeUpdate();
			tran.commit();
			return flag>0;
		} catch (Exception e) {
			tran.rollback();
			e.printStackTrace();
			return false;
		}finally{
			if(session!=null){
				session.close();
			}
		}
	}

	public List getProductsLikeName(String name) {
		List list=null;
		Session session=null;
		Transaction tran=null;
		try{
			session=HibernateSessionFactory.getSession();
			tran=session.beginTransaction();
			list=session.createQuery("from Product p where p.name like ? ").setString(0,"%" + name + "%").list();
			tran.commit();
		}catch(Exception e){
			tran.rollback();
			e.printStackTrace();
			return null;
		}finally{
			if(session!=null){
				session.close();
			}
		}
		return list;
	}
}