📄 savebook.asp
字号:
<%
'接收表单数据
isbn=request.form("T1")
bookname=request.form("T2")
pressname=request.form("T3")
price=request.form("T4")
authorname=request.form("T5")
dim conn
set conn=server.createobject("ADODB.connection")
conn.open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE="&server.mappath("DB.MDB")
sqlstr="insert into book(isbn,bookname,pressname,price,authorname) values ('"&isbn&"','"&bookname&"','"&pressname&"',"&price&",'"&authorname&"')"
'response.write sqlstr
'response.end
conn.execute sqlstr
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>保存资料</title>
</head>
<body>
<p><a href="index.htm">首页</a>|
<a href="addnewbook.htm">添加</a>|
<a href="editbook.htm">修改</a>|
<a href="deletebook.htm">删除</a>|
<a href="chaxun.htm">查询</a>
</p>
<div align="center">
<p><b>新书已经成功录入到数据库!!!</b></p>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -