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()