?? search_do.jsp
字號:
<%@ page language="java" errorPage="../error.jsp" %>
<%@ include file="../jstl.inc"%>
<c:choose>
<c:when test="${param.type eq '0'}">
<c:set var="sql" value="select product.productId as productId,item.itemid as itemid,product.name as name,item.listPrice as listPrice,item.unitCost as unitPrice,item.supplier as publisher from product as product,item as item where product.name like '%${param.key}%' and product.productId=item.productId and item.status='1'"/>
</c:when>
<c:when test="${param.type eq '1'}">
<c:set var="sql" value="select product.productId as productId,product.name as name,item.itemid as itemid,item.listPrice as listPrice,item.unitCost as unitPrice,item.supplier as publisher from product as product,item as item where item.supplier like '%${param.key}%' and product.productId=item.productId and item.status='1'"/>
</c:when>
<c:when test="${param.type eq '2'}">
<c:set var="sql" value="select product.productId as productId,product.name as name,item.itemid as itemid,item.listPrice as listPrice,item.unitCost as unitPrice,item.supplier as publisher from product as product,item as item where product.category in(select catid from category where name like '%${param.key}%') and product.productId=item.productId and item.status='1'"/>
</c:when>
</c:choose>
<c:import url="Product.jsp">
<c:param name="sql" value="${sql}"/>
</c:import>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -