基于 AI 辅助的在线图书借阅平台设计与实现

Book.java（含馆藏与可借数量）：

package com.student.library.entity;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import java.time.LocalDateTime;

@Data
@NoArgsConstructor
@AllArgsConstructor
@TableName("book")
public class Book {
    @TableId(type = IdType.AUTO)
    private Long bookNo;
    private String bookName;
    private String author;
    private Long categoryId;
    private String publisher;
    private LocalDateTime publishDate;
    private Integer totalCount;
    private Integer availableCount;
    private String description;
}

（2）DTO 包：数据传输对象

BorrowBookDTO.java（参数校验）：

package com.student.library.dto;

import jakarta.validation.constraints.NotNull;
import lombok.Data;

@Data
public class BorrowBookDTO {
    @NotNull(message = "学生 ID 不能为空")
    private Long studentId;
    @NotNull(message = "图书编号不能为空")
    private Long bookNo;
    @NotNull(message = "借阅天数不能为空")
    private Integer borrowDays = 30;
}

（3）VO 包：视图对象

BookDetailVO.java（隐藏敏感字段）：

package com.student.library.vo;

import lombok.Data;
import java.time.LocalDateTime;

@Data
public class BookDetailVO {
    private Long bookNo;
    private String bookName;
    private String author;
    private String categoryName;
    private String publisher;
    private LocalDateTime publishDate;
    private Integer availableCount;
    private String description;
    private Boolean canBorrow;
}

（4）Service 包：业务逻辑

BorrowServiceImpl.java（借阅/续借逻辑）：

package com.student.library.service.impl;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.student.library.dto.BorrowBookDTO;
import com.student.library.entity.Book;
import com.student.library.entity.BorrowRecord;
import com.student.library.entity.User;
import com.student.library.mapper.BookMapper;
import com.student.library.mapper.BorrowRecordMapper;
import com.student.library.mapper.UserMapper;
import com.student.library.service.BorrowService;
import com.student.library.vo.BorrowRecordVO;
import lombok.RequiredArgsConstructor;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.BeanUtils;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import java.time.LocalDate;
import java.time.temporal.ChronoUnit;
import java.util.List;
import java.util.stream.Collectors;

@Slf4j
@Service
@RequiredArgsConstructor
public class BorrowServiceImpl extends ServiceImpl<BorrowRecordMapper, BorrowRecord> implements BorrowService {
    private final BorrowRecordMapper borrowRecordMapper;
    private final BookMapper bookMapper;
    private final UserMapper userMapper;

    @Override
    @Transactional
    public BorrowRecord borrowBook(BorrowBookDTO borrowBookDTO) {
        log.info("学生借阅图书：学生 ID={}, 图书编号={}", borrowBookDTO.getStudentId(), borrowBookDTO.getBookNo());
        
        // 1. 校验学生身份
        User student = userMapper.selectById(borrowBookDTO.getStudentId());
        if (student == null || student.getRole() != 0) {
            throw new RuntimeException("无效的学生账号");
        }

        // 2. 校验图书状态
        Book book = bookMapper.selectById(borrowBookDTO.getBookNo());
        if (book == null) {
            throw new RuntimeException("该图书不存在");
        }
        if (book.getAvailableCount() <= 0) {
            throw new RuntimeException("该图书已无库存");
        }

        // 3. 生成借阅记录
        BorrowRecord record = new BorrowRecord();
        record.setStudentId(borrowBookDTO.getStudentId());
        record.setBookNo(borrowBookDTO.getBookNo());
        record.setBorrowDate(LocalDate.now());
        record.setDueDate(LocalDate.now().plusDays(borrowBookDTO.getBorrowDays()));
        record.setReturnStatus(0);

        // 4. 更新库存
        book.setAvailableCount(book.getAvailableCount() - 1);
        bookMapper.updateById(book);

        save(record);
        return record;
    }

    @Override
    @Transactional
    public BorrowRecord renewBook(Long recordId) {
        BorrowRecord record = getById(recordId);
        if (record == null || record.getReturnStatus() == 1) {
            throw new RuntimeException("记录不存在或已归还");
        }
        if (LocalDate.now().isAfter(record.getDueDate())) {
            throw new RuntimeException("图书已超期");
        }
        if (record.getRenewCount() >= 1) {
            throw new RuntimeException("已续借 1 次");
        }
        record.setDueDate(record.getDueDate().plusDays(30));
        record.setRenewCount(record.getRenewCount() + 1);
        updateById(record);
        return record;
    }
}

网页展示

前端采用 Bootstrap 实现响应式布局，适配电脑端使用场景。

1. 图书查询页

顶部搜索栏支持按书名/作者搜索，左侧分类筛选，中间卡片式展示图书列表。剩余可借数量为 0 时显示红色标签。支持分页。

2. 借阅记录页

表格展示未归还记录，列包含图书名称、到期时间、剩余天数。即将超期显示红色字体，超期后禁止续借。

3. 图书管理页

管理员界面，支持添加、编辑、下架图书。库存不足时高亮提示。

优化与调试

1. 核心优化点

• 密码加密：集成 Spring Security BCrypt，避免明文存储。
• 超期提醒：计算剩余天数，前端动态展示预警信息。
• 分类管理：补充分类 CRUD 功能，增强灵活性。

2. 常见问题解决

• 数据库连接失败：检查 application.yml 中的密码配置。
• 库存未更新：确保借阅成功后调用 updateById 更新 Book 表。

总结

本项目展示了如何利用 AI 辅助工具快速构建规范的 Java Web 应用。通过自动化生成基础代码，开发者能更专注于业务逻辑与系统稳定性。技术栈涵盖 Spring Boot、MyBatis-Plus、MySQL 及 Bootstrap，适合中小型管理系统参考。后续可拓展预约功能及罚款对接，进一步完善生态。