📄 inquiresupp.asp

📁 一个购物网站
💻 ASP
字号:
<%
Scode=trim(request.form("txtSupplierID"))
if scode<>"" then
  set con=Server.CreateObject("ADODB.Connection")
  con.open "PROVIDER=SQLOLEDB;DATA SOURCE=210.34.136.243;UID=user37;PWD=;DATABASE=project0104"
  set rs=Server.CreateObject("ADODB.Recordset")
 
  rs.open "select * from Supplier where cSupplierID='"&Scode&"'",con 
  if rs.eof then
     response.write "your have not rigster!"
     response.write "<a href=supp.htm>back</a>"
  else
     txtsupplierid = RS.Fields("cSupplierID")
     txtsuppliername = RS.Fields("vSupplierName")
     txtsupplieraddress = RS.Fields("vSupplierAddress")
     txtsuppliercity = RS.Fields("vSupplierCity")
     txtsupplierzipcode = RS.Fields("vSupplierZipCode")
     txtsupplieremail = RS.Fields("vEmailID")
     txtsupplierfaxnumber = RS.Fields("vFaxNumber") 
  end if
     con.close
  set RS = Nothing
  Set Con = Nothing
end if
%>


<html>
<head>
<title>Supplier Details </title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script language="JavaScript">
<!--
<!--
function MM_reloadPage(init) {  //reloads the window if Nav4 resized
  if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {
    document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
  else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
// -->

function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}

function MM_showHideLayers() { //v3.0
  var i,p,v,obj,args=MM_showHideLayers.arguments;
  for (i=0; i<(args.length-2); i+=3) if ((obj=MM_findObj(args[i]))!=null) { v=args[i+2];
    if (obj.style) { obj=obj.style; v=(v=='show')?'visible':(v='hide')?'hidden':v; }
    obj.visibility=v; }
}
//-->
</script>
</head>

<body bgcolor="#FFCC99" text="#000000"> 
<p onClick="MM_showHideLayers('Update','','show','Delete','','hide')">Update</p>
<p onClick="MM_showHideLayers('Update','','hide','Delete','','show')">Delete </p>
<div id="Update" style="position:absolute; width:471px; height:386px; z-index:1; visibility: hidden"> 
  <form name="form1" method="post" action="updatesupp.asp">
    Supplier ID: 
    <input type="text" name="txtsupplierid" value="<%=Server.HTMLEncode(txtsupplierid)%>" readonly> 
    <BR> 
    <BR> 
    Supplier Name: 
    <input type="text" name="txtsuppliername"  value="<%=Server.HTMLEncode(txtsuppliername)%>"> 
    <BR> 
    <BR> 
    Supplier Address: 
    <input type="text" name="txtsupplieraddress"  value="<%=Server.HTMLEncode(txtsupplieraddress)%>"> 
    <BR> 
    <BR> 
    Supplier City: 
    <input type="text" name="txtsuppliercity"  value="<%=Server.HTMLEncode(txtsuppliercity)%>"> 
    <BR> 
    <BR> 
    Supplier Zipcode: 
    <input type="text" name="txtsupplierzipcode"  value="<%=Server.HTMLEncode(txtsupplierzipcode)%>"> 
    <BR> 
    <BR> 
    Supplier Email: 
    <input type="text" name="txtsupplieremail"  value="<%=Server.HTMLEncode(txtsupplieremail)%>"> 
    <BR> 
    <BR> 
    Supplier FaxNumber: 
    <input type="text" name="txtsupplierfaxnumber"  value="<%=Server.HTMLEncode(txtsupplierfaxnumber)%>"> 
    <BR> 
    <BR> 
    <input type="submit" name="submit" value="Update"> 
  </form> 
</div> 
<div id="Delete" style="position:absolute; width:351px; height:310px; z-index:2; visibility: hidden">  
  <form method="POST" action="deletesupp.asp"> 
Supplier ID:<input type="text" name="txtsupplierid" value="<%=Server.HTMLEncode(txtsupplierid)%>" readonly><BR><BR> 
Supplier Name:<input type="text" name="txtsuppliername"  value="<%=Server.HTMLEncode(txtsuppliername)%>"><BR><BR> 
Supplier Address:<input type="text" name="txtsupplieraddress"  value="<%=Server.HTMLEncode(txtsupplieraddress)%>"><BR><BR> 
Supplier City:<input type="text" name="txtsuppliercity"  value="<%=Server.HTMLEncode(txtsuppliercity)%>"><BR><BR> 
Supplier Zipcode:<input type="text" name="txtsupplierzipcode"  value="<%=Server.HTMLEncode(txtsupplierzipcode)%>"><BR><BR> 
Supplier Email:<input type="text" name="txtsupplieremail"  value="<%=Server.HTMLEncode(txtsupplieremail)%>"><BR><BR> 
Supplier FaxNumber:<input type="text" name="txtsupplierfaxnumber"  value="<%=Server.HTMLEncode(txtsupplierfaxnumber)%>"><BR><BR> 
<input type="submit" name="submit" value="Delete"> 
</form> 
</div> 
</body>
 
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -