📄 usermerchandise.jsp
字号:
<%@ page contentType="text/html; charset=GBK" %>
<%@ include file="checkAdmin.jsp" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql" %>
<html>
<head>
<title>
userMerchandise
</title>
</head>
<body bgcolor="#ffffff">
<center>
<h1>
问价商品一览
</h1>
<form method="post" action="mistumoriList.jsp">
<c:choose>
<c:when test="${empty requestScope.count}">
<sql:setDataSource driver="sun.jdbc.odbc.JdbcOdbcDriver" url="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=C:\\MyData.mdb" var="db" scope="page"/>
<table border="1">
<tr>
<th>编号</th>
<th>厂家</th>
<th>商品名字</th>
<th>状态</th>
<th>数量</th>
<th>日期</th>
<th>单价</th>
<th>总价</th>
</tr>
<sql:query var="mList" dataSource="${db}">select * from merchandise where adminId=${sessionScope.admin.adminId} and userId=${param.userId}</sql:query>
<c:forEach var="m" items="${mList.rows}">
<tr>
<td>${m.merchandiseId}</td>
<sql:query var="factory" dataSource="${db}">select * from factory where factoryId=${m.factoryId}</sql:query>
<c:forEach var="f" items="${factory.rows}">
<td>${f.display}</td>
</c:forEach>
<td>${m.merchandiseName}</td>
<td><c:choose><c:when test="${m.merchandisePrice==0}">未答复</c:when><c:otherwise>以答复</c:otherwise></c:choose></td>
<td>${m.merchandiseCount}</td>
<td>
<script type="" language="javascript">
var time='${m.merchandiseTime}';
document.write(time.substring(0,4)+"-"+time.substring(4,6)+"-"+time.substring(6,8)+" "+time.substring(8,10)+":"+time.substring(10,12)+":"+time.substring(12,14));
</script>
</td>
<td><c:choose><c:when test="${m.merchandisePrice==0}">未定</c:when><c:otherwise>${m.merchandisePrice}元</c:otherwise></c:choose></td>
<td><c:choose><c:when test="${m.merchandisePrice==0}">未定</c:when><c:otherwise>${m.merchandisePrice*m.merchandiseCount}元 以定</c:otherwise></c:choose></td>
</tr>
</c:forEach>
</table>
</c:when>
<c:otherwise>
没有询问过商品
</c:otherwise>
</c:choose>
</form>
</center>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -