📄 updatebook.asp
字号:
<%response.buffer=true
response.expires=0
%>
<html>
<body bgcolor=black>
<%
bookkind=trim(request.form("bookkind"))
bookname=trim(request.form("bookname"))
bookdate=trim(request.form("bookdate"))
editer=trim(request.form("editer"))
bookpublish=trim(request.form("bookpublish"))
cost=trim(request.form("cost"))
bookcount=trim(request.form("bookcount"))
set cn=server.createobject("adodb.connection")
set rst=server.createobject("adodb.recordset")
rst.cursortype=3
rst.locktype=3
cn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("wsm.mdb")
strsql="select * from book where bookid='"&session("bookid")&"' "
rst.open strsql,cn
if not rst.eof then
rst("bookname")=bookname
rst("bookkind")=bookkind
rst("editer")=editer
rst("bookpublish")=bookpublish
rst("cost")=cost
rst("bookdate")=bookdate
rst("count")=bookcount
rst.update
response.write"<p align=center><font size=5 color=red>您已经成功的修改了此记录</font></p>"
response.write"<p align=center><font color=red><a href='管理员页面.htm'>返回主控制界面</a></font></p>"
end if
rst.close
cn.close
%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -