productsqlmapdao.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.Product;
import omega.persistence.iface.ProductDao;

public class ProductSqlMapDao implements ProductDao {
	private static SqlMapClient sqlMapper = DaoConfig.getsqlMapper();

	public List getProductList() throws Exception {
		return sqlMapper.queryForList("getProductList", null);
	}

	public void insertPro(Product product) throws Exception {
		sqlMapper.insert("insertProduct", product);

	}

	public void delPro(int id) throws Exception {
		sqlMapper.delete("deleteProduct", id);

	}
	
	public void updatePro(Product product)throws Exception{
		sqlMapper.update("updateProduct", product);
	}

	public Product getProduct(int productid) throws Exception {

		return (Product) sqlMapper.queryForObject("getProductbyid", productid);
	}

	public Product getMaxId() throws Exception {
		return (Product) sqlMapper.queryForObject("getProductMaxId");
	}

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

}