package org.ssi.dao.ibatisDao;

import java.util.List;

import org.springframework.dao.DataAccessException;
import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;
import org.ssi.biz.bo.Account;
import org.ssi.dao.AccountDao;

public class AccountIbatisDao extends SqlMapClientDaoSupport implements
		AccountDao {

	public List getAccountList() throws DataAccessException {
		return getSqlMapClientTemplate().queryForList("getAccountList", null);
	}

	public List getAccountByEmail(String email) throws DataAccessException {
		return getSqlMapClientTemplate().queryForList("getAccountByEmail",
				email);
	}

	public Account getAccountByName(String userID) throws DataAccessException {
		return (Account) getSqlMapClientTemplate().queryForObject(
				"getAccountByUserID", userID);
	}

	public void updateAccount(Account account) throws DataAccessException {
		getSqlMapClientTemplate().update("updateAccount", account);
	}

	public void insertAccount(Account account) throws DataAccessException {
		getSqlMapClientTemplate().insert("insertAccount", account);
	}

	public void removeAccount(String userID) throws DataAccessException {
		getSqlMapClientTemplate().delete("deleteAccount", userID);
	}

}