<%
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=shopping.mdb"
Dim rs, sql
sql = "SELECT * FROM products"
Set rs = conn.Execute(sql)
Do While Not rs.EOF
%>
<%= rs("ProductID") %>
<%= rs("ProductName") %>
<%= rs("Price") %>
<%
rs.MoveNext
Loop
rs.Close
conn.Close
%>
购物车页面(cart.asp)
<%@ Language="VBScript" %>
商城 购物车
购物车
商品编号
商品名称
价格
数量
小计
操作
<%
Session.Contents.RemoveAll() ' 清空会话中的购物车内容
Dim ProductID, rs, conn, sql, TotalAmount
ProductID = Request.Form("ProductID")
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=shopping.mdb"
sql = "SELECT * FROM products WHERE ProductID=" & ProductID
Set rs = conn.Execute(sql)
If Not rs.EOF Then
If Not IsEmpty(Session("Cart")) Then
Session("Cart") = Session("Cart") & "|" & ProductID & ",1"
Else
Session("Cart") = ProductID & ",1"
End If
End If
rs.Close
conn.Close
%>
<%
Dim CartItems, Item, ProductDetails, SubTotal, Quantity, Price, ProductName
CartItems = Split(Session("Cart"), "|")
TotalAmount = 0
For Each Item In CartItems
If Item <> "" Then
Dim Details()
Details = Split(Item, ",")
ProductID = Trim(Details(0))
Quantity = CInt(Details(1))
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=shopping.mdb"
sql = "SELECT * FROM products WHERE ProductID=" & ProductID
Set rs = conn.Execute(sql)
If Not rs.EOF Then
ProductName = rs("ProductName")
Price = rs("Price")
SubTotal = Price * Quantity
Response.Write "