- 后端(Python,使用Flask框架)gd360.cn
python
from flask import Flask, request, jsonify
import sqlite3
app = Flask(name)
连接到SQLite数据库(为了简化,我们使用SQLite)
conn = sqlite3.connect(‘game_store.db’)
cursor = conn.cursor()
初始化数据库表(如果尚未存在)
cursor.execute(‘’’
CREATE TABLE IF NOT EXISTS games (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL,
price REAL NOT NULL
)
‘’')
conn.commit()
获取所有游戏
@app.route(‘/games’, methods=[‘GET’])
def get_games():
cursor.execute(‘SELECT * FROM games’)
games = cursor.fetchall()
return jsonify([{‘id’: game[0], ‘name’: game[1], ‘price’: ga