JPetStore 분석 2 - iBatis

Product ID가 빠졌다.

catalog/Product.jsp
13번째 라인에서 item#productId 임.

1. item 을 product 로 변경한다.
<div id="Catalog"> <h2><bean:write name="product" property="name"/></h2> <table> <tr><th>Item ID</th> <th>Product ID</th> <th>Description</th> <th>List Price</th> <th> </th></tr> <logic:iterate id="item" name="itemList"> <tr> <td> <html:link paramId="itemId" paramName="item" paramProperty="itemId" page="/shop/viewItem.shtml"> <bean:write name="item" property="itemId"/></html:link></td> <td><bean:write name="item" property="productId"/></td> <td> <bean:write name="item" property="attribute1"/> <bean:write name="item" property="attribute2"/> <bean:write name="item" property="attribute3"/> <bean:write name="item" property="attribute4"/> <bean:write name="item" property="attribute5"/> <bean:write name="product" property="name"/> </td> <td><bean:write name="item" property="listPrice" format="$#,##0.00"/></td> <td><html:link styleClass="Button" paramId="workingItemId" paramName="item" paramProperty="itemId" page="/shop/addItemToCart.shtml"> Add to Cart</html:link></td> </tr> </logic:iterate> <tr><td> <logic:notEqual name="itemList" property="firstPage" value="true"> <a class="Button" href="switchItemListPage.shtml?pageDirection=previous"><< Prev</a> </logic:notEqual> <logic:notEqual name="itemList" property="lastPage" value="true"> <a class="Button" href="switchItemListPage.shtml?pageDirection=next">Next >></a> </logic:notEqual> </td></tr> </table> </div>
Item.xml
product#productId 에는 들어가는데 item#productId 에는 들어가지 않는다.

2. 쿼리에 productId 를 추가한다.
<select id="getItemListByProduct" resultClass="item" parameterClass="string" cacheModel="itemCache"> SELECT ITEMID, LISTPRICE, UNITCOST, SUPPLIER AS supplierId, I.PRODUCTID AS "product.productId", /* I.PRODUCTID, */ NAME AS "product.name", DESCN AS "product.description", CATEGORY AS "product.categoryId", STATUS, ATTR1 AS attribute1, ATTR2 AS attribute2, ATTR3 AS attribute3, ATTR4 AS attribute4, ATTR5 AS attribute5 FROM ITEM I, PRODUCT P WHERE P.PRODUCTID = I.PRODUCTID AND I.PRODUCTID = #value# </select>
iBatis에서 주석은 -- 대신 /* */ 를 사용할 것.