服务器客户端传输数据库

from flask import Flask, jsonify, request
import sqlite3

app = Flask(__name__)

def db_connection():
    conn = None
    try:
        conn = sqlite3.connect('example.db')
    except sqlite3.error as e:
        print(e)
    return conn

@app.route('/api/data', methods=['GET'])
def get_data():
    conn = db_connection()
    cursor = conn.cursor()
    cursor.execute("SELECT * FROM table_name")
    data = cursor.fetchall()
    conn.close()
    return jsonify(data)

@app.route('/api/data', methods=['POST'])
def add_data():
    if request.is_json:
        data = request.get_json()
        name = data['name']
        # 插入数据到数据库
        conn = db_connection()
        cursor = conn.cursor()
        cursor.execute("INSERT INTO table_name (name) VALUES (?)", (name,))
        conn.commit()
        conn.close()
        return jsonify({"result": "success"}), 201

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