- 数据库设计 (SQL)gwygov.cn
假设我们使用SQLite数据库,首先创建一个简单的游戏商品表。
sql
CREATE TABLE IF NOT EXISTS games (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL,
description TEXT,
price REAL NOT NULL
);
– 插入一些示例数据
INSERT INTO games (name, description, price) VALUES
(‘Game 1’, ‘Description of Game 1’, 9.99),
(‘Game 2’, ‘Description of Game 2’, 14.99),
(‘Game 3’, ‘Description of Game 3’, 29.99);
2. 后端(Python Flask)
使用Flask框架创建简单的Web服务器,用于处理HTTP请求。
python
from flask import Flask, jsonify, request
import sqlite3
app = Flask(name)
DATABASE = ‘game_store.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(ix) for ix in games])
if name == ‘main’:
app.run(debug=True)
3. 前端(HTML + JavaScript)
使用HTML和JavaScript(例如,通过Fetch API)从后端获取数据并显示在游戏商城页面上。
html
Game Store
<script>
fetch('/games')
.then(response => response.json())
.then(data => {
const list = document.getElementById('game-list');
data.forEach(game => {
const item = document.createElement('li');
item.textContent = `${game.name} -
$$
{game.price}`;
list.appendChild(item);
});
});
- 数据库设计 (SQL)
假设我们使用SQLite数据库,首先创建一个简单的游戏商品表。
sql
CREATE TABLE IF NOT EXISTS games (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL,
description TEXT,
price REAL NOT NULL
);
– 插入一些示例数据
INSERT INTO games (name, description, price) VALUES
(‘Game 1’, ‘Description of Game 1’, 9.99),
(‘Game 2’, ‘Description of Game 2’, 14.99),
(‘Game 3’, ‘Description of Game 3’, 29.99);
2. 后端(Python Flask)
使用Flask框架创建简单的Web服务器,用于处理HTTP请求。
python
from flask import Flask, jsonify, request
import sqlite3
app = Flask(name)
DATABASE = ‘game_store.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(ix) for ix in games])
if name == ‘main’:
app.run(debug=True)
3. 前端(HTML + JavaScript)
使用HTML和JavaScript(例如,通过Fetch API)从后端获取数据并显示在游戏商城页面上。
html
Game Store
<script>
fetch('/games')
.then(response => response.json())
.then(data => {
const list = document.getElementById('game-list');
data.forEach(game => {
const item = document.createElement('li');
item.textContent = `${game.name} -
$$
{game.price}`;
list.appendChild(item);
});
});