package cn.itbaizhan.dao.impl;

import java.sql.SQLException;
import java.util.List;

import javax.annotation.Resource;





import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.springframework.orm.hibernate3.HibernateCallback;
import org.springframework.orm.hibernate3.HibernateTemplate;
import org.springframework.stereotype.Component;

import cn.itbaizhan.dao.CommodityDao;
import cn.itbaizhan.po.Commodity;
import cn.itbaizhan.po.CommodityClass;

// 实现CommodityDao接口的类，用于操作Commodity实体
@Component("commodityDaoImpl")
public class CommodityDaoImpl implements CommodityDao {
// 使用spring对Hibernate的模版 HibernateTemplate
 @Resource(name="hibernateTemplate")
 private HibernateTemplate hibernateTemplate;
 
 // 删除指定的商品
 public void delete(Commodity commodity) {
 hibernateTemplate.delete(commodity);
 }
 // 查询所有商品
 @SuppressWarnings("unchecked")
 public List<Commodity> findAllCommoditys() {
  String hql = "from Commodity";
  return (List<Commodity>)hibernateTemplate.find(hql);
 }

 // 根据商品名模糊查询商品
 @SuppressWarnings("unchecked")
 public List<Commodity> findCommodityByName(String Name) {
  System.out.println("商品名:"+Name);
  String hql = "from Commodity c where c.commodityName like ?";
  
  return (List<Commodity>)hibernateTemplate.find(hql,"%"+Name+"%");
 }
 // 根据商品种类查询商品
 @SuppressWarnings("unchecked")
 public List<Commodity> findCommodityByClass(CommodityClass commodityclass) {
  System.out.println("种类:"+commodityclass);
  String hql = "from Commodity c where c.commodityClass = ?";
  
  return (List<Commodity>)hibernateTemplate.find(hql,commodityclass);
 }
 
 // 根据商品ID查询商品
 public Commodity findCommodityById(int id) {
  Commodity commodity = (Commodity)hibernateTemplate.get(Commodity.class, id);
  return commodity;
 }

 // 保存新的商品
 public void save(Commodity commodity) {
  System.out.println(commodity);
  hibernateTemplate.save(commodity);
 }

 // 更新指定的商品信息
 public void update(Commodity commodity) {
 hibernateTemplate.update(commodity);

 }
 // 获取HibernateTemplate实例
 public HibernateTemplate getHibernateTmeplate() {
  return hibernateTemplate;
 }
 // 设置HibernateTemplate实例
 public void setHibernateTmeplate(HibernateTemplate hibernateTemplate) {
  this.hibernateTemplate = hibernateTemplate;
 }
 // 根据商品名精确查找商品
 public List<Commodity> findCommodityBName(String Name) {
  System.out.println("商品名:"+Name);
  String hql = "from Commodity c where c.commodityName = ?";
  
  return (List<Commodity>)hibernateTemplate.find(hql,Name);
 }
 
}