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  }