sqlmapfishdao.java

JPetStore源码

package org.springframework.samples.jpetstore.dao.ibatis;

import java.util.List;
import org.springframework.dao.DataAccessException;
import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;
import org.springframework.samples.jpetstore.dao.FishDao;
import org.springframework.samples.jpetstore.domain.Fish;

/**
 * SQL傪峴偆
 * 
 * @author 焨寷曮
 */
public class SqlMapFishDao extends SqlMapClientDaoSupport implements FishDao {

	/**
	 * 僨乕僞傪怴婯偡傞
	 * 
	 * @param Fish
	 *            儁乕僕忣曬
	 * @throws DataAccessException
	 *             僨乕僞堎忢張棟
	 * @return 側偟
	 */
	public void insertFish(Fish fish) throws DataAccessException {
		getSqlMapClientTemplate().insert("insertFish", fish);
	}

	/**
	 * 堦棗僨乕僞傪庢摼偡傞
	 * 
	 * @param category
	 *            categoryID
	 * @throws DataAccessException
	 *             僨乕僞堎忢張棟
	 * @return List 専嶕偟偨僨乕僞儕僗僩
	 */
	public List getFish(String category) throws DataAccessException {
		return getSqlMapClientTemplate().queryForList("getFish", category);
	}

	/**
	 * 徻嵶僨乕僞傪庢摼偡傞
	 * 
	 * @param Fish
	 *            儁乕僕忣曬
	 * @throws DataAccessException
	 *             僨乕僞堎忢張棟
	 * @return Fish 専嶕偟偨僨乕僞僼僅乕儉
	 */
	public Fish getFishDetail(Fish fish) throws DataAccessException {
		return (Fish) getSqlMapClientTemplate().queryForObject("getFishDetail",
				fish);
	}

	/**
	 * 僨乕僞傪曄峏偡傞
	 * 
	 * @param Fish
	 *            儁乕僕忣曬
	 * @throws DataAccessException
	 *             僨乕僞堎忢張棟
	 * @return 側偟
	 */
	public void updateFish(Fish fish) throws DataAccessException {
		getSqlMapClientTemplate().update("updateFish", fish, 1);
	}

	/**
	 * 僨乕僞傪嶍彍偡傞
	 * 
	 * @param Fish
	 *            儁乕僕忣曬
	 * @throws DataAccessException
	 *             僨乕僞堎忢張棟
	 * @return 側偟
	 */
	public void deleteFish(Fish fish) throws DataAccessException {
		getSqlMapClientTemplate().delete("deleteFish", fish);
	}
}