📄 wdform.py

📁 python web programming 部分

💻 PY

字号:

#!C:/Python20/python.exe
#
import cgi
import mx.ODBC.Windows as odbc
from jetCursor import jetCursor

class NoSuchPage:   # Exception
    pass

form = cgi.FieldStorage()
print """Content-Type: text/html\n
<HTML>
  <HEAD>
    <TITLE>Mini-Web Data Entry/Edit Form</TITLE>
  </HEAD>
  <BODY>"""
try:
    if form.has_key("PgName"):  # edit existing page
        PgName = form["PgName"].value
        cn = odbc.connect("WebData")
        cr = jetCursor(cn.cursor(), cn)
        sql = cr.SELECT(["PgNum", "PgText"], FROM="PgData",
                WHERE="PgName=?")
        cr.execute(sql, (PgName,))
        data = cr.fetchall()
        if len(data) == 0:
            raise NoSuchPage
        op = "Update"
        it = "HIDDEN"
        cr.close()
        cn.close()
        button2 = """
        <INPUT NAME="op" TYPE="SUBMIT" VALUE="Delete"
                     OnClick="return(confirm('Do you REALLY want to delete this record?'))">"""
    else:                       # create new page
        op = "Create"
        it = "TEXT"
        data = ( (0, ''), )
        PgName = ''
        button2 = ''
    PgNum, PgText = data[0]     # common logic
    print """
        <H2>%s Mini-Web Page Data</h2>
        <FORM METHOD="POST" ACTION="wdupdt.py">
        Page Name: %s<BR>
        <INPUT NAME="PgName" TYPE="%s" LENGTH="25" VALUE="%s"><BR>
        Page Number:<BR>
        <INPUT NAME="PgNum" TYPE="TEXT" VALUE="%d"><BR>
        Page Text:<BR>
        <TEXTAREA COLS="50" ROWS="7" NAME="PgText">%s</TEXTAREA><BR>
        <INPUT NAME="op" TYPE="SUBMIT" VALUE="%s">
        %s
        </FORM>""" % (op, PgName, it, PgName, PgNum, PgText, op, button2)
except NoSuchPage:
    print """<H2>Page %s Not Found</H2>
    <P><A HREF="wdlist.py">Return to page list</A>""" % PgName
print """
  </BODY>
</HTML>
"""

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -