orderssqlmapdao.java

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

package omega.persistence.sqlmapdao;

import java.util.Date;
import java.text.*;
import java.util.List;

import omega.persistence.iface.OrdersDao;

import com.ibatis.sqlmap.client.SqlMapClient;

import omega.domain.Orders; //BEAN
import omega.domain.Product;


public class OrdersSqlMapDao implements OrdersDao{
	private static SqlMapClient sqlMapper=DaoConfig.getsqlMapper();
	
	
	public List selectAllUser() throws Exception {
		return sqlMapper.queryForList("selectAlluser");

	}
	
    public Orders selectMaxId()throws Exception
    {
    	return (Orders)sqlMapper.queryForObject("selectOrdersMaxId");
    }
	public void insertOrders(Orders orders) throws Exception {
		sqlMapper.insert("insertOrders", orders);
	}
    
	public void deleteOrdersById(String orderId)throws Exception
	{
		sqlMapper.delete("deleteOrderById", orderId);
		
	}

	public Orders getMaxId() throws Exception {
		return (Orders) sqlMapper.queryForObject("getOrdersMaxId");
	}

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