单页web开发之python的cgi编程一例

本帖利用一个实例,简单的介绍一下python的cgi编程和mysql数据库操作

1,先把数据库服务器的信息录入到表内,表格式如下.

2,利用python的cgi脚本从表中按照规则读取数据

3,用web界面展示

建立一个表,语句如下(字段解释参照cgi部分):

CREATE TABLE `host_db` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `site` char(10) NOT NULL,
  `hostname` char(30) NOT NULL,
  `ip_eth0` varchar(50) NOT NULL,
  `ip_eth1` varchar(50) NOT NULL,
  `db_type` varchar(45) NOT NULL,
  `db_version` varchar(45) NOT NULL,
  `db_port` varchar(45) NOT NULL,
  `structure` varchar(45) NOT NULL,
  `cluster` varchar(45) DEFAULT NULL,
  `role` varchar(45) DEFAULT NULL,
  `vip` varchar(45) DEFAULT NULL,
  `developer` varchar(255) DEFAULT NULL,
  `work` varchar(255) DEFAULT NULL,
  `affect` varchar(255) DEFAULT NULL,
  `mark` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB

web的cgi脚本如下:

#!/usr/bin/python
#coding=utf-8

import sys

reload(sys)
sys.setdefaultencoding('utf-8')
#这两个的作用是设置python默认编码为utf8
import MySQLdb
import cgi

print "Content-Type: text/html charset=utf-8 \n"
print "数据库列表"
print ""
print "数据库列表"
print ""
				
				
					print '''

				
				
					

				
				
					请选择要查询的类型: 
				
				
					 数据库XXX
				
				
					 数据库XXX
				
				
					 数据库XXX
				
				
					 数据库XXX
				
				
					
				
				
					请出入要查询的主机名: 
				
				
					
				
				
					
				
				
					'''
				
				
					#下面的函数,提供了主要的检索功能,其中修改了部分名字,大家可以参考一下思路.感兴趣的可以单独联系.
				
				
					def SEL_HOST(HN='') :
				
				
					    if HN == 'host_x':
				
				
					        SQL_HOST = 'SELECT * FROM host_db'
				
				
					        NUM_HOST = 'SELECT COUNT(DISTINCT hostname) FROM host_db'
				
				
					    elif HN == 'host_x':
				
				
					        SQL_HOST = 'SELECT * FROM host_db WHERE structure="XX" ORDER BY cluster'
				
				
					        NUM_HOST = 'SELECT COUNT(DISTINCT hostname) FROM host_db WHERE structure="XX"'
				
				
					    elif HN == 'host_x':
				
				
					        SQL_HOST = 'SELECT * FROM host_db WHERE structure="XX" ORDER BY cluster'
				
				
					        NUM_HOST = 'SELECT COUNT(DISTINCT hostname) FROM host_db WHERE structure="XX"'
				
				
					    elif HN == 'host_x':
				
				
					        SQL_HOST = 'SELECT * FROM host_db WHERE structure="XX" ORDER BY cluster'
				
				
					        NUM_HOST = 'SELECT COUNT(DISTINCT hostname) FROM host_db WHERE structure="XX"'
				
				
					    else:
				
				
					        SQL_HOST = 'SELECT * FROM host_db WHERE hostname LIKE "%%%s%%"' % (HN)
				
				
					    if 'NUM_HOST' in dir():
				
				
					        CUR.execute(NUM_HOST)
				
				
					        print "所查询的主机数量: %s " % CUR.fetchone()
				
				
					    CUR.execute(SQL_HOST)
				
				
					    for data in CUR.fetchall():
				
				
					        print ""
					        print ""%(data[0])
					        print ""%(data[1])
					        print ""%(data[2])
					        print ""%(data[3])
					        print ""%(data[4])
					        print ""%(data[5])
					        print ""%(data[6])
					        print ""%(data[7])
					        print ""%(data[8])
					        print ""%(data[9])
					        print ""%(data[10])
					        print ""%(data[11])
					        print ""%(data[12])
					        print ""%(data[13])
					        print ""%(data[14])
					        print ""%(data[15])
					        print "
				
				  实例id              %s    
				
				  机房                %s    
				
				  主机名              %s    
				
				  内网ip              %s    
				
				  外网ip              %s    
				
				  数据库类型          %s    
				
				  数据库版本          %s    
				
				  数据库端口          %s    
				
				  架构                %s    
				
				  架构名              %s    
				
				  角色                %s    
				
				  vip                 %s    
				
				  开发负责人          %s    
				
				  应用                %s    
				
				  影响            %s    
				
				  备注                %s    
				
				"
				
				
					        print ""
				
				
					def main() :
				
				
					    form = cgi.FieldStorage()
				
				
					#    if form.has_key('hostname'):
				
				
					    hostname = form['hostname'].value
				
				
					
				
				
					if __name__ == '__main__':
				
				
					    CON = MySQLdb.connect(host='192.168.250.253',user='dba_work',passwd='123456',db='dba_work',charset='utf8',use_unicode = True)
				
				
					    CUR = CON.cursor()
				
				
					    form = cgi.FieldStorage()
				
				
					    if form.has_key('hostname'):
				
				
					        hostname = form['hostname'].value
				
				
					        SEL_HOST(hostname)
				
				
					    elif form.has_key('host_list'):
				
				
					        host_all = form['host_list'].value
				
				
					        SEL_HOST(host_all)
				
				
					    else:
				
				
					        pass
				
				
					    print ""
print '''

请选择要查询的类型:
数据库XXX
数据库XXX
数据库XXX
数据库XXX

请出入要查询的主机名:


'''
#下面的函数,提供了主要的检索功能,其中修改了部分名字,大家可以参考一下思路.感兴趣的可以单独联系.
def SEL_HOST(HN='') :
    if HN == 'host_x':
        SQL_HOST = 'SELECT * FROM host_db'
        NUM_HOST = 'SELECT COUNT(DISTINCT hostname) FROM host_db'
    elif HN == 'host_x':
        SQL_HOST = 'SELECT * FROM host_db WHERE structure="XX" ORDER BY cluster'
        NUM_HOST = 'SELECT COUNT(DISTINCT hostname) FROM host_db WHERE structure="XX"'
    elif HN == 'host_x':
        SQL_HOST = 'SELECT * FROM host_db WHERE structure="XX" ORDER BY cluster'
        NUM_HOST = 'SELECT COUNT(DISTINCT hostname) FROM host_db WHERE structure="XX"'
    elif HN == 'host_x':
        SQL_HOST = 'SELECT * FROM host_db WHERE structure="XX" ORDER BY cluster'
        NUM_HOST = 'SELECT COUNT(DISTINCT hostname) FROM host_db WHERE structure="XX"'
    else:
        SQL_HOST = 'SELECT * FROM host_db WHERE hostname LIKE "%%%s%%"' % (HN)
    if 'NUM_HOST' in dir():
        CUR.execute(NUM_HOST)
        print "所查询的主机数量: %s " % CUR.fetchone()
    CUR.execute(SQL_HOST)
    for data in CUR.fetchall():
        print ""
					        print ""%(data[0])
					        print ""%(data[1])
					        print ""%(data[2])
					        print ""%(data[3])
					        print ""%(data[4])
					        print ""%(data[5])
					        print ""%(data[6])
					        print ""%(data[7])
					        print ""%(data[8])
					        print ""%(data[9])
					        print ""%(data[10])
					        print ""%(data[11])
					        print ""%(data[12])
					        print ""%(data[13])
					        print ""%(data[14])
					        print ""%(data[15])
					        print "
				
				  实例id              %s    
				
				  机房                %s    
				
				  主机名              %s    
				
				  内网ip              %s    
				
				  外网ip              %s    
				
				  数据库类型          %s    
				
				  数据库版本          %s    
				
				  数据库端口          %s    
				
				  架构                %s    
				
				  架构名              %s    
				
				  角色                %s    
				
				  vip                 %s    
				
				  开发负责人          %s    
				
				  应用                %s    
				
				  影响            %s    
				
				  备注                %s    
				
				"
        print "
        print "
        print "
        print "
        print "
        print "
        print "
        print "
        print "
        print "
        print "
        print "
        print "
        print "
        print "
        print "
        print "
        print ""
def main() :
    form = cgi.FieldStorage()
#    if form.has_key('hostname'):
    hostname = form['hostname'].value

if __name__ == '__main__':
    CON = MySQLdb.connect(host='192.168.250.253',user='dba_work',passwd='123456',db='dba_work',charset='utf8',use_unicode = True)
    CUR = CON.cursor()
    form = cgi.FieldStorage()
    if form.has_key('hostname'):
        hostname = form['hostname'].value
        SEL_HOST(hostname)
    elif form.has_key('host_list'):
        host_all = form['host_list'].value
        SEL_HOST(host_all)
    else:
        pass
    print "
    print "
"
    CUR.close()