KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > org > springframework > samples > jpetstore > dao > ibatis > MsSqlOrderDao


1 package org.springframework.samples.jpetstore.dao.ibatis;
2
3 import org.springframework.dao.DataAccessException;
4 import org.springframework.samples.jpetstore.domain.LineItem;
5 import org.springframework.samples.jpetstore.domain.Order;
6
7 public class MsSqlOrderDao extends SqlMapOrderDao {
8
9   /**
10    * Whacked out MS SQL Server hack to allow Item ID to be retrieved so
11    * that we can use it to link the foreign key of the Line Items!
12    */
13   public void insertOrder(Order order) throws DataAccessException {
14     Integer JavaDoc orderId = (Integer JavaDoc) getSqlMapClientTemplate().queryForObject("msSqlServerInsertOrder", order);
15     order.setOrderId(orderId.intValue());
16     getSqlMapClientTemplate().insert("insertOrderStatus", order);
17     for (int i = 0; i < order.getLineItems().size(); i++) {
18       LineItem lineItem = (LineItem) order.getLineItems().get(i);
19       lineItem.setOrderId(order.getOrderId());
20       getSqlMapClientTemplate().insert("insertLineItem", lineItem);
21     }
22   }
23   
24 }
25
Popular Tags