FileDocCategorySizeDatePackage
SqlMapItemDao.javaAPI DocExample1844Sat Dec 27 17:31:38 GMT 2003org.springframework.samples.jpetstore.dao.ibatis

SqlMapItemDao

public class SqlMapItemDao extends org.springframework.orm.ibatis.support.SqlMapDaoSupport implements org.springframework.samples.jpetstore.dao.ItemDao

Fields Summary
Constructors Summary
Methods Summary
public org.springframework.samples.jpetstore.domain.ItemgetItem(java.lang.String itemId)

    Item item = (Item) getSqlMapTemplate().executeQueryForObject("getItem", itemId);
		if (item != null) {
			Integer qty = (Integer) getSqlMapTemplate().executeQueryForObject("getInventoryQuantity", itemId);
			item.setQuantity(qty.intValue());
		}
    return item;
public java.util.ListgetItemListByProduct(java.lang.String productId)

    return getSqlMapTemplate().executeQueryForList("getItemListByProduct", productId);
public booleanisItemInStock(java.lang.String itemId)

    Integer i = (Integer) getSqlMapTemplate().executeQueryForObject("getInventoryQuantity", itemId);
    return (i != null && i.intValue() > 0);
public voidupdateQuantity(org.springframework.samples.jpetstore.domain.Order order)

    for (int i = 0; i < order.getLineItems().size(); i++) {
      LineItem lineItem = (LineItem) order.getLineItems().get(i);
      String itemId = lineItem.getItemId();
      Integer increment = new Integer(lineItem.getQuantity());
      Map param = new HashMap(2);
      param.put("itemId", itemId);
      param.put("increment", increment);
      getSqlMapTemplate().executeUpdate("updateInventoryQuantity", param);
    }