- 后端(Python, 使用Flask框架)
python
from flask import Flask, request, jsonify
from flask_sqlalchemy import SQLAlchemy
app = Flask(name)
app.config[‘SQLALCHEMY_DATABASE_URI’] = ‘sqlite:tmp/game_store.db’
db = SQLAlchemy(app)
class Game(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(80), nullable=False)
price = db.Column(db.Float, nullable=False)
@app.route(‘/games’, methods=[‘GET’])
def get_games():
games = Game.query.all()
return jsonify([{‘id’: game.id, ‘name’: game.name, ‘price’: game.price} for game in games])
其他路由和逻辑…
if name == ‘main’:
db.create_all()
app.run(debug=True)
2. 数据库(SQL)
sql
CREATE TABLE games (
id INTEGER PRIMARY KEY,
name TEXT NOT NULL,
price REAL NOT NULL
);
3. 前端(JavaScript, 使用HTML和AJAX)
html
Game Store
- 后端(Python, 使用Flask框架)
python
from flask import Flask, request, jsonify
from flask_sqlalchemy import SQLAlchemy
app = Flask(name)
app.config[‘SQLALCHEMY_DATABASE_URI’] = ‘sqlite:tmp/game_store.db’
db = SQLAlchemy(app)
class Game(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(80), nullable=False)
price = db.Column(db.Float, nullable=False)
@app.route(‘/games’, methods=[‘GET’])
def get_games():
games = Game.query.all()
return jsonify([{‘id’: game.id, ‘name’: game.name, ‘price’: game.price} for game in games])
其他路由和逻辑…
if name == ‘main’:
db.create_all()
app.run(debug=True)
2. 数据库(SQL)
sql
CREATE TABLE games (
id INTEGER PRIMARY KEY,
name TEXT NOT NULL,
price REAL NOT NULL
);
3. 前端(JavaScript, 使用HTML和AJAX)
html