costmerlist.jsp
来自「中间商系统 1 数据库 Access2000 2 版本 jsp2.0+s」· JSP 代码 · 共 35 行
JSP
35 行
<%@ 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>
<body>
<center>
<h1>
客户一览
<br />
<a href="/Web/admin/costmerList.jsp">问价客户</a> <a href="/Web/admin/costmerList.jsp?action=1">订单客户</a>
</h1>
<form method="post" action="/Web/mvcostmerinfo">
<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="user" dataSource="${db}">select DISTINCT userId from ${param.action==1?"orderform":"merchandise"} where adminId=${sessionScope.admin.adminId}</sql:query>
<c:forEach var="uu" items="${user.rows}">
<sql:query var="users" dataSource="${db}">select * from Users where userId=${uu.userId}</sql:query>
<table border="1" width="1000">
<c:forEach var="u" items="${users.rows}">
<tr>
<td>用户ID:${u.userId}<input type="hidden" name="userId" value="${u.userId}"/></td>
<td>用户名:${u.userName}</td>
<td>用户Mail:${u.userMail}</td>
<td>用户电话:${u.userPhone}</td>
<td>用户地址:${u.userAddress}</td>
<td>${param.action==1?"<a href='/Web/admin/userOrderForm.jsp?userId=":"<a href='/Web/admin/userMerchandise.jsp?userId="}${u.userId}'>察看明晰</a></td>
</tr>
</c:forEach>
</table>
</c:forEach>
</form>
</center>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?