📄 wdupdt.py

📁 python web programming 部分

💻 PY

字号:

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

def formRead():
    form = cgi.FieldStorage()
    try:
        num = int(form["PgNum"].value)
        name = form["PgName"].value
        text = form["PgText"].value
        op = form["op"].value
        return num, name, text, op
    except (KeyError, ValueError):
        return None

def opSetup(formdata, cr):
    PgNum, PgName, PgText, op = formdata
    if op == "Update":
        return (
        cr.UPDATE("PgData", ["PgNum", "PgText"], ["?", "?"], WHERE="PgName=?"),
        (PgNum, PgText, PgName))
    elif op == "Create":
        return (
        cr.INSERT("PgData", ["PgNum", "PgText", "PgName"], ["?", "?", "?"]),
        (PgNum, PgText, PgName))
    elif op == "Delete":
        return (
        cr.DELETE("PgData", WHERE="PgName=?"),
        (PgName, ))

print """Content-Type: text/html\n
<HTML>
  <HEAD>
    <TITLE>Mini-Web Data Update</TITLE>
  </HEAD>
  <BODY>"""

formdata = formRead()
if formdata:
    PgNum, PgName, PgText, op = formdata
    cn = odbc.connect("WebData")
    cr = jetCursor(cn.cursor(), cn)
    try:
        try:
            opstuff = opSetup(formdata, cr)
            if opstuff:
                sql, data = opstuff
                cr.execute(sql, data)
                cr.commit() # ensure persistence
                print """
                <H2>Mini-Web Page %sd</h2>""" % op
            else:
                print "<H2>Illegal Operation Requested</H2>"
        except odbc.Error:
            print """<H2>Database %s Failed</H2>""" % op
    finally:
        cr.close()
        cn.close()
else:
    print "<H2>Missing or Illegal Forms Data</H2>"
print """
    <P><A HREF="wdlist.py">Return to page list</A>
  </BODY>
</HTML>
"""

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -