数据库结构:
第一个库shopbag.mdb,两个表:
buyiformation表存客户信息如下:
Name,Tel,Address,ProductID,Quatity,Sum
第二个表products存商品信息:
CategoryID(商品分类号),productid,productname,descrition,
ischeck(用户是否选这一商品),price(单价)
下面试一个工具文件!util.asp
1
2Sub ListCategory( conn )
3
4Set rs = conn.Execute( "Category" )
5While Not rs.EOF
1<a =rs("categoryid")="" =server.urlencode(rs("description"))="" ```="" ```&description="```" href="buy.asp?CategoryID=```">
=rs("Description")
1</a>
1
2rs.MoveNext
3Wend
4End Sub
5
6Sub PutToShopBag( ProductID, ProductList )
7If Len(ProductList) = 0 Then
8ProductList = "'" & ProductID & "'"
9ElseIf InStr( ProductList, ProductID ) <= 0 Then
10ProductList = ProductList & ", '" & ProductID & "'"
11End If
12End Sub
13