- 数据库设计(SQLite)1000sheng.com
首先,我们需要一个简单的数据库模型来存储游戏信息。使用SQLite,我们可以创建一个简单的表:
sql
CREATE TABLE games (
id INTEGER PRIMARY KEY AUTOINCREMENT,
title TEXT NOT NULL,
description TEXT,
price REAL NOT NULL
);
2. 后端(Python Flask)
接下来是后端部分,使用Flask框架来创建一个简单的RESTful API。
app.py
python
from flask import Flask, jsonify, request
import sqlite3
app = Flask(name)
DATABASE = ‘games.db’
def get_db_connection():
conn = sqlite3.connect(DATABASE)
conn.row_factory = sqlite3.Row
return conn
@app.route(‘/games’, methods=[‘GET’])
def get_games():
conn = get_db_connection()
cur = conn.cursor()
cur.execute(‘SELECT * FROM games’)
games = cur.fetchall()
conn.close()
return jsonify([dict(row) for row in games])
@app.route(‘/games’, methods=[‘POST’])
def add_game():
data = request.get_json()
conn = get_db_connection()
cur = conn.cursor()
cur.execute(“INSERT INTO games (title, description, price) VALUES (?, ?, ?)”,
(data[‘title’], data[‘description’], data[‘price’]))
conn.commit()
conn.close()
return jsonify({‘message’: ‘Game added successfully’}), 201
if name == ‘main’:
app.run(debug=True)
3. 前端(Vue.js + HTML/CSS)
前端部分使用Vue.js来展示游戏列表和添加新游戏的功能。
index.html
html
Game Store
- {{ game.title }} - ${{ game.price }}
- 数据库设计(SQLite)
首先,我们需要一个简单的数据库模型来存储游戏信息。使用SQLite,我们可以创建一个简单的表:
sql
CREATE TABLE games (
id INTEGER PRIMARY KEY AUTOINCREMENT,
title TEXT NOT NULL,
description TEXT,
price REAL NOT NULL
);
2. 后端(Python Flask)
接下来是后端部分,使用Flask框架来创建一个简单的RESTful API。
app.py
python
from flask import Flask, jsonify, request
import sqlite3
app = Flask(name)
DATABASE = ‘games.db’
def get_db_connection():
conn = sqlite3.connect(DATABASE)
conn.row_factory = sqlite3.Row
return conn
@app.route(‘/games’, methods=[‘GET’])
def get_games():
conn = get_db_connection()
cur = conn.cursor()
cur.execute(‘SELECT * FROM games’)
games = cur.fetchall()
conn.close()
return jsonify([dict(row) for row in games])
@app.route(‘/games’, methods=[‘POST’])
def add_game():
data = request.get_json()
conn = get_db_connection()
cur = conn.cursor()
cur.execute(“INSERT INTO games (title, description, price) VALUES (?, ?, ?)”,
(data[‘title’], data[‘description’], data[‘price’]))
conn.commit()
conn.close()
return jsonify({‘message’: ‘Game added successfully’}), 201
if name == ‘main’:
app.run(debug=True)
3. 前端(Vue.js + HTML/CSS)
前端部分使用Vue.js来展示游戏列表和添加新游戏的功能。
index.html
html
Game Store
- {{ game.title }} - ${{ game.price }}