在window环境下编写python cgi
#!C:\Python25\python.exe # -*- coding: cp936 -*- #filename : CGI_Login.py # # writer : 天渊小剑 # @copyright -*- 2009-06-1 -*- # #--------------------------------------- # Package : #--------------------------------------- import cgi,sys,cgitb,time,os,md5,hashlib import _mysqlTest,traceback cgitb.enable() #--------------------------------------- # Class : # CGI登陆程序 #--------------------------------------- class LoginPage: #--------------------------------------- # Method() : # |--__init__() : 构造函数 # |--__setHtmlHeader() : 设置CGI可识别HTTP头 # |--_main_() : 主控制函数 # |-- __ShowPage() : 显示View显示函数 # |-- __run() : 主运行函数 # |-- __checkUserToBe() : 判断用户是否存在 # |-- __ShowLoginSucesPage(): 登陆成功处理 # |-- __createLoginSQL() : 构造SQL语句 # #--------------------------------------- def __init__ (self): self.__setHtmlHeader() self.ROOTPATH = os.environ['SCRIPT_NAME'] self._main_() def _main_ (self): datalist = cgi.FieldStorage() if datalist: data_ = self.__run(datalist) if data_: self.__ShowPage(data_) else: self.__ShowPage() def __run (self,datalist): if datalist.getfirst('user') and datalist.getfirst('passwd'): sql = self.__createLoginSQL(datalist.getfirst('user'),datalist.getfirst('passwd')) result = self.__checkUserToBe(sql) str_ = self.__ShowLoginSucesPage(result) self.__ShowPage(str_) def __checkUserToBe (self,sql): db = _mysqlTest.DBbase() res= db.querySQL(sql) if res: return res else: print("<script>alert('登陆失败');window.location.href='"+self.ROOTPATH+"';</script>") return False def __ShowLoginSucesPage (self,res): print("<script>alert('登陆成功');</script>") for var in res: userName = (var[1]) str_ = ''' "%s" 欢迎您回来 '''%(userName) return str_ def __createLoginSQL (self,username,passwd): m = md5.new() m.update(passwd) passwd = m.hexdigest() sql = "select * from `workuser` where `w_Phone`='%s' and `w_Pwd`='%s'"%(username,passwd) return sql def __setHtmlHeader (self): print("Content-type:text/html\n") #让浏览器知道这是什么类型的文件 print("") def __ShowPage (self,param=None): if param==None: var = ''' <form action="%s" method="post"> 用户名: <input type="text" name="user" size="12" /> 密码: <input type="password" name="passwd" size="12" /> <input TYPE="submit" NAME="login" VALUE="提交"> </form> '''% (self.ROOTPATH) else: var = param print ''' <html> <head> </head> <body> 当前系统时间 %s <p /> %s </BODY> </HTML> '''% (time.strftime(" %Z [ %I:%M:%S %P ] "),var) #--------------------------------------- # Test Run #--------------------------------------- LoginPage()
