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 + -
显示快捷键?