### 基于 Python 的音乐管理系统完整实现代码示例 以下是一个基于 Python 和 Flask 框架的简单音乐管理系统的实现代码示例。此系统包括用户管理、音乐分类、热门音乐推荐等核心功能[^2]。 #### 1. 系统环境配置 首先需要安装 Flask 和其他必要的库： ```bash pip install flask sqlalchemy flask_sqlalchemy flask_login ``` #### 2. 数据库模型设计 使用 SQLAlchemy 定义数据库模型。 ```python from flask_sqlalchemy import SQLAlchemy from flask import Flask from flask_login import UserMixin app = Flask(__name__) app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///music.db' app.config['SECRET_KEY'] = 'secret_key' db = SQLAlchemy(app) class User(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(80), unique=True, nullable=False) password = db.Column(db.String(120), nullable=False) class Music(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(120), nullable=False) artist = db.Column(db.String(120), nullable=False) genre = db.Column(db.String(50), nullable=False) class Playlist(db.Model): id = db.Column(db.Integer, primary_key=True) user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False) music_id = db.Column(db.Integer, db.ForeignKey('music.id'), nullable=False) ``` #### 3. 用户注册与登录功能 实现用户注册和登录功能。 ```python from flask import render_template, request, redirect, url_for, flash from flask_login import LoginManager, login_user, logout_user, login_required, current_user login_manager = LoginManager() login_manager.init_app(app) @login_manager.user_loader def load_user(user_id): return User.query.get(int(user_id)) @app.route('/register', methods=['GET', 'POST']) def register(): if request.method == 'POST': username = request.form['username'] password = request.form['password'] new_user = User(username=username, password=password) db.session.add(new_user) db.session.commit() return redirect(url_for('login')) return render_template('register.html') @app.route('/login', methods=['GET', 'POST']) def login(): if request.method == 'POST': username = request.form['username'] password = request.form['password'] user = User.query.filter_by(username=username, password=password).first() if user: login_user(user) return redirect(url_for('home')) else: flash('Invalid credentials') return render_template('login.html') @app.route('/logout') @login_required def logout(): logout_user() return redirect(url_for('login')) ``` #### 4. 音乐管理功能 实现音乐的添加、删除和分类功能。 ```python @app.route('/add_music', methods=['GET', 'POST']) @login_required def add_music(): if request.method == 'POST': title = request.form['title'] artist = request.form['artist'] genre = request.form['genre'] new_music = Music(title=title, artist=artist, genre=genre) db.session.add(new_music) db.session.commit() return redirect(url_for('music_list')) return render_template('add_music.html') @app.route('/music_list') @login_required def music_list(): musics = Music.query.all() return render_template('music_list.html', musics=musics) @app.route('/delete_music/<int:music_id>') @login_required def delete_music(music_id): music = Music.query.get_or_404(music_id) db.session.delete(music) db.session.commit() return redirect(url_for('music_list')) ``` #### 5. 热门音乐推荐模块 基于用户的历史行为数据进行简单的推荐。 ```python @app.route('/recommendations') @login_required def recommendations(): # 简单的推荐逻辑：返回所有音乐 musics = Music.query.all() return render_template('recommendations.html', musics=musics) ``` #### 6. HTML 模板示例 创建 `templates` 文件夹，并在其中添加以下模板文件： - `register.html` ```html <form method="post"> <input type="text" name="username" placeholder="Username" required> <input type="password" name="password" placeholder="Password" required> <button type="submit">Register</button> </form> ``` - `login.html` ```html <form method="post"> <input type="text" name="username" placeholder="Username" required> <input type="password" name="password" placeholder="Password" required> <button type="submit">Login</button> </form> ``` - `add_music.html` ```html <form method="post"> <input type="text" name="title" placeholder="Title" required> <input type="text" name="artist" placeholder="Artist" required> <input type="text" name="genre" placeholder="Genre" required> <button type="submit">Add Music</button> </form> ``` - `music_list.html` ```html <ul> {% for music in musics %} <li>{{ music.title }} by {{ music.artist }} ({{ music.genre }}) <a href="{{ url_for('delete_music', music_id=music.id) }}">Delete</a> </li> {% endfor %} </ul> ``` #### 7. 运行应用 启动 Flask 应用： ```python if __name__ == '__main__': db.create_all() app.run(debug=True) ```