一个简单网上书城的例子（九）！

作者：袖梨 2022-07-02

buyfinish.asp:完成一次交易！记录客户信息！
Name=Request("Customer_N")
Tel=Request("Customer_T")
Address=Request("Customer_A")
ProductID=Request("Customer_P")
ProductName=Request("Customer_PN")
Quatity=Request("Customer_Q")
Sum=Request("Customer_S")
Session("ProductList")=""
%>





顾客购物信息：



姓名：

电话：

住址：

     ProductNames = Split(ProductName, "/")
     Quatities = Split(Quatity,"/") %>
     书刊编号__书刊名称 (数量)

     
     __ ()


书刊总价：


上述购物清单已提交服务台办理。多谢惠顾！



sql = "Insert into BuyInfomation (Name,Tel,Address,ProductID,Quatity,Sum) "
sql = sql & " Values ( '"+Name+"','"+Tel+"','"+Address+"','"+ProductID+"','"+Quatity+"','"+Sum+"')"
DbPath = SERVER.MapPath("ShopBag.mdb")
Set conn = Server.CreateObject("ADODB.Connection")
conn.open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DbPath
Set rs = conn.Execute( sql )
Set conn=nothing
%>

相关文章

精彩推荐