package com.neidetcher.petunia.service;

 import org.apache.commons.logging.Log;

 import org.apache.commons.logging.LogFactory;

 import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;

 public class CategoryDaoImpl extends SqlMapClientDaoSupport implements CategoryDao

 {

    protected Log log = LogFactory.getLog(CategoryDaoImpl.class);

    @Override

    public Category save(Category category)

    {

       log.debug(category.toString());

       if (category.getId() == null)

       {

          log.debug("create");

          Integer newId;

          newId = (Integer) getSqlMapClientTemplate().insert("Category.insert", category);

          category.setId(newId);

          return category;

       }

       log.debug("update");

       getSqlMapClientTemplate().update("Category.update", category, 1);

       return category;

    }

    public Category find(Integer id)

    {

       return (Category) getSqlMapClientTemplate().queryForObject("Category.findById", id);

    }

 }