homepage.py

python web programming 部分

#
# $Workfile: HomePage.py $ $Revision: 4 $
# $Date: 10/04/01 5:09p $ $Author: Sholden $
#
import Web
from cachequery import CacheQuery
from dbsource import dbsource
from Params import DBSOURCE
#
# Global queries to optimize database access
#
conn = dbsource().conn
qDepts = CacheQuery("department",
                     ("DptCode", "DptName"),
                     (), conn, WHERE="DptCode NOT LIKE '*%'", ORDER=("DptName",), refresh=30)

class Home(Web.Page):

    def Title(self):
        return "Welcome to the Database Mini-Web!"

    def NavBar(self):
        """Generate nav bar showing all departments."""
        result = ["""<FONT size="-2">"""]
        for DptCode, DptName in qDepts():
            result.append("""<A HREF="/DeptHome/%s/">%s</A><BR><BR>""" % (DptCode, DptName))
        result.append("""</FONT>""")
        return "\n".join(result)

    def Body(self):
        if self.op.upper() == "GET":
            text = """<H1 color="red">There's a Database Behind this Site!</H1>
                <H3>Data source is %s</H3>
                <P>Please select a department</P>""" % DBSOURCE
        else:
            text = "Sorry. The operation you requested is invalid."
        return text