Python访问Mysql及Web脚本编写

Python访问Mysql及Web脚本编写

1． 目的

测试Python 访问Mysql数据库及在web中的应用

2． 平台

Python2.7              iis5.1             mysql5.0（用户名root，密码wang）database：test〔table:mytable〕

3． 方法

#encoding=utf-8

import sys

import MySQLdb

 

reload(sys)

sys.setdefaultencoding('utf-8')

 

print("hello world")

db = MySQLdb.connect(user ='root',passwd='wang', charset = 'utf8')

cur = db.cursor()

cur.execute('use test')

cur.execute('select * from mytable')

 

for i in cur.fetchall():

   print(str(i))

 

cur.close()

web脚本中的应用

#encoding=utf-8

import sys

import MySQLdb

 

reload(sys)

sys.setdefaultencoding('utf-8')

 

print ('Status: 200 OK')

print ('Content-Type: text/html')

print ('')

print ('<h1>Hello,Python</h1>')

 

db = MySQLdb.connect(user ='root',passwd='wang', charset = 'utf8')

cur = db.cursor()

cur.execute('use test')

cur.execute('select * from mytable')

 

for i in cur.fetchall():

   print(str(i))

 

cur.close()