?? viewproduct.jsp
字號:
<%@ page language="java" errorPage="../../error.jsp" %>
<%@ include file="../../jstl.inc"%>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<LINK href="../../hellking.css" type=text/css rel=stylesheet>
</head>
<body>
<center>
<table align="center" bgcolor="#008800" border="0" cellspacing="2" cellpadding="5" width=80%>
<tr bgcolor="#cccccc">
<td><b>名稱</b></td>
<td><b>內容 </b></td>
</tr>
<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 and product.productId=item.productId"/>
<c:forEach var="row" items="${query.rows}">
<tr bgcolor="#cc99cc"> <td>產品ID</td><td>
${row.productId}</td></tr>
<tr bgcolor="#cccccc"> <td>名稱</td><td>
${row.name}</td></tr>
<tr bgcolor="#cc99cc"> <td>價格</td><td>
${row.listPrice}</td></tr>
<tr bgcolor="#cccccc"> <td>會員價格</td><td>
${row.unitPrice}</td></tr>
<tr bgcolor="#cc99cc"> <td>出版社</td><td>
${row.supplier}</td></tr>
<tr bgcolor="#cccccc"> <td>isbn</td><td>
${row.itemid}</td></tr>
<tr bgcolor="#cc99cc"> <td>庫存</td><td>
${row.qty}</td></tr>
<tr bgcolor="#cccccc"> <td>其它屬性</td><td>
${row.attr1} </td></tr>
<tr bgcolor="#cc99cc"> <td>描述</td><td>
${row.descn} </td></tr>
</c:forEach>
</table>
</center>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -