📄 feedback.jsp

📁 中间商系统 1 数据库 Access2000 2 版本 jsp2.0+servlet2.4+jstl1.1+Tomcat5.5.9+JDK1.5 3 IDE工具 JBuilder2006

💻 JSP

字号:

<%@ page contentType="text/html; charset=GBK" %>
<%@ 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>
feedback
</title>
</head>
<body bgcolor="#ffffff">
<center>
<h1>
用户反馈
</h1>
<form method="post" action="feedback.jsp">
<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="reason" dataSource="${db}">select * from reason where adminId=${sessionScope.admin.adminId}</sql:query>
<table border="1">
<c:forEach var="r" items="${reason.rows}">
<tr>
<sql:query var="user" dataSource="${db}">select * from Users where userId=${r.userId}</sql:query>
<td>客户姓名:<c:forEach var="u" items="${user.rows}">${u.userName}</c:forEach></td>
<sql:query var="merchandise" dataSource="${db}">select * from merchandise where merchandiseId=${r.merchandiseId}</sql:query>
<td>商品名子:<c:forEach var="m" items="${merchandise.rows}">${m.merchandiseName}</c:forEach></td>
<sql:query var="reasonType" dataSource="${db}">select * from reasonType where reasonTypeId=${r.reasonTypeId}</sql:query>
<td>反馈信息:<c:forEach var="re" items="${reasonType.rows}">${re.display}</c:forEach></td>
<td>日期:
  <script type="" language="javascript">
    var time='${r.reasonTime}';
     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>
</tr>
</c:forEach>
</table>
</form>
</center>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -