www.gusucode.com > asp+SQLServer网上书店系统设计(源代码+论文) > asp+SQLServer网上书店系统设计(源代码+论文)\网上书店asp+SQLServer\网上书店\admin\add_book1.asp
<%@ language="vbscript"%>
<%response.Expires = 0%>
<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>
<!--#include file="conn.asp"-->
<%
set rs3=server.createobject("adodb.recordset")
sqltext="select * from book where book_name='" & request.form("book_name") & "'"
rs3.open sqltext,cn,1,1
'查找数据库，检查商品是否已经存在
if rs3.eof then
set rs1=server.createobject("adodb.recordset")
sqltext="select * from book"
rs1.open sqltext,cn,1,1
for i=1 to rs1.recordcount-1
rs1.movenext
next
set rs=server.createobject("adodb.recordset")
sqltext="select * from book"
rs.open sqltext,cn,3,3
'添加一个商品到数据库
rs.addnew
rs("ID")=rs1("ID")+1
rs("book_sort1")=request.form("sort1")
rs("book_sort2")=request.form("sort2")
rs("book_name")=request.form("book_name")
rs("book_explanation")=request.form("book_intro")
rs("book_price1")=request.form("book_price1")
rs("book_price2")=request.form("book_price2")
rs("book_pic1")=request.form("book_pic1")
rs("book_pic2")=request.form("book_pic2")
rs("author")=request.form("author")
rs("publicing_company")=request.form("pub_company")
rs("book_date")=year(now())&"-"&month(now())&"-"&day(now())
rs("language")=request.form("language")
rs("publicing_date")=request.form("pub_date")
rs("book_count")=request.form("num")
rs("look_count")=cint(0)
rs.update
rs.close
rs1.close
%>
<%
set rs2=server.createobject("adodb.recordset")
sqltext2="select * from book where book_name='" & request.form("book_name") & "'"
rs2.open sqltext2,cn,1,1
%>
<html>
<head>
<title>书籍添加成功</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<STYLE type=text/css>.main {
FONT-SIZE: 12px
}
.main1 {
FONT-SIZE: 14px
}
.main2 {
FONT-SIZE: 16px
}
.main3 {
FONT-SIZE: 7px
}
.main4 {
FONT-SIZE: 10px
}
A:link {
COLOR: #ffffff; TEXT-DECORATION: none
}
A:visited {
COLOR: #ffffff; TEXT-DECORATION: none
}
A:active {
COLOR: #ff0000; TEXT-DECORATION: none
}
A:hover {
COLOR: #aa0000; TEXT-DECORATION: underline
}
</STYLE>
</head>
<body text="#000000" bgcolor="#e6e4f1">
<p align="center"><br>
<br>
</p>
<div align="center">
<center>
<TABLE cellSpacing=1 cellPadding=4 width=429 bgColor=#000000 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><%=rs2("book_sort1")%></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"><%=rs2("book_sort2")%></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"><%=rs2("book_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"><%=rs2("author")%></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"><%=rs2("publicing_company")%></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"><%=rs2("publicing_date")%></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"><%=rs2("book_count")%></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"><%=rs2("book_price2")%> （元）</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"><%=rs2("book_price1")%> （元）</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"><%=rs2("book_explanation")%></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"><%=rs2("book_pic2")%></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"><%=rs2("book_pic1")%></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" value="返回" name="B4" onclick="javascript:window.history.go(-2)">
<INPUT type="button" class=main value='添加下一个' name=Submit2 onclick="window.location.href='add_book.asp';">
</TD></TR>
<TR bgColor=#8CAAE7>
<TD class=main1 colSpan=2 width="415" height="4"></TD>
</TR></TBODY></TABLE>
</center>
</div>
</body>
</html>
<%
else
Response.Redirect "messagebox.asp?msg=此书已经存在，请添加其他书刊号!"
response.end
rs3.close
end if
rs2.close
cn.close
%>