📄 add_product_ok.asp
字号:
<%@ language="vbscript"%>
<%response.Expires = 0%>
<!--#include file="conn.asp"-->
<%
set rs=server.createobject("adodb.recordset")
sqltext="select * from Product where Product_name='" & request.form("p_name") & "'"
rs.open sqltext,conn,1,1
'查找数据库，检查商品是否已经存在
if rs.recordcount >= 1 then
if rs("Product_name")=request.form("p_name") then
Response.Redirect "messagebox.asp?msg=此商品已经存在，请添加其他商品!"
response.end
rs.close
end if
end if
set rs=server.createobject("adodb.recordset")
sqltext="select * from Product"
rs.open sqltext,conn,3,3
'添加一个商品到数据库
rs.addnew
rs("Class_2")=request.form("class_2_name")
rs("Product_Id")= "1" & zeros(5 -len(rs.recordcount+1)) & (rs.recordcount+1)
rs("Class_1")=request.form("class_1_name")
rs("Product_name")=request.form("p_name")
rs("Product_intro")=request.form("p_intro")
rs("Product_show")=request.form("p_show")
rs("P_newprice")=request.form("newprice")
rs("P_oldprice")=request.form("oldprice")
rs("P_pic")=request.form("p_pic")
rs("P_Full_pic")=request.form("p_full_pic")
rs.update
%>
<script language=vbscript runat=server>
'zeros 函数产生一定数量的零
function zeros(intnum)
dim i,strout
for i=1 to intnum
strout = strout & "0"
next
zeros=strout
end function
</script>
<%
set rs_detail=server.createobject("adodb.recordset")
sqltext2="select * from Product where Product_name='" & request.form("p_name") & "'"
rs_detail.open sqltext2,conn,1,1
%>
<html>
<head>
<title>商品添加成功</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../style.css" rel="stylesheet" type="text/css">
</head>
<body text="#000000">
<p align="center"><br>
<br>
</p>
<div align="center">
<center>
<TABLE cellSpacing=1 cellPadding=5 width=429 bgColor=#5A8BCE height="144">
<TBODY>
<TR vAlign=top bgColor=#8CAAE7>
<TD class=main1 colSpan=2 width="415" height="10"></TD>
</TR>
<TR vAlign=top bgColor=#BECFF1>
<TD class=main1 colSpan=2 width="415" height="32"><font color="#FF0000">商品添加成功</font></TD>
</TR>
<TR bgColor=#BECFF1>
<TD class=main1 width=102 bgColor=#BECFF1 height=25 align="right"><SPAN
class=main1>所属大类：</SPAN></TD>
<TD class=main1 width=301 height=25><%=rs_detail("class_1")%></TD></TR>
<tr>
<TD class=main1 width=102 bgColor=#BECFF1 height=25 align="right"><SPAN
class=main1>所属小类：</SPAN></TD>
<TD class=main1 width=301 height=25 bgcolor="#BECFF1"><%=rs_detail("class_2")%></TD>
</tr>
<tr>
<TD class=main1 width=102 bgColor=#BECFF1 height=25 align="right"><SPAN
class=main1>产品名称：</SPAN></TD>
<TD class=main1 width=301 height=25 bgcolor="#BECFF1"><%=rs_detail("product_name")%></TD>
</tr>
<tr>
<TD class=main1 width=102 bgColor=#BECFF1 height=25 align="right"><SPAN
class=main1>会员价：</SPAN></TD>
<TD class=main1 width=301 height=25 bgcolor="#BECFF1"><%=rs_detail("p_newprice")%> （元）</TD>
</tr>
<tr>
<TD class=main1 width=102 bgColor=#BECFF1 height=25 align="right"><SPAN
class=main1>市场价：</SPAN></TD>
<TD class=main1 width=301 height=25 bgcolor="#BECFF1"><%=rs_detail("p_oldprice")%> （元）</TD>
</tr>
<tr>
<TD class=main1 width=102 bgColor=#BECFF1 height=25 align="right"><SPAN
class=main1>产品简介：</SPAN></TD>
<TD class=main1 width=301 height=25 bgcolor="#BECFF1"><%=rs_detail("product_intro")%></TD>
</tr>
<tr>
<TD class=main1 width=102 bgColor=#BECFF1 height=25 align="right"><SPAN
class=main1>产品说明：</SPAN></TD>
<TD class=main1 width=301 height=25 bgcolor="#BECFF1"><%=rs_detail("product_show")%></TD>
</tr>
<tr>
<TD class=main1 width=102 bgColor=#BECFF1 height=25 align="right"><SPAN
class=main1>产品缩微图片：</SPAN></TD>
<TD class=main1 width=301 height=25 bgcolor="#BECFF1"><%=rs_detail("p_pic")%></TD>
</tr>
<tr>
<TD class=main1 width=102 bgColor=#BECFF1 height=25 align="right"><SPAN
class=main1>产品全景图片：</SPAN></TD>
<TD class=main1 width=301 height=25 bgcolor="#BECFF1"><%=rs_detail("p_full_pic")%></TD>
</tr>
<TR vAlign=top bgColor=#BECFF1>
<TD class=main1 colSpan=2 width="415" height="15"></TD></TR>
<TR bgColor=#BECFF1>
<TD class=main1 colSpan=2 width="415" height="27">
<p align="center">
<INPUT type="button" class=smallInput size=3 value='添加下一个' name=Submit2 onclick="window.location.href='add_product.asp';">
</TD></TR>
<TR bgColor=#8CAAE7>
<TD class=main1 colSpan=2 width="415" height="4"></TD>
</TR></TBODY></TABLE>
</center>
</div>
</body>
</html>
<%
rs.close
rs_detail.close
conn.close
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -