managerpromotion.jsp
来自「里面包含了一个网上书店要的大致的文件。主要是现实前台的jsp页面。」· JSP 代码 · 共 57 行
JSP
57 行
<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %>
<%@ page import="com.iss.dataBase.SQLParser" %>
<%@ page import="java.util.*" %>
<%--
The taglib directive below imports the JSTL library. If you uncomment it,
you must also add the JSTL library to the project. The Add Library... action
on Libraries node in Projects view can be used to add the JSTL 1.1 library.
--%>
<%--
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
--%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body>
<%
String ISBN=(String)request.getParameter("ISBN");
String discount=(String)request.getParameter("discount");
String duration=(String)request.getParameter("duration");
Statement stmt=SQLParser.getInstance().getStmt();
String sql="select * from promotion where ISBN = '"+ISBN+"'";
ResultSet rs=stmt.executeQuery(sql);
if(!(rs.next()))
{
sql="insert into promotion values ('"+ISBN+"',"+discount+",'"+duration+"')";
stmt.executeUpdate(sql);
}
else
{
sql="update promotion set discount ="+discount+","+"duration ='"+duration+ "' where ISBN = '"+ISBN+"'";
}
out.print("<html><head><title>编辑成功</title></head><body>成功编辑,请返回<a href='right.html'>原始主页</a></body></html>");
%>
<%--
This example uses JSTL, uncomment the taglib directive above.
To test, display the page like this: index.jsp?sayHello=true&name=Murphy
--%>
<%--
<c:if test="${param.sayHello}">
<!-- Let's welcome the user ${param.name} -->
Hello ${param.name}!
</c:if>
--%>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?