categorydb.java

java用ibatis来实现持久层一个例子

/*
 * Created on 2003-10-11
 *
 * To change the template for this generated file go to
 * Window - Preferences - Java - Code Generation - Code and Comments
 */
package com.ewuxi.champion.persistence.dao;

import com.ewuxi.champion.exception.DaoException;
import com.ewuxi.champion.persistence.vo.Category;
import com.ibatis.db.sqlmap.SqlMap;

/**
 * @author champion
 *
 *category数据库操作对象
 */

public class CategoryDb {
	
  /**
 * @param vo
 * @throws DaoException
 * 插入一条记录
 */
public void insert(Category vo) throws DaoException{
  	  try {
		SqlMap sqlMap=DaoCommon.getSqlMap(DaoCommon.getDefautDao());
		  sqlMap.executeUpdate("insertCategoryDao",vo);
	} catch (Exception e) {
		throw new DaoException(e);
	}
  }
  /**
 * @param vo
 * @throws DaoException
 * 删除一条记录
 */
public void delete(Category vo) throws DaoException{
		try {
		  SqlMap sqlMap=DaoCommon.getSqlMap(DaoCommon.getDefautDao());
			sqlMap.executeUpdate("deleteByPrimaryKeyCategoryDao",vo);
	  } catch (Exception e) {
		  throw new DaoException(e);
	  }
	}
	/**
	 * @param vo
	 * @throws DaoException
	 * 修改一条记录
	 */
	public void update(Category vo) throws DaoException{
		  try {
			SqlMap sqlMap=DaoCommon.getSqlMap(DaoCommon.getDefautDao());
			  sqlMap.executeUpdate("updateByPrimaryKeyCategoryDao",vo);
		} catch (Exception e) {
			throw new DaoException(e);
		}
	  }
	/**
	 * @param vo
	 * @return
	 * @throws DaoException
	 * 查找一条记录
	 */
	public Category findByPk(Category vo) throws DaoException{
		  try {
			SqlMap sqlMap=DaoCommon.getSqlMap(DaoCommon.getDefautDao());
			return (Category) sqlMap.executeQueryForObject("findByPrimaryKeyCategoryDao",vo);
		} catch (Exception e) {
			throw new DaoException(e);
		}
	  }
	
}