View Javadoc

    1   /*
    2    * Licensed to the Apache Software Foundation (ASF) under one or more
    3    * contributor license agreements.  See the NOTICE file distributed with
    4    * this work for additional information regarding copyright ownership.
    5    * The ASF licenses this file to You under the Apache License, Version 2.0
    6    * (the "License"); you may not use this file except in compliance with
    7    * the License.  You may obtain a copy of the License at
    8    *
    9    *      http://www.apache.org/licenses/LICENSE-2.0
    10   *
    11   * Unless required by applicable law or agreed to in writing, software
    12   * distributed under the License is distributed on an "AS IS" BASIS,
    13   * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
    14   * See the License for the specific language governing permissions and
    15   * limitations under the License.
    16   */
    17  /***
    18   * User: Clinton Begin
    19   * Date: Jul 13, 2003
    20   * Time: 7:20:47 PM
    21   */
    22  package com.ibatis.jpetstore.persistence.sqlmapdao;
    23
    24  import com.ibatis.dao.client.DaoManager;
    25  import com.ibatis.jpetstore.domain.LineItem;
    26  import com.ibatis.jpetstore.domain.Order;
    27  import com.ibatis.jpetstore.persistence.iface.OrderDao;
    28  import com.ibatis.common.util.PaginatedList;
    29
    30  public class OrderSqlMapDao extends BaseSqlMapDao implements OrderDao {
    31
    32    public OrderSqlMapDao(DaoManager daoManager) {
    33      super(daoManager);
    34    }
    35
    36    public PaginatedList getOrdersByUsername(String username) {
    37      return queryForPaginatedList("getOrdersByUsername", username, 10);
    38    }
    39
    40    public Order getOrder(int orderId) {
    41      Order order = null;
    42      Object parameterObject = new Integer(orderId);
    43      order = (Order) queryForObject("getOrder", parameterObject);
    44      order.setLineItems(queryForList("getLineItemsByOrderId", new Integer(order.getOrderId())));
    45      return order;
    46    }
    47
    48    public void insertOrder(Order order) {
    49      update("insertOrder", order);
    50      update("insertOrderStatus", order);
    51      for (int i = 0; i < order.getLineItems().size(); i++) {
    52        LineItem lineItem = (LineItem) order.getLineItems().get(i);
    53        lineItem.setOrderId(order.getOrderId());
    54        update("insertLineItem", lineItem);
    55      }
    56
    57    }
    58
    59  }