# app.py
import sqlite3
from flask import Flask, render_template, request, redirect, url_for
app = Flask(__name__, template_folder='templates')
# 初始化数据库
def init_db():
conn = sqlite3.connect('courses.db')
cursor = conn.cursor()
cursor.execute('''
CREATE TABLE IF NOT EXISTS courses (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL,
description TEXT
)
''')
conn.commit()
conn.close()
# 初始化数据库
init_db()
# 路由：显示所有课程
@app.route('/')
def index():
conn = sqlite3.connect('courses.db')
cursor = conn.cursor()
cursor.execute('SELECT * FROM courses')
courses = cursor.fetchall()
conn.close()
return render_template('index.html', courses=courses)
# 路由：添加课程
@app.route('/add_course', methods=['POST'])
def add_course():
name = request.form['name']
description = request.form['description']
conn = sqlite3.connect('courses.db')
cursor = conn.cursor()
cursor.execute('INSERT INTO courses (name, description) VALUES (?, ?)', (name, description))
conn.commit()
conn.close()
return redirect(url_for('index'))
# 运行应用
if __name__ == '__main__':
app.run(debug=True)
