📄 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 + -