sortsqlmapdao.java

>项目名称:电脑电子商务平台 >1.运行环境JDK1.6+Oracle10g+Tomcat5.5 >2.开发工具: MyEclipse Enterprise Workbench

package omega.persistence.sqlmapdao;

import java.util.List;

import com.ibatis.sqlmap.client.SqlMapClient;

import omega.domain.Shopcart;
import omega.domain.Sort;
import omega.persistence.iface.SortDao;

public class SortSqlMapDao implements SortDao {

	private static SqlMapClient sqlMapper = DaoConfig.getsqlMapper();

	public List selectAllSort() throws Exception {

		return sqlMapper.queryForList("selectAllSort");
	}

	public void deleteSortByName(String name) throws Exception {
		sqlMapper.delete("deleteSortByName", name);
	}

	public void deleteSortById(int id) throws Exception {
		sqlMapper.delete("deleteSortById", id);
	}

	public void insertSort(Sort sort) throws Exception {
		sqlMapper.insert("insertSort", sort);
	}

	public List selectSortByName(String name) throws Exception {
		return (List) sqlMapper.queryForList("selectSortByName", name);
	}

	public List selectMaxId() throws Exception {
		return (List) sqlMapper.queryForList("selectMaxId");
	}

	public Sort getMaxId() throws Exception {
		return (Sort) sqlMapper.queryForObject("getSortMaxId");
	}

	public int getCount() throws Exception {
		return (Integer) sqlMapper.queryForObject("getSortCount");
	}

}