|
已经写好的代码如下,但是测试的时候,数据库里的用户名和密码输入的时候显示用户名或密码错误,求大神指教!!!!!!!!!!!!!!
#!/usr/bin/env python3
# -*- coding: utf-8 -*-
from flask import Flask
from flask import request
import sqlite3
app = Flask(__name__)
@app.route('/', methods=['GET', 'POST'])
def home():
return '''<h1>Home</h1>
<p><a href="/login">Login</a></p>
<p><a href="/signup">Signup</a></p>'''
@app.route('/login', methods=['GET'])
def login_form():
return '''<form action="/login" method="post">
<p>username <input name="username"></p>
<p>password <input name="password" type="password"></p>
<p><button type="submit">Log In</button></p>
</form>'''
@app.route('/login', methods=['POST'])
def login():
# get data from database:
# 连接到SQLite数据库
# 1.Connection Open
conn=sqlite3.connect('login.db')
# 2.Cursor Creating:
cursor = conn.cursor()
# 3.SQL Execution
# 执行SQL语句,循环插入记录:
sqlstr='select * from localuser where localuser_name=\''+request.form['username']+\
'\' and localuser_password=\''+request.form['password']+'\''
# 4.Cursor Moving
# 体验游标
# 执行, 游标移至当前位置
cursor.execute(sqlstr)
numrows = int(cursor.rowcount)
# 提交事务:
conn.commit()
# 5.Connection Close
# 关闭Cursor:
cursor.close()
# 关闭Connection:
conn.close()
# get data from request:
if numrows>0:
return '<h3>Hello, '+request.form['username']+'</h3>'
return '<h3>Bad username or password.</h3>'
if __name__ == '__main__':
app.run()
|
|