日期:2014-02-24  浏览次数:20990 次

数据库字段
  表:pro_talbe:
  id 产品编号
  proname 产品名称
  simages 产品小图
  表o_rder:
  id 订单编号
  p_roid 产品编号
  m_um 产品数量
  d_time 订购时间
  表co_table:
  id 客户编号
  nn_ame 客户姓名
  tt_el 联系电话
  ee_m_ail 客户邮箱
  +++++++++++++++++++++++
  index.ASP源码
  +++++++++++++++++++++++
  
  <%@LANGUAGE="VBSCRIPT"%>
  <!--#include file="Connections/conn.asp" -->
  <%
  set Recordset1 = Server.CreateObject("ADODB.Recordset")
  Recordset1.ActiveConnection = MM_conn_STRING
  Recordset1.Source = "SELECT * FROM pro_table"
  Recordset1.CursorType = 0
  Recordset1.CursorLocation = 2
  Recordset1.LockType = 3
  Recordset1.Open()
  Recordset1_numRows = 0
  %>
  <%
  Dim Repeat1__numRows
  Repeat1__numRows = -1
  Dim Repeat1__index
  Repeat1__index = 0
  Recordset1_numRows = Recordset1_numRows + Repeat1__numRows
  %>
  <html>
  <head>
  <title>Untitled Document</title>
  <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
  <table width="583" border="0" cellspacing="0" cellpadding="0">
  <%
  While ((Repeat1__numRows <> 0) AND (NOT Recordset1.EOF))
  %>
  <tr>
  <td width="140"><%=(Recordset1.Fields.Item("id").Value)%></td>
  <td width="171"><%=(Recordset1.Fields.Item("proname").Value)%></td>
  <td width="272"><%=(Recordset1.Fields.Item("simages").Value)%></td>
  <td width="272"><a href="cart.asp?ProductID=<%=(Recordset1.Fields.Item("id").Value)%>&quantity=1">购买</a></td>
  </tr>
  <%
  Repeat1__index=Repeat1__index+1
  Repeat1__numRows=Repeat1__numRows-1
  Recordset1.MoveNext()
  Wend
  %>
  </table>
  </body>
  </html>
  <%
  Recordset1.Close()
  %>
  列出产品,这里有一个要点就是:<a href="cart.asp?ProductID=<%=(Recordset1.Fields.Item("id").Value)%>&quantity=1">购买</a>
  这里传递了两个参数:产品ID“ProductID" 数量:“quantity"
  
  +++++++++++++++++++++++++
  下面是cart.asp的源码:
  +++++++++++++++++++++
  
  <%@LANGUAGE="VBScript"%>
  <!--#include file="Connections/conn.asp" -->
  <%
  if not IsObject(session("cart")) then
  Set session("cart")=CreateObject("Scripting.Dictionary")
  end if
  Set cart=session("cart")
  productID=Cstr(request("productID"))
  dim detail(1)
  detail(0)=Int(request("quantity"))
  if request("productID")<>"" then
  if cart.Exists(productID) then
  cart.Remove(productID)
  end if
  cart.add productID,detail
  end if
  keys=cart.keys
  items=cart.items
  set session("cart")=cart
  %>
 &n