ordersqlmapdao.java

简单的Jdon实现

/**
 * User: Clinton Begin Date: Jul 13, 2003 Time: 7:20:47 PM
 */
package com.jdon.framework.samples.jpetstore.persistence.dao.sqlmapdao;

import java.sql.SQLException;
import java.util.List;

import com.ibatis.sqlmap.client.SqlMapExecutor;
import com.jdon.framework.samples.jpetstore.domain.LineItem;
import com.jdon.framework.samples.jpetstore.domain.Order;
import com.jdon.framework.samples.jpetstore.persistence.dao.SqlMapDaoTemplateFactory;
import com.jdon.framework.samples.jpetstore.persistence.dao.iface.OrderDao;


public class OrderSqlMapDao implements OrderDao {
    private SqlMapExecutor sqlMapDaoTemplate;

    public OrderSqlMapDao(SqlMapDaoTemplateFactory sqlMapDaoTemplateFactory) {
        sqlMapDaoTemplate = sqlMapDaoTemplateFactory.getSqlMapDaoTemp();
    }
    
    
    public int getOrderIDsByUsernameCount(String username) throws SQLException{
        Integer countI = (Integer)sqlMapDaoTemplate.queryForObject(
                "getOrdersByUsernameCount", username);
        return countI.intValue();
    }

    public List getOrderIDsByUsername(String username, int start, int count) throws SQLException{
        
        return sqlMapDaoTemplate.queryForList("getOrdersByUsername", username, start, count);
    }

    public Order getOrder(int orderId)  throws SQLException{
        Order order = null;
        Object parameterObject = new Integer(orderId);
        order = (Order) sqlMapDaoTemplate.queryForObject("getOrder", parameterObject);
        order.setLineItems(sqlMapDaoTemplate.queryForList("getLineItemsByOrderId", new Integer(
                order.getOrderId())));
        return order;
    }

    public void insertOrder(Order order)  throws SQLException{
        sqlMapDaoTemplate.update("insertOrder", order);
        sqlMapDaoTemplate.update("insertOrderStatus", order);
        for (int i = 0; i < order.getLineItems().size(); i++) {
            LineItem lineItem = (LineItem) order.getLineItems().get(i);
            lineItem.setOrderId(order.getOrderId());
            sqlMapDaoTemplate.update("insertLineItem", lineItem);
        }

    }

}