package com.jhcf.category.dao.impl;

import java.util.ArrayList;

import org.springframework.stereotype.Repository;

import com.jhcf.category.bean.Category;
import com.jhcf.category.dao.ICategoryDao;
import com.jhcf.common.DBHelp;

@Repository
public class CategoryDao extends DBHelp implements ICategoryDao {

	/**
	 * 添加分类
	 */
	public boolean addCategory(Category category) {
		this.getHibernateTemplate().save(category);
		return category.getId()>0?true:false;
	}

	/**
	 * 查询所有分类
	 */
	public ArrayList<Category> findAllCategory() {
		String hql="select c from Category as c";
	 	ArrayList<Category> listCategory= (ArrayList<Category>) this.getHibernateTemplate().find(hql);
	 	if(listCategory.size()>0){
	 		return listCategory;
	 	}else{
	 		return null;
	 	}
	}

	/**
	 * 通过id查询分类
	 */
	public Category findCategoryById(int id) {
		return (Category) this.getHibernateTemplate().get(Category.class, id);
	}

	/**
	 * 更新分类
	 */
	public void updateCategory(Category category) {
		this.getHibernateTemplate().update(category);	
	}

}