modifyproduct.jsp

《电子商店管理系统》——采用JSP、Servlet和JavaBean开发,实现了商品管理、 商品分类、订单处理、会员管理等功能

<%@ 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>