wdlist.py

来自「python web programming 部分」· Python 代码 · 共 33 行

PY
33
字号
#!C:/Python20/python.exe
#
import mx.ODBC.Windows as odbc
from jetCursor import jetCursor
import urllib

print """Content-Type: text/html\n
<HTML>
  <HEAD>
    <TITLE>Min-Web Page List</TITLE>
  </HEAD>
  <BODY>"""

cn = odbc.connect("WebData")
cr = jetCursor(cn.cursor(), cn)
sql = cr.SELECT("PgName", FROM="PgData")
cr.execute(sql)
data = cr.fetchall()
cr.close()
cn.close()
print """<H2>Page List for Mini-Web Database</H2>
<P>Click the page name to show data in an edit form<BR>"""
for d in data:
    PgName = d[0]
    print """
        <A HREF="wdform.py?PgName=%s">%s</A><BR>""" % \
                    (urllib.quote(PgName), PgName)
print """<BR>
        <A HREF="wdform.py">Create New Page</A><BR>
  </BODY>
</HTML>
"""

⌨️ 快捷键说明

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