indata.asp

用ASP编写的网上购书系统,数据库部分用SQL编写

<% @ language="vbscript"%>
<%
dim db3
dim sqlin
sqlin="insert into book (书号,书名,作者,定价) values ('" & request.form("sno") & "'" &",'" & request.form("sname") & "'"&",'" & request.form("author") & "'"&","& request.form("price")&")"
set db3=server.createobject("adodb.connection")
db3.open "PROVIDER=MICROSOFT.JET.OLEDB.4.0; DATA SOURCE= " & server.mappath("\bookstore\book.mdb")
db3.execute sqlin
response.redirect("insert.asp")
%>