📄 add.jsp
字号:
<%@ page import="java.util.Iterator.*" contentType="text/html;charset=gb2312" %>
<!--
errorPage="WEB-INF/error.jsp" contentType="text/html;charset=gb2312"%>
-->
<%@ taglib prefix="c" uri = "http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql" %>
<html>
<head>
<title>add friend **</title>
</head>
<body>
<jsp:include page="header.jsp" />
<sql:setDataSource driver="sun.jdbc.odbc.JdbcOdbcDriver" url="jdbc:odbc:test" var="mydb" />
<sql:query sql = "select * from user" var="myuser" dataSource="${mydb}" />
<c:forEach var="user" items="${myuser.rows}">
<c:if test = "${user.admin == 1 and sessionScope.ID eq user.id}">
<c:set var = "admin" value = "yes" />
</c:if>
</c:forEach>
<c:if test = "${admin eq 'yes'}">
<h2>您好，管理员：<font color = "#555fff">${sessionScope.Username}</font>。请添加图书信息:</h2>
<form name="friend" method="post" action="add.jsp">
书 名:
<input type="text" name="name" size="15">
<br>
作 者:
<input type="text" name="sex" size="15">
<br>
出版商:
<input type="text" name="qq" size="15">
<br>
类 别:
<input type="text" name="email" size="15">
<br>
卖家联系电话:
<input type="text" name="tel" size="15">
<br>
<p>
<input type="submit" value="提交"> <input type="reset" value="重置">
</form>
<c:if test="${param.name ne null}">
<sql:update var="count" dataSource="${mydb}">
insert into classmates (name,sex,qq,tel,email,sign) values (?,?,?,?,?,?)
<sql:param value = "${param.name}" />
<sql:param value = "${param.sex}" />
<sql:param value = "${param.qq}" />
<sql:param value = "${param.tel}" />
<sql:param value = "${param.email}" />
<sql:param value = "${sessionScope.ID}" />
</sql:update>
<c:out value="Add into th database successfully!"/>
</c:if>
</c:if>
<c:if test = "${admin ne 'yes'}"><br><br>
<p><font color = "red" size = "12px"><c:out value=" 对不起，您不是管理员，在本网页没有访问权限!"/></font>
</c:if>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -