adotest.asp

来自「python web programming 部分」· ASP 代码 · 共 30 行

ASP
30
字号
<%@ LANGUAGE="PYTHON" %>
<%
def _test():
    import os, sys, os, string

    eol = "\r\n"
    doc = ['<HTML><HEAD><TITLE>ADO Test App</TITLE></HEAD>\r\n<BODY>']
    doc.append('<H2>ADO test app</H2><P>')
    oConn = Server.CreateObject("ADODB.Connection")
    oConn.open("prom20", "promuser", "promuser")
    rs = Server.CreateObject("ADODB.Recordset")
    rs.Open("SELECT DptCode, DptName FROM department ORDER BY DptName", oConn)
    rs.MoveFirst()
    doc.append("<TABLE>")
    doc.append("<TR><TD><B>Code</B></TD><TD><B>Name</B></TD></TR>")
    while not rs.EOF:
        doc.append("<TR><TD>%s</TD><TD>%s</TD></TR>" %
        	(rs.Fields.Item("DptCode"), rs.Fields.Item(1).Value))
        rs.MoveNext()
    doc.append('</TABLE>')
    doc.append('</BODY></HTML>')
    rs.Close()
    oConn.Close()

    Response.Write(string.join(doc, eol))

_test()
%>

⌨️ 快捷键说明

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