#!/usr/bin/env python
import web
import pymysql.cursors
# Connect to the database
connection = pymysql.connect(host='127.0.0.1',
port=3306,
user='root',
password='123',
db='test',
charset='utf8mb4',
cursorclass=pymysql.cursors.DictCursor)
render = web.template.render('templates/')
web.template.Template.globals['render'] = render
urls = (
# '/(.*)', 'hello',
'/index', 'index',
)
app = web.application(urls, globals())
class index:
def GET(self):
return render.index()
def POST(self):
# para = web.data()
p = web.input()
# print(p)
with connection.cursor() as cursor:
sql = """SELECT userid FROM user_shenqing WHERE userid=%s AND nickname=%s"""
cursor.execute(sql, (p.fname, p.lname))
result = cursor.fetchall()
# print(result)
if result:
return '<H1>Hello, {}!<H1>'.format(p.fname)
else:
return '<H1>{}!<H1>'.format('username or password is wrong!')
if __name__ == "__main__":
app.run()
render = web.template.render('templates/') 指定模版路径
web.data() POST模式接收数据
web.input() GET和POST模式接收数据