promodifysave.asp

《实例精粹ASP》中部分源代码

<!-- #include file = "include/sysbase.asp" -->
<%
  Dim strSQL, cmdObj, rsObj
  Dim nID, nProductType, nMemberPrice, nMarketPrice
  nID  =  RealString(Request.Form("id"))
  nProductType  =  Cint(Request.Form("ProductType"))
  nMemberPrice  =  Request.Form("memberPrice")
  nMarketPrice  =  Request.Form("marketPrice")
  if not IsNumeric(nMemberPrice) then nMemberPrice  =  "1"
  if not IsNumeric(nMarketPrice) then nMarketPrice  =  "1"
  
  'response.Write nid
  'response.End 

  Set cmdObj  =  Server.CreateObject("ADODB.Command")
  Set rsObj  =  Server.CreateObject("ADODB.RecordSet")
  cmdObj.CommandType  =  adCmdText
  cmdObj.CommandText  =  "SELECT top 1 * FROM product WHERE id = " & nID
  cmdObj.ActiveConnection  =  conn
  call rsObj.Open(cmdObj, , adOpenKeyset, adLockOptimistic)
  
  rsObj("ProductType")  =  Request.Form("ProductType")
  rsObj("name")  =  Request.Form("name")
  rsObj("memberPrice")  =  nMemberPrice
  rsObj("marketPrice")  =  nMarketPrice
  rsObj("introduce")  =  Request.Form("introduce")
  rsObj("remark")  =  Request.Form("remark")
  rsObj.Update()
  '	   Response.Write rsObj("id")
  '	   Response.End
  '	   rsObj.movelast

       rsObj.Close
	   
       set rsObj = nothing
       CloseConn()
%>
<script language = Javascript>
	<!--
	alert("修改成功！");
	window.location = "<%=Session("adminOldUrl")%>"
	-->
</script>