📄 writecp.asp
字号:
<%@ language="vbscript" %>
<!--#include file="..\adovbs.inc"-->
<% response.buffer=true
class1=request("class1")
class2=request("class2")
pp=request("pp")
picture=trim(request("picture"))
if picture="" then picture="No"
yhj=formatnumber(ccur(request("jg"))*cint(request("dz"))/100,2)
DbPath = SERVER.MapPath("..\bookshop.mdb")
Set conn = Server.CreateObject("ADODB.Connection")
conn.open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DbPath
sm=replace(request("sm"),"'","''")
sqltext="insert into book (baseclass,childclass,bookname,cd,size,publish,picture,info,dw,price,yhj,Author,dz,Num,inputtime) values('"&request("class1")&"','"& class2 &"','"&request("cpmc")&"','"&request("cd")&"','"&request("pp")&"','"&request("cj")&"','"&picture&"','"& sm &"','"&request("dw")&"','"&ccur(request("jg"))&"','"&yhj&"','"&request("Author")&"','"&cint(request("dz"))&"','1',now )"
conn.execute(sqltext)
set rs=server.createobject("adodb.recordset")
sql="select bookid from book order by inputtime desc"
rs.open sql,conn,adOpenkeyset,adlockoptimistic,adcmdtext
bm=rs("bookid")
rs.close
'response.write bm
'response.end
sqlupdate="update book set bookbm=bookid "
conn.execute sqlupdate
conn.close
set conn=nothing
response.flush
%>
<html>
<head>
<title>
</title>
</head>
<body>
<p align="left">数据提交成功</p>
<a href="cpfb.asp">返回</a>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -