<%@ page contentType="text/html; charset=gb2312" language="java" errorPage="../../error.jsp" %>
<%@ taglib prefix="myfun" uri="http://hellking.com/function"%>

<%@ include file="../../jstl.inc"%>
	<sql:query var="query" dataSource="${jspdev}" sql="SELECT product.productId as productId,product.name 
	as name,product.descn as descn,item.listPrice as listPrice,item.unitCost as unitPrice,item.supplier  as supplier ,item.itemid as itemid,item.attr1 as attr1,inventory.qty  as qty FROM product as product,item as item,inventory as inventory where product.productId='${param.productId}' and inventory.itemid=item.itemid"/>   
	
	<c:forEach var="row" items="${query.rows}">
		<c:set value="${row.productId}" var="productId"/>
		<c:set value="${row.name}" var="name"  />
		<c:set value="${row.descn}" var="descn"  />
		<c:set value="${row.listPrice}" var="listPrice"  />
		<c:set value="${row.unitPrice}" var="unitPrice"  />
		<c:set value="${row.supplier}" var="supplier"  />
		<c:set value="${row.itemid}" var="isbn"  />
		<c:set value="${row.qty}" var="qty"  />
		<c:set value="${row.attr1}" var="file"  />	
	</c:forEach>
	  <c:import url="ProductForm.jsp">
		<c:param name="productId" value="${productId}" />
		<c:param name="name" value="${name}" />
		<c:param name="descn" value="${descn}" />
		<c:param name="listPrice" value="${listPrice}" />
		<c:param name="unitPrice" value="${unitPrice}" />
		<c:param name="supplier" value="${publisher}" />
		<c:param name="isbn" value="${itemid}"/>
		<c:param name="qty" value="${qty}" />
		<c:param name="file" value="${attr1}" />
		<c:param name="action" value="modifyProduct_do.jsp"/>
		<c:param name="type" value="hidden"/>				
	   </c:import>