displaystock.asp

来自「javascript source code part1」· ASP 代码 · 共 49 行

ASP
49 行
字号 
<%@ LANGUAGE = JavaScript%>
<HTML>
<BODY>
<TABLE BORDER=1>
<THEAD>
   <TR>
   <TH>Product</TH>
   <TH>Quantity In Stock</TH>
   <TH>Cost per Item</TH>
   <TH></TH>
   </TR>
</THEAD>

<%
// Open connection to database, then populate a recordset with list of stock
   var adoConnection = Server.CreateObject("ADODB.Connection");
   var adoRecordSet;
   var mySQL;
   adoConnection.Open("DSN=CompBitsCoDB");
   var mySQL = "SELECT StockId, ItemDescription, NumberInStock, ItemCost" + 
      " FROM Stock";
   adoRecordSet = adoConnection.Execute(mySQL);

// Loop through recordset and write stock details out to page
   while ( adoRecordSet.Eof == false )
   {
%>
<TR>
   <TD><%=adoRecordSet("ItemDescription").Value%></TD>
   <TD><%=adoRecordSet("NumberInStock").Value%></TD>
   <TD><%=adoRecordSet("ItemCost").Value%></TD>
   <TD><A HREF="buyitem.asp?StockId=<%=adoRecordSet("StockId").Value%>">
      Buy this</A></TD>
</TR>
<%
   adoRecordSet.MoveNext();
   }

// Close Recordset and connections 
// and release memory used by Recordset and Connection objects
   adoRecordSet.Close();
   adoRecordSet = null;
   adoConnection.Close();
   adoConnection = null;
%>
</TABLE>
</BODY>
</HTML>

displaystock.asp - 源码说明

本页面展示了「javascript source code part1」中的 displaystock.asp 源码文件，采用 ASP 编程语言编写，共 49 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫开发者社区收录了大量与JavaScript相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

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