使用python/flask将数据从html表单发送到SQLite数据库

from flask import Flask, render_template, request
import sqlite3

conn = sqlite3.connect('database.db')
cursor = conn.cursor()

@app.route('/submit', methods=['POST'])
def submit():
    # 获取表单数据
    data = request.form['data']
    
    # 将数据插入到数据库中
    cursor.execute("INSERT INTO table_name (column_name) VALUES (?)", (data,))
    conn.commit()
    
    # 关闭数据库连接
    cursor.close()
    conn.close()
    
    return 'Data submitted successfully!'

<form action="/submit" method="post">
    <input type="text" name="data" placeholder="Enter data">
    <input type="submit" value="Submit">
</form>

if __name__ == '__main__':
    app.run()