ASP/ADO/VBScript案例 - W3xue在线HTML/CSS/JS运行工具

W3xue Tools让人人享有平等学习机会

案例：ASP/ADO/VBScript案例 状态：不可编辑再运行进入竖版

运行结果　

<html>
<body>

<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/db/northwind.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
rs.Open "Select * from Customers", conn

do until rs.EOF
    for each x in rs.Fields
       Response.Write(x.name)
       Response.Write(" = ")
       Response.Write(x.value & "<br />") 
    next
    Response.Write("<br />")
    rs.MoveNext
loop

rs.close
conn.close
%>

</body>
</html>

​x
 
<html>
<body>
​
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/db/northwind.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
rs.Open "Select * from Customers", conn
​
do until rs.EOF
    for each x in rs.Fields
       Response.Write(x.name)
       Response.Write(" = ")
       Response.Write(x.value & "<br />") 
    next
    Response.Write("<br />")
    rs.MoveNext
loop
​
rs.close
conn.close
%>
​
</body>
</html>

W3xue 的所有内容仅供测试，对任何法律问题及风险不承担任何责任。通过使用本站内容随之而来的风险与本站无关。部分案例需要特定浏览器支持，如案例没有显示效果，请尝试更换浏览器。意见反馈 友情链接：直通硅谷　点职佳　北美留学生论坛

W3xueDotComlthtmlW3xueDotComgt W3xueDotComltbodyW3xueDotComgt CustomerID = NokiaW3xueDotComltbr /W3xueDotComgtCompanyName = Nokia CorporationW3xueDotComltbr /W3xueDotComgtContactName = Olli-Pekka KallasvuoW3xueDotComltbr /W3xueDotComgtAddress = P.O. Box 226, FIN-00045 Nokia Group, FinlandW3xueDotComltbr /W3xueDotComgtCity = HelsinkiW3xueDotComltbr /W3xueDotComgtPostalCode = noneW3xueDotComltbr /W3xueDotComgtCountry = FinlandW3xueDotComltbr /W3xueDotComgtW3xueDotComltbr /W3xueDotComgtCustomerID = GoogleW3xueDotComltbr /W3xueDotComgtCompanyName = Google, Inc.W3xueDotComltbr /W3xueDotComgtContactName = Larry PageW3xueDotComltbr /W3xueDotComgtAddress = 1600 Amphitheatre Parkway Mountain View, CA 94043W3xueDotComltbr /W3xueDotComgtCity = Mountain ViewW3xueDotComltbr /W3xueDotComgtPostalCode = 94043W3xueDotComltbr /W3xueDotComgtCountry = USAW3xueDotComltbr /W3xueDotComgtW3xueDotComltbr /W3xueDotComgtCustomerID = SONYW3xueDotComltbr /W3xueDotComgtCompanyName = Sony Corporation of AmericaW3xueDotComltbr /W3xueDotComgtContactName = Kazuo HiraiW3xueDotComltbr /W3xueDotComgtAddress = Park Ridge, NJ 07656W3xueDotComltbr /W3xueDotComgtCity = Park RidgeW3xueDotComltbr /W3xueDotComgtPostalCode = 07656W3xueDotComltbr /W3xueDotComgtCountry = USAW3xueDotComltbr /W3xueDotComgtW3xueDotComltbr /W3xueDotComgtCustomerID = APPLEW3xueDotComltbr /W3xueDotComgtCompanyName = Apple Computer, Inc.W3xueDotComltbr /W3xueDotComgtContactName = Steven JobsW3xueDotComltbr /W3xueDotComgtAddress = 1 Infinite Loop Cupertino, CA 95014W3xueDotComltbr /W3xueDotComgtCity = CupertinoW3xueDotComltbr /W3xueDotComgtPostalCode = 95014W3xueDotComltbr /W3xueDotComgtCountry = USAW3xueDotComltbr /W3xueDotComgtW3xueDotComltbr /W3xueDotComgtCustomerID = BAIDUW3xueDotComltbr /W3xueDotComgtCompanyName = BAIDU, IncW3xueDotComltbr /W3xueDotComgtContactName = Li YanHongW3xueDotComltbr /W3xueDotComgtAddress = Lixiang guoji dasha,No 58, beisihuanxiluW3xueDotComltbr /W3xueDotComgtCity = BeijingW3xueDotComltbr /W3xueDotComgtPostalCode = 100080W3xueDotComltbr /W3xueDotComgtCountry = ChinaW3xueDotComltbr /W3xueDotComgtW3xueDotComltbr /W3xueDotComgtCustomerID = CanonW3xueDotComltbr /W3xueDotComgtCompanyName = Canon USA, Inc.W3xueDotComltbr /W3xueDotComgtContactName = Tsuneji UchidaW3xueDotComltbr /W3xueDotComgtAddress = One Canon Plaza Lake Success, NY 11042W3xueDotComltbr /W3xueDotComgtCity = New YorkW3xueDotComltbr /W3xueDotComgtPostalCode = 11042W3xueDotComltbr /W3xueDotComgtCountry = USAW3xueDotComltbr /W3xueDotComgtW3xueDotComltbr /W3xueDotComgt W3xueDotComlt/bodyW3xueDotComgt W3xueDotComlt/htmlW3xueDotComgt