viewproductbycategory.jsp

来自「电子书店管理系统」· JSP 代码 · 共 9 行

<%@ page language="java" errorPage="../error.jsp" %>
<%@ include file="../jstl.inc"%>

<c:import url="Product.jsp">
<c:param name="sql" value="select product.productId as productId,product.name as name,item.listPrice as listPrice,item.unitCost as unitPrice,item.itemid as itemid,item.supplier  as publisher from product as product,item as item where product.category='${param.catid}' and product.productId=item.productId and item.status='1'"/>
</c:import>