📄 kaidou.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>
kaidou
</title>
</head>
<body bgcolor="#ffffff">
<center>
<h1>
回答问价
</h1>
<sql:setDataSource driver="sun.jdbc.odbc.JdbcOdbcDriver" url="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=C:\\MyData.mdb" var="db" scope="page"/>
<sql:query var="merchandise" dataSource="${db}">select * from merchandise where adminId=${sessionScope.admin.adminId} and merchandisePrice=0</sql:query>
<div>
<c:forEach var="m" items="${merchandise.rows}">
<form method="post" action="/Web/kaidou">
<table border="1" width="1000">
<tr>
<td>编号:
${m.merchandiseId}<input type="hidden" name="merchandiseId" value="${m.merchandiseId}"/></td>
<td>用户:
<sql:query var="user" dataSource="${db}">select * from Users where userId=${m.userId}</sql:query>
<c:forEach var="u" items="${user.rows}">${u.userName}</c:forEach></td>
<td>商品厂家:
<sql:query var="factory" dataSource="${db}">select * from factory where factoryId=${m.factoryId}</sql:query>
<c:forEach var="f" items="${factory.rows}">${f.display}</c:forEach></td>
<td>商品名称:${m.merchandiseName}</td>
<td>数量:${m.merchandiseCount}</td>
<td>价格:</td>
<td><input type="text" value="填写单价" name="merchandisePrice"/></td>
<td><input type="submit" value="提交" /></td>
</tr>
</table>
</form>
</c:forEach>
</div>
</center>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -