- 后端(Python + Flask)zgshgys3w.com
python
from flask import Flask, request, jsonify
from flask_sqlalchemy import SQLAlchemy
app = Flask(name)
app.config[‘SQLALCHEMY_DATABASE_URI’] = ‘sqlite:tmp/test.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)
基于上面的Flask示例,我们可以使用SQLite数据库,但这里只给出表结构的概念性SQL:
sql
CREATE TABLE games (
id INTEGER PRIMARY KEY,
name TEXT NOT NULL,
price REAL NOT NULL
);
3. 前端(JavaScript + HTML + CSS,使用AJAX与后端通信)
这里只给出HTML和JavaScript的简化示例:
html
Game Store
<script>
$(document).ready(function() {
$.get('/games', function(data) {
let list = $('#games-list');
list.empty();
data.forEach(function(game) {
list.append(`<div>Name: ${game.name}, Price:
$$
{game.price}`);
});
});
});
- 后端(Python + Flask)
python
from flask import Flask, request, jsonify
from flask_sqlalchemy import SQLAlchemy
app = Flask(name)
app.config[‘SQLALCHEMY_DATABASE_URI’] = ‘sqlite:tmp/test.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)
基于上面的Flask示例,我们可以使用SQLite数据库,但这里只给出表结构的概念性SQL:
sql
CREATE TABLE games (
id INTEGER PRIMARY KEY,
name TEXT NOT NULL,
price REAL NOT NULL
);
3. 前端(JavaScript + HTML + CSS,使用AJAX与后端通信)
这里只给出HTML和JavaScript的简化示例:
html
Game Store
<script>
$(document).ready(function() {
$.get('/games', function(data) {
let list = $('#games-list');
list.empty();
data.forEach(function(game) {
list.append(`<div>Name: ${game.name}, Price:
$$
{game.price}`);
});
});
});