http://www.sqlitebrowser.org/
3.使用DB Browser for sqlite新建表users.db:
图片放置位置：
import os
import sqlite3 as lite
from flask import Flask,jsonify,render_template,request,abort,redirect,url_for
app=Flask(__name__)
mysql_path=os.path.join(os.getcwd(),'users.db')
#自定义错误
@app.errorhandler(404)
def get_Error_Handel(error):
return render_template('404.html'),404
@app.route('/',methods=['POST','GET'])
def delete(user):
conn=lite.connect(mysql_path)
with conn:
cur=conn.cursor()
sql=f"select count(user) from users where user='{user}'"
cur.execute(sql)
count=cur.fetchone()[0]
if count<=0:
return jsonify('delete user mistake!'),404
else:
sql=f"delete from users where user='{user}'"
cur.execute(sql)
return render_template('success.html')
@app.route('/delete',methods=['POST','GET'])
def delete_user():
if request.method=='POST':
user=request.form.get('username')
return redirect(url_for('delete',user=user))
if request.method=='GET':
return render_template('delete.html')
if __name__ == '__main__':
app.run(debug=True)
5.delete.html文件：
Delete
6.错误提示404.html文件：
Failure
7.成功删除的页面success.html:
Success Accept
