package net.reumann.demo.persistence;

import net.reumann.demo.vo.Employee;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.springframework.orm.ibatis.SqlMapClientTemplate;
import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;
import java.util.List;

public class EmployeeIbatisDao extends SqlMapClientDaoSupport implements EmployeeDao {
    Log logger = LogFactory.getLog(this.getClass());

    public List getAllEmployees() {
        return getSqlMapClientTemplate().queryForList("Employee.getAll", null);
    }

    public Employee getEmployee(Integer id) {
        return ((Employee)getSqlMapClientTemplate().queryForObject("Employee.getById", id));
    }

    public int update(Employee emp) {
        return getSqlMapClientTemplate().update("Employee.update", emp);
    }

    public Integer insert(Employee emp) {
        return (Integer)getSqlMapClientTemplate().insert("Employee.insert", emp);
    }

    public int delete(Integer id) {
        return getSqlMapClientTemplate().delete("Employee.delete", id);
    }
}