### 设计基于Python Flask的图书管理系统 以下是使用Python和Flask框架开发一个具备图书信息录入、借阅/归还记录、读者管理、会话控制以及用户权限功能的图书管理系统的详细设计方案。 #### 1. 系统架构设计 系统分为以下几个模块： - **图书管理模块**：负责图书信息的增删改查操作，包括书名、ISBN、作者、出版社等信息的维护。 - **借阅与归还模块**：记录图书的借阅和归还情况，支持按读者或图书查询借阅记录。 - **读者管理模块**：管理读者的基本信息，如姓名、联系方式、借阅历史等。 - **会话控制模块**：实现用户登录、注销及会话保持功能。 - **用户权限控制模块**：区分管理员和普通用户的权限，确保数据安全。 #### 2. 数据库设计 数据库表结构如下： - **图书表 (books)**: 存储图书的基本信息。 ```sql CREATE TABLE books ( id INT AUTO_INCREMENT PRIMARY KEY, title VARCHAR(255) NOT NULL, isbn VARCHAR(13) UNIQUE NOT NULL, author VARCHAR(255), publisher VARCHAR(255), category VARCHAR(100), stock INT DEFAULT 0 ); ``` - **读者表 (readers)**: 存储读者的基本信息。 ```sql CREATE TABLE readers ( id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255) NOT NULL, contact VARCHAR(255), created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); ``` - **借阅记录表 (borrow_records)**: 记录图书的借阅和归还情况。 ```sql CREATE TABLE borrow_records ( id INT AUTO_INCREMENT PRIMARY KEY, book_id INT NOT NULL, reader_id INT NOT NULL, borrow_date DATE NOT NULL, return_date DATE, FOREIGN KEY (book_id) REFERENCES books(id), FOREIGN KEY (reader_id) REFERENCES readers(id) ); ``` - **用户表 (users)**: 存储系统用户的账号信息及权限。 ```sql CREATE TABLE users ( id INT AUTO_INCREMENT PRIMARY KEY, username VARCHAR(255) NOT NULL UNIQUE, password_hash VARCHAR(255) NOT NULL, role ENUM('admin', 'user') DEFAULT 'user' ); ``` #### 3. Flask应用结构 项目文件夹结构如下： ``` /flask_library_management /app __init__.py models.py routes.py templates/ index.html add_book.html manage_readers.html borrow_return.html login.html requirements.txt run.py ``` #### 4. 模型定义 在 `models.py` 中定义数据库模型： ```python from flask_sqlalchemy import SQLAlchemy from werkzeug.security import generate_password_hash, check_password_hash db = SQLAlchemy() class Book(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(255), nullable=False) isbn = db.Column(db.String(13), unique=True, nullable=False) author = db.Column(db.String(255)) publisher = db.Column(db.String(255)) category = db.Column(db.String(100)) stock = db.Column(db.Integer, default=0) class Reader(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(255), nullable=False) contact = db.Column(db.String(255)) class BorrowRecord(db.Model): id = db.Column(db.Integer, primary_key=True) book_id = db.Column(db.Integer, db.ForeignKey('book.id'), nullable=False) reader_id = db.Column(db.Integer, db.ForeignKey('reader.id'), nullable=False) borrow_date = db.Column(db.Date, nullable=False) return_date = db.Column(db.Date) class User(db.Model): id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(255), unique=True, nullable=False) password_hash = db.Column(db.String(255), nullable=False) role = db.Column(db.Enum('admin', 'user'), default='user') def set_password(self, password): self.password_hash = generate_password_hash(password) def check_password(self, password): return check_password_hash(self.password_hash, password) ``` #### 5. 路由与视图函数 在 `routes.py` 中定义路由和视图函数： ```python from flask import render_template, request, redirect, url_for, flash, session from app import app, db from app.models import Book, Reader, BorrowRecord, User from datetime import date @app.route('/') def index(): if 'user_id' not in session: return redirect(url_for('login')) return render_template('index.html') @app.route('/add_book', methods=['GET', 'POST']) def add_book(): if 'user_id' not in session or session['role'] != 'admin': return redirect(url_for('index')) if request.method == 'POST': title = request.form['title'] isbn = request.form['isbn'] author = request.form['author'] publisher = request.form['publisher'] category = request.form['category'] stock = int(request.form['stock']) new_book = Book(title=title, isbn=isbn, author=author, publisher=publisher, category=category, stock=stock) db.session.add(new_book) db.session.commit() return redirect(url_for('index')) return render_template('add_book.html') @app.route('/manage_readers') def manage_readers(): if 'user_id' not in session or session['role'] != 'admin': return redirect(url_for('index')) readers = Reader.query.all() return render_template('manage_readers.html', readers=readers) @app.route('/borrow_return', methods=['GET', 'POST']) def borrow_return(): if 'user_id' not in session: return redirect(url_for('login')) if request.method == 'POST': book_id = int(request.form['book_id']) reader_id = int(request.form['reader_id']) action = request.form['action'] book = Book.query.get_or_404(book_id) reader = Reader.query.get_or_404(reader_id) if action == 'borrow' and book.stock > 0: record = BorrowRecord(book_id=book_id, reader_id=reader_id, borrow_date=date.today()) book.stock -= 1 db.session.add(record) db.session.commit() elif action == 'return': record = BorrowRecord.query.filter_by(book_id=book_id, reader_id=reader_id, return_date=None).first() if record: record.return_date = date.today() book.stock += 1 db.session.commit() return redirect(url_for('index')) return render_template('borrow_return.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).first() if user and user.check_password(password): session['user_id'] = user.id session['role'] = user.role return redirect(url_for('index')) flash('Invalid credentials') return render_template('login.html') @app.route('/logout') def logout(): session.pop('user_id', None) session.pop('role', None) return redirect(url_for('login')) ``` #### 6. 模板设计 模板文件位于 `templates` 目录下，例如 `add_book.html`： ```html <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Add Book</title> </head> <body> <h1>Add New Book</h1> <form method="POST"> <label for="title">Title:</label> <input type="text" name="title" required><br> <label for="isbn">ISBN:</label> <input type="text" name="isbn" required><br> <label for="author">Author:</label> <input type="text" name="author"><br> <label for="publisher">Publisher:</label> <input type="text" name="publisher"><br> <label for="category">Category:</label> <input type="text" name="category"><br> <label for="stock">Stock:</label> <input type="number" name="stock" min="0" value="0"><br> <button type="submit">Add Book</button> </form> </body> </html> ``` #### 7. 部署与运行 在 `run.py` 中初始化应用并运行： ```python from app import app, db if __name__ == '__main__': db.create_all() app.run(debug=True) ``` ### 注意事项 - 确保安装依赖库：`pip install flask flask_sqlalchemy werkzeug`。 - 在生产环境中关闭 `debug=True` 并配置数据库连接字符串[^2]。