#先创建一个数据库
import sqlite3
db=sqlite3.connect("e:/tests/flask_sqlite3_test.db")
cursor=db.cursor()
cursor.execute("CREATE TABLE IF NOT EXISTS users (name TEXT);")
db.commit()
db.close()
print("数据库已经创建")
import sqlite3
from flask import Flask,g,request
DATABASE = 'e:/tests/flask_sqlite3_test.db'
def get_db():
db = getattr(g, '_database', None)
if db is None:
db = g._database = sqlite3.connect(DATABASE)
return db
app=Flask(__name__)
@app.teardown_appcontext
def close_connection(exception):
db = getattr(g, '_database', None)
if db is not None:
db.close()
print("db closed")
@app.route("/",methods=["POST","GET"])
def hello():
html="""
<form action="/" method="