releaseprodconform.jsp

来自「jsp做的购物网站」· JSP 代码 · 共 37 行

JSP
37
字号
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<jsp:useBean id="user" scope="session" class="jspD.User"/>
<jsp:useBean id="DBLink" class="jspD.DBLink" />

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>发布商品</title>
</head>
<center>
<body>
<%@ include file="../Main.jsp"%>

<%
	String sql;
	if(request.getParameter("action").equals("release")){//,maxQuantity//","+request.getParameter("maxQuantity")+
		sql="INSERT INTO product(pName,producer,price,maxQuantity,busiEmail) VALUES('"+request.getParameter("pName")+"','"+user.getName()+"',"+request.getParameter("price")+","+request.getParameter("maxQuantity")+",'"+user.getEmail()+"')";
		
	}
	else{
		sql="UPDATE product SET pName='"+request.getParameter("pName")+"',producer='"+user.getName()+"',price="+request.getParameter("price")+",maxQuantity="+request.getParameter("maxQuantity")+" WHERE ID="+request.getParameter("ID");
		}
	
	if(!DBLink.executeUpdate(sql))
		out.print("数据库连接错误!<a href='business.jsp'>返回</a>");
	else{
		out.print("<p><b>产品发布!</b> </p> ");
		out.print("<p><a href='releaseProduct.jsp'>继续发布新产品</a></p> ");
		out.print("<p><a href='browseMyProduct.jsp'>返回浏览界面</a></p>");
		out.print("<a href='business.jsp'>返回管理界面</a>");
	}
%>
</body>
</center>
</html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?