<template> <div> <el-container> <!-- 侧边栏 --> <el-aside style="width: 200px;min-height:…
- User
<!-- 头部 --> <el-header style="font-family: 楷体;text-align: center;font-weight: bold;background-color:rgb(254, 64, 74);color: white;font-size: 50px;"> 红色精神图书管理系统 </el-header> <!-- 主要内容区域 --> <el-main> <el-form :inline="true" :model="queryForm" class="demo-form-inline" style="margin-bottom: 20px;"> <el-form-item label="书名"> <el-input v-model="queryForm.name" placeholder="书名"></el-input> </el-form-item> <el-form-item> <el-button type="primary" @click="handleQuery">查询</el-button> <el-button type="default" @click="resetQuery" style="margin-left: 10px;">复原</el-button> </el-form-item> </el-form> <el-button type="primary" style="margin-top: 20px;" @click="handleMyBorrowed">我的借阅</el-button> <el-table :data="tableData" tooltip-effect="dark" style="width: 100%; margin-top: 20px;" @selection-change="handleSelectionChange" > <el-table-column type="selection" width="55"></el-table-column> <el-table-column prop="name" label="书名" width="180"></el-table-column> <el-table-column prop="publisher" label="出版社" width="180"></el-table-column> <el-table-column prop="author" label="作者" width="180"></el-table-column> <el-table-column label="数量" prop="quantity" width="100"></el-table-column> <el-table-column label="存入时间" width="180"> <template #default="{ row }"> {{ formatDateTime(row.storeTime) }} </template> </el-table-column> <el-table-column label="操作" width="120"> <template #default="{ row }"> <el-button size="mini" @click="handleBorrow(row)">借阅</el-button> </template> </el-table-column> </el-table> <el-pagination @size-change="handleSizeChange" @current-change="handlePageChange" :current-page="currentPage" :page-sizes="[10, 20, 30, 40]" :page-size="pageSize" layout="total, sizes, prev, pager, next, jumper" style="text-align: right; margin-top: 20px;"> </el-pagination> <!-- 我的借阅记录对话框 --> <el-dialog title="我的借阅记录" :visible.sync="myBorrowedVisible"> <el-table :data="myBorrowedData" style="width: 100%"> <el-table-column prop="bookName" label="书名" width="180"></el-table-column> <el-table-column prop="borrowTime" label="借阅时间" width="180"></el-table-column> <el-table-column prop="returnTime" label="归还时间" width="180"></el-table-column> </el-table> </el-dialog> </el-main> </el-container> </el-container>在上面代码的基础上添加功能:点击借阅(可以批量借阅,但借阅过的书和数量为0的书不允许框选),就会自动加到我的借阅里面,点击我的借阅,跳出一个弹窗,需要输入用户名和密码核验正确才能查看我借阅的书籍,点击确认借阅,books表的所对应的书籍会减1,并且数据库会存入借书人的用户名,密码,借的书名,借书时间(borrow表)。-- CREATE TABLE books ( -- id INT PRIMARY KEY AUTO_INCREMENT, -- name VARCHAR(255) NOT NULL, -- publisher VARCHAR(255) NOT NULL, -- author VARCHAR(255) NOT NULL, -- store_time DATETIME NOT NULL, -- quantity INT NOT NULL -- );
-- CREATE TABLE users ( -- id BIGINT AUTO_INCREMENT PRIMARY KEY, -- username VARCHAR(50) NOT NULL UNIQUE, -- password VARCHAR(255) NOT NULL, -- role VARCHAR(20) NOT NULL, -- created_at TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP -- );package com.wwq.bookproject.pojo;
import lombok.AllArgsConstructor; import lombok.Data; import lombok.NoArgsConstructor; import java.time.LocalDateTime;
@Data @NoArgsConstructor @AllArgsConstructor public class Book { private Integer id; // 书ID private String name; // 书名 private String publisher; // 出版社 private String author; // 作者 private LocalDateTime storeTime; // 存入时间 private Integer quantity; // 书的数量 } package com.wwq.bookproject.controller;
import com.wwq.bookproject.pojo.Book; import com.wwq.bookproject.pojo.PageBean; import com.wwq.bookproject.pojo.Result; import com.wwq.bookproject.service.BookService; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.format.annotation.DateTimeFormat; import org.springframework.web.bind.annotation.*;
import java.time.LocalDateTime; import java.util.List;
@Slf4j @RestController @RequestMapping("/books") public class BookController {
@Autowired private BookService bookService; @GetMapping public Result page(@RequestParam(defaultValue = "1") Integer page, @RequestParam(defaultValue = "10") Integer pageSize, String name, String publisher, String author, @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss") LocalDateTime begin, @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss") LocalDateTime end) { log.info("分页查询, 参数: {},{},{},{},{},{}", page, pageSize, name, publisher, author, begin, end); PageBean pageBean = bookService.page(page, pageSize, name, publisher, author, begin, end); return Result.success(pageBean); } @DeleteMapping("/{ids}") public Result delete(@PathVariable List<Integer> ids) { log.info("批量删除操作,ids:{}", ids); bookService.delete(ids); return Result.success(); } @PostMapping public Result save(@RequestBody Book book) { bookService.save(book); return Result.success(); } @GetMapping("/{id}") public Result getById(@PathVariable Integer id) { log.info("根据ID查询信息,id:{}", id); Book book = bookService.getById(id); return Result.success(book); } @PutMapping public Result update(@RequestBody Book book) { log.info("更新图书信息:{}", book); bookService.update(book); return Result.success(); }} package com.wwq.bookproject.mapper;
import com.wwq.bookproject.pojo.Book; import org.apache.ibatis.annotations.*; import java.time.LocalDateTime; import java.util.List;
/**
-
书籍Mapper接口 */ @Mapper public interface BookMapper {
/**
- 查询书籍总数
- @return 书籍总数 / @Select("SELECT COUNT() FROM books") Long count();
/**
- 条件查询书籍列表
- @param name 书籍名称
- @param publisher 出版社
- @param author 作者
- @param begin 上架开始时间
- @param end 上架结束时间
- @return 书籍列表 */ @Select("" + "SELECT * FROM books" + "" + "" + "name LIKE CONCAT('%', #{name}, '%')" + "" + "" + "AND publisher = #{publisher}" + "" + "" + "AND author = #{author}" + "" + "" + "AND store_time BETWEEN #{begin} AND #{end}" + "" + "" + "ORDER BY store_time DESC" + "") List list(String name, String publisher, String author, LocalDateTime begin, LocalDateTime end);
/**
- 根据id列表批量删除书籍
- @param ids 书籍id列表 */ @Delete("" + "DELETE FROM books WHERE id IN" + "" + "#{id}" + "" + "") void delete(@Param("ids") List ids);
/**
- 新增书籍
- @param book 书籍对象 */ @Insert("INSERT INTO books(name, publisher, author, store_time, quantity) " + "VALUES(#{name}, #{publisher}, #{author}, #{storeTime}, #{quantity})") void save(Book book);
/**
- 根据id查询书籍
- @param id 书籍id
- @return 书籍对象 */ @Select("SELECT * FROM books WHERE id = #{id}") Book getById(Integer id);
/**
- 更新书籍信息
- @param book 书籍对象 */ @Update("UPDATE books SET name = #{name}, publisher = #{publisher}, author = #{author}, store_time = #{storeTime}, quantity = #{quantity} WHERE id = #{id}") void update(Book book); } package com.wwq.bookproject.service.impl;
import com.github.pagehelper.Page; import com.github.pagehelper.PageHelper; import com.wwq.bookproject.mapper.BookMapper; import com.wwq.bookproject.pojo.Book; import com.wwq.bookproject.pojo.PageBean; import com.wwq.bookproject.service.BookService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service;
import java.time.LocalDateTime; import java.util.List;
@Service public class BookServiceImpl implements BookService {
@Autowired private BookMapper bookMapper; @Override public PageBean page(Integer page, Integer pageSize, String name, String publisher, String author, LocalDateTime begin, LocalDateTime end) { PageHelper.startPage(page, pageSize); List<Book> bookList = bookMapper.list(name, publisher, author, begin, end); Page<Book> pageInfo = (Page<Book>) bookList; PageBean pageBean = new PageBean(pageInfo.getTotal(), pageInfo.getResult()); return pageBean; } @Override public void delete(List<Integer> ids) { bookMapper.delete(ids); } @Override public void save(Book book) { book.setStoreTime(LocalDateTime.now()); bookMapper.save(book); } @Override public Book getById(Integer id) { return bookMapper.getById(id); } @Override public void update(Book book) { book.setStoreTime(LocalDateTime.now()); // 这里可以根据实际情况决定是否更新存入时间 bookMapper.update(book); }} package com.wwq.bookproject.service;
import com.wwq.bookproject.pojo.Book; import com.wwq.bookproject.pojo.PageBean; import java.time.LocalDateTime; import java.util.List;
public interface BookService { PageBean page(Integer page, Integer pageSize, String name, String publisher, String author, LocalDateTime begin, LocalDateTime end); void delete(List ids); void save(Book book); Book getById(Integer id); void update(Book book); }
package com.wwq.bookproject.controller;
import com.wwq.bookproject.pojo.User; import com.wwq.bookproject.service.UserService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.http.ResponseEntity; import org.springframework.web.bind.annotation.*;
@RestController @RequestMapping("/loginRegister") public class AuthController {
@Autowired private UserService userService; // 注册 @PostMapping("/register") public ResponseEntity<String> register(@RequestBody User user) { // 在注册用户时,统一加密密码 userService.register(user); return ResponseEntity.ok("注册成功!"); } // 登录 @PostMapping("/login") public ResponseEntity<User> login(@RequestBody User loginRequest) { // 登录时校验用户名和密码 User user = userService.login(loginRequest.getUsername(), loginRequest.getPassword()); if (user == null) { return ResponseEntity.status(401).body(null); // 用户不存在或密码错误 } return ResponseEntity.ok(user); // 登录成功,返回用户信息 }} package com.wwq.bookproject.mapper;
import com.wwq.bookproject.pojo.User; import org.apache.ibatis.annotations.*;
@Mapper public interface UserMapper {
@Insert("INSERT INTO users (username, password, role) VALUES (#{username}, #{password}, #{role})") void register(User user); // 根据用户名查询用户信息 @Select("SELECT * FROM users WHERE username = #{username}") User findByUsername(@Param("username") String username);} package com.wwq.bookproject.pojo;
import org.springframework.security.crypto.bcrypt.BCryptPasswordEncoder;
public class PasswordUtils {
private static final BCryptPasswordEncoder encoder = new BCryptPasswordEncoder(); // 密码加密方法 public static String encode(String rawPassword) { return encoder.encode(rawPassword); } // 校验用户输入的密码是否匹配数据库中的加密密码 public static boolean matches(String rawPassword, String encodedPassword) { return encoder.matches(rawPassword, encodedPassword); } public static void main(String[] args) { String rawPassword = "123456"; // 明文密码 String encryptedPassword = PasswordUtils.encode(rawPassword); // 加密密码 System.out.println("明文密码: " + rawPassword); System.out.println("加密后的密码: " + encryptedPassword); }// INSERT INTO users (username, password, role) // VALUES ('root', '10$0NUEwzJp1Vu6MzR0Sd/M7OFun2CByNSnJOSo8uStrkm0dcMxMhgYS', 'ADMIN');
} package com.wwq.bookproject.pojo;
import lombok.Data;
@Data public class User { private Long id; private String username; private String password; private String role; // USER or ADMIN private String createdAt; } package com.wwq.bookproject.service.impl;
import com.wwq.bookproject.pojo.PasswordUtils; import com.wwq.bookproject.pojo.User; import com.wwq.bookproject.mapper.UserMapper; import com.wwq.bookproject.service.UserService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service;
@Service public class UserServiceImpl implements UserService {
@Autowired private UserMapper userMapper; @Override public void register(User user) { // 对用户密码加密存储 user.setPassword(PasswordUtils.encode(user.getPassword())); userMapper.register(user); } @Override public User login(String username, String password) { // 通过用户名查询用户信息 User user = userMapper.findByUsername(username); if (user == null || !PasswordUtils.matches(password, user.getPassword())) { return null; // 用户不存在 或 密码错误 } return user; // 登录成功 }} package com.wwq.bookproject.service;
import com.wwq.bookproject.pojo.User;
public interface UserService { void register(User user); // 用户注册 User login(String username, String password); // 用户登录 }
-
- Assistant
为了添加新功能,我们将扩展现有的代码以支持批量借阅、借阅记录的弹窗显示以及附加的登录认证。以下是新的功能实现思路以及代码的详细补充。
主要思路
- 书籍状态校验:在前端禁用已借阅或库存为
0的书。 - 批量借阅逻辑:在后端加入接口处理多个书籍的借阅操作,更新库存,并记录借阅表(
borrow表)。 - 用户认证:在查看借阅记录前,验证用户的用户名和密码。
- 更新前端交互:支持上述操作的所有 UI 和后端相对应的接口调用。
前端部分更新
我们需要进行以下更改:
借阅和我的借阅记录功能更新。- 借阅验证弹窗:添加用户名与密码输入框。
- 禁用借阅规则:当书库存为
0或已借阅时,禁用这些书的选择框。
修改后的前端代码
<template> <div> <!-- 侧边栏和主要页面布局不变 --> <!-- 新增借阅验证弹窗 --> <el-dialog title="借阅验证" :visible.sync="authDialogVisible" width="400px"> <el-form :model="authForm" label-width="80px"> <el-form-item label="用户名"> <el-input v-model="authForm.username"></el-input> </el-form-item> <el-form-item label="密码"> <el-input v-model="authForm.password" type="password"></el-input> </el-form-item> </el-form> <div slot="footer" class="dialog-footer"> <el-button @click="authDialogVisible = false">取消</el-button> <el-button type="primary" @click="confirmAuth">确定</el-button> </div> </el-dialog> <!-- 其余内容保持不变 --> <el-button type="primary" :disabled="selectedRows.length === 0" @click="handleBorrowBatch"> 确认借阅 </el-button> </div> </template> <script> import axios from 'axios'; export default { data() { return { queryForm: { name: '' }, tableData: [], selectedRows: [], authDialogVisible: false, authForm: { username: '', password: '', }, }; }, methods: { // 检查已选择的书籍是否合法(库存大于0,未借阅) canBorrowBook(row) { return row.quantity > 0 && !this.isAlreadyBorrowed(row); }, // 批量借阅 async handleBorrowBatch() { // 打开认证对话框 this.authDialogVisible = true; }, // 确认身份并借阅书籍 async confirmAuth() { try { const { username, password } = this.authForm; const loginResponse = await axios.post('http://localhost:8080/loginRegister/login', { username, password }); if (loginResponse.status === 200) { const borrowedBooks = this.selectedRows.map((book) => ({ bookId: book.id, quantity: 1, // 每次借阅一本 })); // 调用后端借阅接口 const borrowResponse = await axios.post('http://localhost:8080/borrow', { username, borrowedBooks, }); if (borrowResponse.data.code === 1) { this.authDialogVisible = false; this.$message.success('借阅成功'); this.handleQuery(); // 刷新书籍列表 } else { this.$message.error(borrowResponse.data.msg || '借阅失败'); } } else { this.$message.error('用户名或密码错误'); } } catch (error) { this.$message.error('身份验证失败,请重试'); } }, // 判定是否已借阅此书籍 isAlreadyBorrowed(row) { return this.myBorrowedData.some((item) => item.bookName === row.name); }, }, mounted() { this.handleQuery(); }, }; </script>
后端部分更新
-
新增数据库表
borrow:CREATE TABLE borrow ( id INT AUTO_INCREMENT PRIMARY KEY, user_id INT NOT NULL, book_id INT NOT NULL, borrow_time DATETIME NOT NULL, return_time DATETIME, FOREIGN KEY (user_id) REFERENCES users(id), FOREIGN KEY (book_id) REFERENCES books(id) ); -
新增
BorrowController:用于批量借阅书籍。@Slf4j @RestController @RequestMapping("/borrow") public class BorrowController { @Autowired private BorrowService borrowService; @PostMapping public Result batchBorrow(@RequestBody Map<String, Object> borrowRequest) { String username = (String) borrowRequest.get("username"); List<Map<String, Object>> books = (List<Map<String, Object>>) borrowRequest.get("borrowedBooks"); borrowService.batchBorrow(username, books); return Result.success("借阅成功"); } } -
新增
BorrowService:核心借阅逻辑的服务层。@Service public class BorrowServiceImpl implements BorrowService { @Autowired private UserMapper userMapper; @Autowired private BookMapper bookMapper; @Autowired private BorrowMapper borrowMapper; @Transactional public void batchBorrow(String username, List<Map<String, Object>> books) { // 查找用户信息 User user = userMapper.findByUsername(username); if (user == null) { throw new RuntimeException("用户不存在"); } for (Map<String, Object> bookRequest : books) { Integer bookId = (Integer) bookRequest.get("bookId"); Integer quantity = (Integer) bookRequest.get("quantity"); // 更新库存 Book book = bookMapper.getById(bookId); if (book.getQuantity() < quantity) { throw new RuntimeException("库存不足:" + book.getName()); } book.setQuantity(book.getQuantity() - quantity); bookMapper.update(book); // 添加借阅记录 Borrow borrow = new Borrow(null, user.getId(), bookId, LocalDateTime.now(), null); borrowMapper.save(borrow); } } } -
BorrowMapper接口:数据层代码。@Mapper public interface BorrowMapper { @Insert("INSERT INTO borrow (user_id, book_id, borrow_time) VALUES (#{userId}, #{bookId}, #{borrowTime})") void save(Borrow borrow); }
提交的完整功能
- 借阅时校验库存和重复借阅。
- 支持多本书的批量借阅。
- 用户需输入用户名和密码,验证通过后方可借阅。
- 后端更新书籍库存,并记录借阅信息至
borrow表。
- 书籍状态校验:在前端禁用已借阅或库存为
- User
-- publisher VARCHAR(255) NOT NULL, -- author VARCHAR(255) NOT NULL, -- store_time DATETIME NOT NULL, -- quantity INT NOT NULL -- );
-- CREATE TABLE users ( -- id BIGINT AUTO_INCREMENT PRIMARY KEY, -- username VARCHAR(50) NOT NULL UNIQUE, -- password VARCHAR(255) NOT NULL, -- role VARCHAR(20) NOT NULL, -- created_at TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP -- );
-- -- INSERT INTO users (username, password, role) -- VALUES ('root', '10$0NUEwzJp1Vu6MzR0Sd/M7OFun2CByNSnJOSo8uStrkm0dcMxMhgYS', 'ADMIN');
CREATE TABLE borrow ( id INT AUTO_INCREMENT PRIMARY KEY, user_id INT NOT NULL, book_id INT NOT NULL, borrow_time DATETIME NOT NULL, return_time DATETIME, FOREIGN KEY (user_id) REFERENCES users(id), FOREIGN KEY (book_id) REFERENCES books(id) )3780 - Referencing column 'user_id' and referenced column 'id' in foreign key constraint 'borrow_ibfk_1' are incompatible.
- Assistant
问题出现在外键约束中,因为
user_id和id列之间的数据类型不兼容。这是由users.id和borrow.user_id列的数据类型不同造成的。
错误分析:
-
users.id定义为BIGINT:id BIGINT AUTO_INCREMENT PRIMARY KEY -
borrow.user_id定义为INT:user_id INT NOT NULL
由于
BIGINT和INT是不同的数据类型,它们不兼容。因此,在定义外键时导致了此错误。
修复方法:
确保
borrow.user_id和users.id数据类型一致。为了兼容,可以将borrow.user_id数据类型更改为BIGINT。修正后的
borrow表定义:CREATE TABLE borrow ( id INT AUTO_INCREMENT PRIMARY KEY, user_id BIGINT NOT NULL, -- 修正为 BIGINT 和 users.id 类型一致 book_id INT NOT NULL, borrow_time DATETIME NOT NULL, return_time DATETIME, FOREIGN KEY (user_id) REFERENCES users(id), -- 外键引用 users.id FOREIGN KEY (book_id) REFERENCES books(id) -- 外键引用 books.id );
逻辑解释:
- 外键引用规则:外键引用要求父表(
users表中id)的列与引用表(borrow表中user_id)的列数据类型必须兼容。两者可以是相同的类型,例如BIGINT和BIGINT。 - 统一类型:将
borrow.user_id数据类型改为BIGINT,以确保与users.id的配置一致。
验证操作:
-
删除已存在的
borrow表(如果表存在):DROP TABLE IF EXISTS borrow; -
使用修正后的 SQL 重新创建
borrow表:CREATE TABLE borrow ( id INT AUTO_INCREMENT PRIMARY KEY, user_id BIGINT NOT NULL, book_id INT NOT NULL, borrow_time DATETIME NOT NULL, return_time DATETIME, FOREIGN KEY (user_id) REFERENCES users(id), FOREIGN KEY (book_id) REFERENCES books(id) ); -
若执行无错误,说明修复成功。
另一种修复方法:
如果不想更改
borrow.user_id类型为BIGINT,另一种方法是更改users.id类型为INT。通常,按设计id类型应统一建议使用BIGINT,以确保未来系统更大的数据范围兼容。-- 修改 users 表的 id 类型为 INT(谨慎使用,因为会影响现有设计) ALTER TABLE users MODIFY id INT AUTO_INCREMENT; -
- User
<!-- 头部 --> <el-header style="font-family: 楷体;text-align: center;font-weight: bold;background-color:rgb(254, 64, 74);color: white;font-size: 50px;"> 红色精神图书管理系统 </el-header> <!-- 主要内容区域 --> <el-main> <el-form :inline="true" :model="queryForm" class="demo-form-inline" style="margin-bottom: 20px;"> <el-form-item label="书名"> <el-input v-model="queryForm.name" placeholder="书名"></el-input> </el-form-item> <el-form-item> <el-button type="primary" @click="handleQuery">查询</el-button> <el-button type="default" @click="resetQuery" style="margin-left: 10px;">复原</el-button> </el-form-item> </el-form> <el-button type="primary" style="margin-top: 20px;" @click="handleMyBorrowed">我的借阅</el-button> <el-table :data="tableData" tooltip-effect="dark" style="width: 100%; margin-top: 20px;" @selection-change="handleSelectionChange" > <el-table-column type="selection" width="55"></el-table-column> <el-table-column prop="name" label="书名" width="180"></el-table-column> <el-table-column prop="publisher" label="出版社" width="180"></el-table-column> <el-table-column prop="author" label="作者" width="180"></el-table-column> <el-table-column label="数量" prop="quantity" width="100"></el-table-column> <el-table-column label="存入时间" width="180"> <template #default="{ row }"> {{ formatDateTime(row.storeTime) }} </template> </el-table-column> <el-table-column label="操作" width="120"> <template #default="{ row }"> <el-button size="mini" @click="handleBorrow(row)">借阅</el-button> </template> </el-table-column> </el-table> <el-pagination @size-change="handleSizeChange" @current-change="handlePageChange" :current-page="currentPage" :page-sizes="[10, 20, 30, 40]" :page-size="pageSize" layout="total, sizes, prev, pager, next, jumper" style="text-align: right; margin-top: 20px;"> </el-pagination> <!-- 我的借阅记录对话框 --> <el-dialog title="我的借阅记录" :visible.sync="myBorrowedVisible"> <el-table :data="myBorrowedData" style="width: 100%"> <el-table-column prop="bookName" label="书名" width="180"></el-table-column> <el-table-column prop="borrowTime" label="借阅时间" width="180"></el-table-column> <el-table-column prop="returnTime" label="归还时间" width="180"></el-table-column> </el-table> </el-dialog> </el-main> </el-container> </el-container>帮我写数据库和springboot后端(controller,mapper,pojo,service,service.impl)
- Assistant
以下是基于你提供的前端逻辑,编写的完整
数据库表设计和Spring Boot 后端实现(包括Pojo,Mapper,Service,Controller的代码)。
数据库设计
-
users表:用户表用于存储用户信息。CREATE TABLE users ( id BIGINT AUTO_INCREMENT PRIMARY KEY, username VARCHAR(50) NOT NULL UNIQUE, password VARCHAR(255) NOT NULL, role VARCHAR(20) NOT NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); -
books表:用于存储书籍信息。CREATE TABLE books ( id INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(255) NOT NULL, publisher VARCHAR(255) NOT NULL, author VARCHAR(255) NOT NULL, store_time DATETIME NOT NULL, quantity INT NOT NULL ); -
borrow表:借阅记录表。CREATE TABLE borrow ( id INT PRIMARY KEY AUTO_INCREMENT, user_id BIGINT NOT NULL, book_id INT NOT NULL, borrow_time DATETIME NOT NULL, return_time DATETIME, FOREIGN KEY (user_id) REFERENCES users(id), FOREIGN KEY (book_id) REFERENCES books(id) );
实体类 (Pojo)
-
User实体package com.example.library.pojo; import lombok.Data; @Data public class User { private Long id; private String username; private String password; private String role; // USER or ADMIN private String createdAt; } -
Book实体package com.example.library.pojo; import lombok.Data; import java.time.LocalDateTime; @Data public class Book { private Integer id; private String name; private String publisher; private String author; private LocalDateTime storeTime; private Integer quantity; } -
Borrow实体package com.example.library.pojo; import lombok.Data; import java.time.LocalDateTime; @Data public class Borrow { private Integer id; private Long userId; private Integer bookId; private LocalDateTime borrowTime; private LocalDateTime returnTime; }
数据访问层 (Mapper)
-
BookMapper@Mapper public interface BookMapper { // 查询所有书籍(分页) List<Book> findAllBooks(String name, Integer offset, Integer limit); // 根据 ID 查询书籍 Book findBookById(Integer id); // 借阅更新书籍库存 int updateBookQuantity(Integer bookId, Integer quantity); } -
BorrowMapper@Mapper public interface BorrowMapper { // 新增借阅记录 int addBorrowRecord(Borrow borrow); // 查询某用户的借阅记录 List<Borrow> findBorrowedBooksByUserId(Long userId); } -
UserMapper@Mapper public interface UserMapper { // 根据用户名查询 User findByUsername(String username); // 根据 ID 查找用户 User findById(Long id); }
服务层 (Service)
-
接口
BookServicepublic interface BookService { List<Book> getAllBooks(String name, Integer page, Integer size); void borrowBook(Long userId, Integer bookId); } -
接口
BorrowServicepublic interface BorrowService { List<Borrow> getBorrowRecords(Long userId); } -
实现类
BookServiceImpl@Service public class BookServiceImpl implements BookService { @Autowired private BookMapper bookMapper; @Autowired private BorrowMapper borrowMapper; @Override public List<Book> getAllBooks(String name, Integer page, Integer size) { int offset = (page - 1) * size; return bookMapper.findAllBooks(name, offset, size); } @Override @Transactional public void borrowBook(Long userId, Integer bookId) { Book book = bookMapper.findBookById(bookId); if (book == null || book.getQuantity() <= 0) { throw new RuntimeException("书本库存不足或不存在"); } // 更新书籍库存 bookMapper.updateBookQuantity(bookId, book.getQuantity() - 1); // 添加借阅记录 Borrow borrow = new Borrow(); borrow.setUserId(userId); borrow.setBookId(bookId); borrow.setBorrowTime(LocalDateTime.now()); borrowMapper.addBorrowRecord(borrow); } } -
实现类
BorrowServiceImpl@Service public class BorrowServiceImpl implements BorrowService { @Autowired private BorrowMapper borrowMapper; @Override public List<Borrow> getBorrowRecords(Long userId) { return borrowMapper.findBorrowedBooksByUserId(userId); } }
控制层 (Controller)
-
BookController@RestController @RequestMapping("/books") public class BookController { @Autowired private BookService bookService; @GetMapping public Result getBooks(@RequestParam(defaultValue = "1") Integer page, @RequestParam(defaultValue = "10") Integer size, @RequestParam(required = false) String name) { List<Book> books = bookService.getAllBooks(name, page, size); return Result.success(books); } @PostMapping("/borrow/{bookId}") public Result borrowBook(@PathVariable Integer bookId, @RequestParam Long userId) { bookService.borrowBook(userId, bookId); return Result.success("借阅成功"); } } -
BorrowController@RestController @RequestMapping("/borrow") public class BorrowController { @Autowired private BorrowService borrowService; @GetMapping("/my-borrowed") public Result getMyBorrowedBooks(@RequestParam Long userId) { List<Borrow> borrowRecords = borrowService.getBorrowRecords(userId); return Result.success(borrowRecords); } }
通用结果封装
public class Result { private int code; private String msg; private Object data; public static Result success(Object data) { Result result = new Result(); result.setCode(1); result.setMsg("成功"); result.setData(data); return result; } public static Result error(String message) { Result result = new Result(); result.setCode(0); result.setMsg(message); return result; } // Getters & Setters ... }
总结
上述代码包含了完整的
Spring Boot实现,包括数据库设计、实体类、Mapper 接口、Service 层逻辑以及 Controller 接口。如果需要添加更多功能,例如用户认证(登录、权限校验等),还需要进一步处理用户会话管理等细节。 -
- User
导航栏 首页 借阅系统
<!-- 头部 --> <el-header style="font-family: 楷体;text-align: center;font-weight: bold;background-color:rgb(254, 64, 74);color: white;font-size: 50px;"> 红色精神图书管理系统 </el-header> <!-- 主要内容区域 --> <el-main> <el-form :inline="true" :model="queryForm" class="demo-form-inline" style="margin-bottom: 20px;"> <el-form-item label="书名"> <el-input v-model="queryForm.name" placeholder="书名"></el-input> </el-form-item> <el-form-item> <el-button type="primary" @click="handleQuery">查询</el-button> <el-button type="default" @click="resetQuery" style="margin-left: 10px;">复原</el-button> </el-form-item> </el-form><!-- 头部 --> <el-header style="font-family: 楷体;text-align: center;font-weight: bold;background-color:rgb(254, 64, 74);color: white;font-size: 50px;"> 红色精神图书管理系统 </el-header> <!-- 主要内容区域 --> <el-main> <el-form :inline="true" :model="queryForm" class="demo-form-inline" style="margin-bottom: 20px;"> <el-form-item label="书名"> <el-input v-model="queryForm.name" placeholder="书名"></el-input> </el-form-item> <el-form-item> <el-button type="primary" @click="handleQuery">查询</el-button> <el-button type="default" @click="resetQuery" style="margin-left: 10px;">复原</el-button> </el-form-item> </el-form> <el-button type="primary" style="margin-top: 20px;" @click="handleMyBorrowed">我的借阅</el-button> <el-table :data="tableData" tooltip-effect="dark" style="width: 100%; margin-top: 20px;" @selection-change="handleSelectionChange" > <el-table-column type="selection" width="55"></el-table-column> <el-table-column prop="name" label="书名" width="180"></el-table-column> <el-table-column prop="publisher" label="出版社" width="180"></el-table-column> <el-table-column prop="author" label="作者" width="180"></el-table-column> <el-table-column label="数量" prop="quantity" width="100"></el-table-column> <el-table-column label="存入时间" width="180"> <template #default="{ row }"> {{ formatDateTime(row.storeTime) }} </template> </el-table-column> <el-table-column label="操作" width="120"> <template #default="{ row }"> <el-button size="mini" @click="handleBorrow(row)">借阅</el-button> </template> </el-table-column> </el-table> <el-pagination @size-change="handleSizeChange" @current-change="handlePageChange" :current-page="currentPage" :page-sizes="[10, 20, 30, 40]" :page-size="pageSize" layout="total, sizes, prev, pager, next, jumper" style="text-align: right; margin-top: 20px;"> </el-pagination> <!-- 我的借阅记录对话框 --> <el-dialog title="我的借阅记录" :visible.sync="myBorrowedVisible"> <el-table :data="myBorrowedData" style="width: 100%"> <el-table-column prop="bookName" label="书名" width="180"></el-table-column> <el-table-column prop="borrowTime" label="借阅时间" width="180"></el-table-column> <el-table-column prop="returnTime" label="归还时间" width="180"></el-table-column> </el-table> </el-dialog> </el-main> </el-container> </el-container>帮我写数据库和springboot后端(controller,mapper,pojo,service,service.impl),我已经写好以下部分,根据功能帮忙修改或补充 CREATE TABLE books ( -- id INT PRIMARY KEY AUTO_INCREMENT, -- name VARCHAR(255) NOT NULL, -- publisher VARCHAR(255) NOT NULL, -- author VARCHAR(255) NOT NULL, -- store_time DATETIME NOT NULL, -- quantity INT NOT NULL -- );
-- CREATE TABLE users ( -- id BIGINT AUTO_INCREMENT PRIMARY KEY, -- username VARCHAR(50) NOT NULL UNIQUE, -- password VARCHAR(255) NOT NULL, -- role VARCHAR(20) NOT NULL, -- created_at TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP -- );package com.wwq.bookproject.pojo;
import lombok.AllArgsConstructor; import lombok.Data; import lombok.NoArgsConstructor; import java.time.LocalDateTime;
@Data @NoArgsConstructor @AllArgsConstructor public class Book { private Integer id; // 书ID private String name; // 书名 private String publisher; // 出版社 private String author; // 作者 private LocalDateTime storeTime; // 存入时间 private Integer quantity; // 书的数量 } package com.wwq.bookproject.controller;
import com.wwq.bookproject.pojo.Book; import com.wwq.bookproject.pojo.PageBean; import com.wwq.bookproject.pojo.Result; import com.wwq.bookproject.service.BookService; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.format.annotation.DateTimeFormat; import org.springframework.web.bind.annotation.*;
import java.time.LocalDateTime; import java.util.List;
@Slf4j @RestController @RequestMapping("/books") public class BookController {
@Autowired private BookService bookService; @GetMapping public Result page(@RequestParam(defaultValue = "1") Integer page, @RequestParam(defaultValue = "10") Integer pageSize, String name, String publisher, String author, @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss") LocalDateTime begin, @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss") LocalDateTime end) { log.info("分页查询, 参数: {},{},{},{},{},{}", page, pageSize, name, publisher, author, begin, end); PageBean pageBean = bookService.page(page, pageSize, name, publisher, author, begin, end); return Result.success(pageBean); } @DeleteMapping("/{ids}") public Result delete(@PathVariable List<Integer> ids) { log.info("批量删除操作,ids:{}", ids); bookService.delete(ids); return Result.success(); } @PostMapping public Result save(@RequestBody Book book) { bookService.save(book); return Result.success(); } @GetMapping("/{id}") public Result getById(@PathVariable Integer id) { log.info("根据ID查询信息,id:{}", id); Book book = bookService.getById(id); return Result.success(book); } @PutMapping public Result update(@RequestBody Book book) { log.info("更新图书信息:{}", book); bookService.update(book); return Result.success(); }} package com.wwq.bookproject.mapper;
import com.wwq.bookproject.pojo.Book; import org.apache.ibatis.annotations.*; import java.time.LocalDateTime; import java.util.List;
/**
-
书籍Mapper接口 */ @Mapper public interface BookMapper {
/**
- 查询书籍总数
- @return 书籍总数 / @Select("SELECT COUNT() FROM books") Long count();
/**
- 条件查询书籍列表
- @param name 书籍名称
- @param publisher 出版社
- @param author 作者
- @param begin 上架开始时间
- @param end 上架结束时间
- @return 书籍列表 */ @Select("" + "SELECT * FROM books" + "" + "" + "name LIKE CONCAT('%', #{name}, '%')" + "" + "" + "AND publisher = #{publisher}" + "" + "" + "AND author = #{author}" + "" + "" + "AND store_time BETWEEN #{begin} AND #{end}" + "" + "" + "ORDER BY store_time DESC" + "") List list(String name, String publisher, String author, LocalDateTime begin, LocalDateTime end);
/**
- 根据id列表批量删除书籍
- @param ids 书籍id列表 */ @Delete("" + "DELETE FROM books WHERE id IN" + "" + "#{id}" + "" + "") void delete(@Param("ids") List ids);
/**
- 新增书籍
- @param book 书籍对象 */ @Insert("INSERT INTO books(name, publisher, author, store_time, quantity) " + "VALUES(#{name}, #{publisher}, #{author}, #{storeTime}, #{quantity})") void save(Book book);
/**
- 根据id查询书籍
- @param id 书籍id
- @return 书籍对象 */ @Select("SELECT * FROM books WHERE id = #{id}") Book getById(Integer id);
/**
- 更新书籍信息
- @param book 书籍对象 */ @Update("UPDATE books SET name = #{name}, publisher = #{publisher}, author = #{author}, store_time = #{storeTime}, quantity = #{quantity} WHERE id = #{id}") void update(Book book); } package com.wwq.bookproject.service.impl;
import com.github.pagehelper.Page; import com.github.pagehelper.PageHelper; import com.wwq.bookproject.mapper.BookMapper; import com.wwq.bookproject.pojo.Book; import com.wwq.bookproject.pojo.PageBean; import com.wwq.bookproject.service.BookService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service;
import java.time.LocalDateTime; import java.util.List;
@Service public class BookServiceImpl implements BookService {
@Autowired private BookMapper bookMapper; @Override public PageBean page(Integer page, Integer pageSize, String name, String publisher, String author, LocalDateTime begin, LocalDateTime end) { PageHelper.startPage(page, pageSize); List<Book> bookList = bookMapper.list(name, publisher, author, begin, end); Page<Book> pageInfo = (Page<Book>) bookList; PageBean pageBean = new PageBean(pageInfo.getTotal(), pageInfo.getResult()); return pageBean; } @Override public void delete(List<Integer> ids) { bookMapper.delete(ids); } @Override public void save(Book book) { book.setStoreTime(LocalDateTime.now()); bookMapper.save(book); } @Override public Book getById(Integer id) { return bookMapper.getById(id); } @Override public void update(Book book) { book.setStoreTime(LocalDateTime.now()); // 这里可以根据实际情况决定是否更新存入时间 bookMapper.update(book); }} package com.wwq.bookproject.service;
import com.wwq.bookproject.pojo.Book; import com.wwq.bookproject.pojo.PageBean; import java.time.LocalDateTime; import java.util.List;
public interface BookService { PageBean page(Integer page, Integer pageSize, String name, String publisher, String author, LocalDateTime begin, LocalDateTime end); void delete(List ids); void save(Book book); Book getById(Integer id); void update(Book book); }
package com.wwq.bookproject.controller;
import com.wwq.bookproject.pojo.User; import com.wwq.bookproject.service.UserService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.http.ResponseEntity; import org.springframework.web.bind.annotation.*;
@RestController @RequestMapping("/loginRegister") public class AuthController {
@Autowired private UserService userService; // 注册 @PostMapping("/register") public ResponseEntity<String> register(@RequestBody User user) { // 在注册用户时,统一加密密码 userService.register(user); return ResponseEntity.ok("注册成功!"); } // 登录 @PostMapping("/login") public ResponseEntity<User> login(@RequestBody User loginRequest) { // 登录时校验用户名和密码 User user = userService.login(loginRequest.getUsername(), loginRequest.getPassword()); if (user == null) { return ResponseEntity.status(401).body(null); // 用户不存在或密码错误 } return ResponseEntity.ok(user); // 登录成功,返回用户信息 }} package com.wwq.bookproject.mapper;
import com.wwq.bookproject.pojo.User; import org.apache.ibatis.annotations.*;
@Mapper public interface UserMapper {
@Insert("INSERT INTO users (username, password, role) VALUES (#{username}, #{password}, #{role})") void register(User user); // 根据用户名查询用户信息 @Select("SELECT * FROM users WHERE username = #{username}") User findByUsername(@Param("username") String username);} package com.wwq.bookproject.pojo;
import org.springframework.security.crypto.bcrypt.BCryptPasswordEncoder;
public class PasswordUtils {
private static final BCryptPasswordEncoder encoder = new BCryptPasswordEncoder(); // 密码加密方法 public static String encode(String rawPassword) { return encoder.encode(rawPassword); } // 校验用户输入的密码是否匹配数据库中的加密密码 public static boolean matches(String rawPassword, String encodedPassword) { return encoder.matches(rawPassword, encodedPassword); } public static void main(String[] args) { String rawPassword = "123456"; // 明文密码 String encryptedPassword = PasswordUtils.encode(rawPassword); // 加密密码 System.out.println("明文密码: " + rawPassword); System.out.println("加密后的密码: " + encryptedPassword); }// INSERT INTO users (username, password, role) // VALUES ('root', '10$0NUEwzJp1Vu6MzR0Sd/M7OFun2CByNSnJOSo8uStrkm0dcMxMhgYS', 'ADMIN');
} package com.wwq.bookproject.pojo;
import lombok.Data;
@Data public class User { private Long id; private String username; private String password; private String role; // USER or ADMIN private String createdAt; } package com.wwq.bookproject.service.impl;
import com.wwq.bookproject.pojo.PasswordUtils; import com.wwq.bookproject.pojo.User; import com.wwq.bookproject.mapper.UserMapper; import com.wwq.bookproject.service.UserService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service;
@Service public class UserServiceImpl implements UserService {
@Autowired private UserMapper userMapper; @Override public void register(User user) { // 对用户密码加密存储 user.setPassword(PasswordUtils.encode(user.getPassword())); userMapper.register(user); } @Override public User login(String username, String password) { // 通过用户名查询用户信息 User user = userMapper.findByUsername(username); if (user == null || !PasswordUtils.matches(password, user.getPassword())) { return null; // 用户不存在 或 密码错误 } return user; // 登录成功 }} package com.wwq.bookproject.service;
import com.wwq.bookproject.pojo.User;
public interface UserService { void register(User user); // 用户注册 User login(String username, String password); // 用户登录 }
-
- Assistant
根据你提供的代码,功能点已经大部分实现,包括用户的注册、登录,书籍的增删改查以及分页查询。但你希望补充完整借阅功能相关代码(包括数据库创建、后端
Controller、Service与Mapper的实现)。以下是完整实现补充,包括:书籍借阅、借阅记录查询等功能。
数据库补充
在现有的
books和users表结构中,添加borrow表来记录书籍借阅信息。CREATE TABLE borrow ( id INT AUTO_INCREMENT PRIMARY KEY, user_id BIGINT NOT NULL, -- 用户ID(外键) book_id INT NOT NULL, -- 图书ID(外键) borrow_time DATETIME NOT NULL, -- 借阅时间 return_time DATETIME, -- 归还时间 FOREIGN KEY (user_id) REFERENCES users(id), FOREIGN KEY (book_id) REFERENCES books(id) );
借阅功能后端实现
1.
Pojo借阅实体类新增
Borrow实体 POJO 类:package com.wwq.bookproject.pojo; import lombok.Data; import java.time.LocalDateTime; @Data public class Borrow { private Integer id; private Long userId; // 用户ID private Integer bookId; // 图书ID private LocalDateTime borrowTime; // 借阅时间 private LocalDateTime returnTime; // 归还时间(可为空) }
2.
Mapper借阅数据库访问层新增
BorrowMapper接口,用于处理借阅相关的操作。package com.wwq.bookproject.mapper; import com.wwq.bookproject.pojo.Borrow; import org.apache.ibatis.annotations.*; import java.util.List; @Mapper public interface BorrowMapper { // 新增借阅记录 @Insert("INSERT INTO borrow (user_id, book_id, borrow_time) VALUES (#{userId}, #{bookId}, #{borrowTime})") void addBorrowRecord(Borrow borrow); // 查询用户所有借阅记录 @Select("SELECT * FROM borrow WHERE user_id = #{userId}") List<Borrow> findBorrowedBooksByUserId(Long userId); // 更新归还时间(还书操作) @Update("UPDATE borrow SET return_time = #{returnTime} WHERE id = #{id}") void updateReturnTime(@Param("id") Integer id, @Param("returnTime") LocalDateTime returnTime); // 查找未归还的特定记录 @Select("SELECT * FROM borrow WHERE user_id = #{userId} AND book_id = #{bookId} AND return_time IS NULL") Borrow findUnreturnedRecord(@Param("userId") Long userId, @Param("bookId") Integer bookId); }
3.
Service借阅业务逻辑层新增
BorrowService接口,用于定义借阅功能的业务逻辑。package com.wwq.bookproject.service; import com.wwq.bookproject.pojo.Borrow; import java.time.LocalDateTime; import java.util.List; public interface BorrowService { void borrowBook(Long userId, Integer bookId); // 借书操作 void returnBook(Long userId, Integer bookId); // 还书操作 List<Borrow> findBorrowedBooks(Long userId); // 查询用户的借阅记录 }实现
BorrowService接口:package com.wwq.bookproject.service.impl; import com.wwq.bookproject.mapper.BookMapper; import com.wwq.bookproject.mapper.BorrowMapper; import com.wwq.bookproject.pojo.Book; import com.wwq.bookproject.pojo.Borrow; import com.wwq.bookproject.service.BorrowService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import java.time.LocalDateTime; import java.util.List; @Service public class BorrowServiceImpl implements BorrowService { @Autowired private BorrowMapper borrowMapper; @Autowired private BookMapper bookMapper; @Transactional @Override public void borrowBook(Long userId, Integer bookId) { // 检查书籍库存 Book book = bookMapper.getById(bookId); if (book == null || book.getQuantity() <= 0) { throw new RuntimeException("书籍库存不足或书籍不存在"); } // 减少书籍库存 bookMapper.update(new Book(bookId, book.getName(), book.getPublisher(), book.getAuthor(), LocalDateTime.now(), book.getQuantity() - 1)); // 新增借阅记录 Borrow borrow = new Borrow(); borrow.setUserId(userId); borrow.setBookId(bookId); borrow.setBorrowTime(LocalDateTime.now()); borrowMapper.addBorrowRecord(borrow); } @Transactional @Override public void returnBook(Long userId, Integer bookId) { // 查找是否有未归还的记录 Borrow borrow = borrowMapper.findUnreturnedRecord(userId, bookId); if (borrow == null) { throw new RuntimeException("没有找到未归还的记录"); } // 更新归还时间 borrowMapper.updateReturnTime(borrow.getId(), LocalDateTime.now()); // 增加书籍库存 Book book = bookMapper.getById(bookId); bookMapper.update(new Book(book.getId(), book.getName(), book.getPublisher(), book.getAuthor(), LocalDateTime.now(), book.getQuantity() + 1)); } @Override public List<Borrow> findBorrowedBooks(Long userId) { return borrowMapper.findBorrowedBooksByUserId(userId); } }
4.
Controller借阅控制层新增
BorrowController来实现借书和还书接口。package com.wwq.bookproject.controller; import com.wwq.bookproject.pojo.Borrow; import com.wwq.bookproject.pojo.Result; import com.wwq.bookproject.service.BorrowService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.*; import java.util.List; @RestController @RequestMapping("/borrow") public class BorrowController { @Autowired private BorrowService borrowService; // 借书接口 @PostMapping("/borrow/{bookId}") public Result borrowBook(@RequestParam Long userId, @PathVariable Integer bookId) { borrowService.borrowBook(userId, bookId); return Result.success("借阅成功"); } // 还书接口 @PostMapping("/return/{bookId}") public Result returnBook(@RequestParam Long userId, @PathVariable Integer bookId) { borrowService.returnBook(userId, bookId); return Result.success("归还成功"); } // 查询用户的借阅记录 @GetMapping("/history") public Result getBorrowHistory(@RequestParam Long userId) { List<Borrow> borrowedBooks = borrowService.findBorrowedBooks(userId); return Result.success(borrowedBooks); } }
改动 & 新增功能简述
- 数据库: 完善并新增了
borrow表。 - 后端功能:
- 借书操作:检查库存、减少库存、记录借阅。
- 还书操作:增加库存、更新借书记录的归还时间。
- 查询操作:获取用户所有的借阅历史。
- 面向接口的设计: 通过
Mapper和Service层分离逻辑,保证代码的可维护性。
希望这部分补充能符合你的需求!如果需要进一步改进优化,请随时告诉我!
- 数据库: 完善并新增了
- User
写一份接口文档让我测试一下
- Assistant
以下是关于书籍管理和借阅系统接口的详细文档,你可以根据此接口文档进行测试。
接口文档:红色精神图书管理系统
基础 URL:
http://localhost:8080
1. 用户相关接口
1.1 用户注册
接口地址:
/loginRegister/register
请求方法:POST请求参数:
参数名 类型 是否必填 示例值 说明 username String 是 "test_user" 用户名 password String 是 "123456" 用户密码 role String 是 "USER" 或 "ADMIN" 用户角色 请求示例:
{ "username": "test_user", "password": "123456", "role": "USER" }返回结果:
字段名 类型 说明 code Int 状态码,1代表成功 msg String 提示信息 返回示例:
{ "code": 1, "msg": "注册成功!" }
1.2 用户登录
接口地址:
/loginRegister/login
请求方法:POST请求参数:
参数名 类型 是否必填 示例值 说明 username String 是 "test_user" 用户名 password String 是 "123456" 用户密码 请求示例:
{ "username": "test_user", "password": "123456" }返回结果:
字段名 类型 说明 code Int 状态码,1代表成功 data Object 用户信息 返回示例:
{ "code": 1, "data": { "id": 1, "username": "test_user", "role": "USER", "createdAt": "2023-10-01T12:00:00" } }
2. 书籍相关接口
2.1 查询书籍列表
接口地址:
/books
请求方法:GET请求参数(Query 查询参数):
参数名 类型 是否必填 示例值 说明 name String 否 "书籍1" 按书名查询 page Int 否 1 当前页数 pageSize Int 否 10 每页显示记录数 请求示例:
GET /books?page=1&pageSize=10&name=书籍1返回结果:
字段名 类型 说明 code Int 状态码,1代表成功 data Object 包含分页的书籍信息 返回示例:
{ "code": 1, "data": { "total": 2, "rows": [ { "id": 1, "name": "书籍1", "publisher": "出版社1", "author": "作者A", "storeTime": "2023-10-05T08:30:00", "quantity": 5 }, { "id": 2, "name": "书籍2", "publisher": "出版社2", "author": "作者B", "storeTime": "2023-10-06T08:30:00", "quantity": 0 } ] } }
2.2 借阅书籍
接口地址:
/borrow/borrow/{bookId}
请求方法:POST请求参数(Path 参数 & Body 参数):
参数名 类型 是否必填 示例值 说明 userId Long 是 1 用户 ID bookId Int 是 1 图书 ID 请求示例:
POST /borrow/borrow/1 Content-Type: application/json { "userId": 1 }返回结果:
字段名 类型 说明 code Int 状态码,1代表成功 msg String 提示信息 返回示例:
{ "code": 1, "msg": "借阅成功" }
2.3 查询用户的借阅记录
接口地址:
/borrow/history
请求方法:GET请求参数:
参数名 类型 是否必填 示例值 说明 userId Long 是 1 用户 ID 请求示例:
GET /borrow/history?userId=1返回结果:
字段名 类型 说明 code Int 状态码,1代表成功 data List 借书记录 返回示例:
{ "code": 1, "data": [ { "id": 1, "userId": 1, "bookId": 1, "borrowTime": "2023-10-07T10:30:00", "returnTime": null }, { "id": 2, "userId": 1, "bookId": 2, "borrowTime": "2023-10-08T11:00:00", "returnTime": "2023-10-10T12:00:00" } ] }
2.4 归还书籍
接口地址:
/borrow/return/{bookId}
请求方法:POST请求参数:
参数名 类型 是否必填 示例值 说明 userId Long 是 1 用户 ID bookId Int 是 1 图书 ID 请求示例:
POST /borrow/return/1 Content-Type: application/json { "userId": 1 }返回结果:
字段名 类型 说明 code Int 状态码,1代表成功 msg String 提示信息 返回示例:
{ "code": 1, "msg": "归还成功" }
返回码说明
返回码 含义 1 请求成功 0 请求失败 401 未授权(登录失败) 404 资源未找到
测试工具建议
- 使用 Postman 或其他 API 测试工具 发送上述请求。
- 遵循接口文档,逐一验证注册、登录、书籍查询、借阅和归还操作。
希望这份接口文档能帮助你更好地测试功能!如果有任何问题,请随时反馈。
- User
<!-- 头部 --> <el-header style="font-family: 楷体;text-align: center;font-weight: bold;background-color:rgb(254, 64, 74);color: white;font-size: 50px;"> 红色精神图书管理系统 </el-header> <!-- 主要内容区域 --> <el-main> <el-form :inline="true" :model="queryForm" class="demo-form-inline" style="margin-bottom: 20px;"> <el-form-item label="书名"> <el-input v-model="queryForm.name" placeholder="书名"></el-input> </el-form-item> <el-form-item> <el-button type="primary" @click="handleQuery">查询</el-button> <el-button type="default" @click="resetQuery" style="margin-left: 10px;">复原</el-button> </el-form-item> </el-form> <el-button type="primary" style="margin-top: 20px;" @click="handleMyBorrowed">我的借阅</el-button> <el-table :data="tableData" tooltip-effect="dark" style="width: 100%; margin-top: 20px;" @selection-change="handleSelectionChange" > <el-table-column type="selection" width="55"></el-table-column> <el-table-column prop="name" label="书名" width="180"></el-table-column> <el-table-column prop="publisher" label="出版社" width="180"></el-table-column> <el-table-column prop="author" label="作者" width="180"></el-table-column> <el-table-column label="数量" prop="quantity" width="100"></el-table-column> <el-table-column label="存入时间" width="180"> <template #default="{ row }"> {{ formatDateTime(row.storeTime) }} </template> </el-table-column> <el-table-column label="操作" width="120"> <template #default="{ row }"> <el-button size="mini" @click="handleBorrow(row)">借阅</el-button> </template> </el-table-column> </el-table> <el-pagination @size-change="handleSizeChange" @current-change="handlePageChange" :current-page="currentPage" :page-sizes="[10, 20, 30, 40]" :page-size="pageSize" layout="total, sizes, prev, pager, next, jumper" style="text-align: right; margin-top: 20px;"> </el-pagination> <!-- 我的借阅记录对话框 --> <el-dialog title="我的借阅记录" :visible.sync="myBorrowedVisible"> <el-table :data="myBorrowedData" style="width: 100%"> <el-table-column prop="bookName" label="书名" width="180"></el-table-column> <el-table-column prop="borrowTime" label="借阅时间" width="180"></el-table-column> <el-table-column prop="returnTime" label="归还时间" width="180"></el-table-column> </el-table> </el-dialog> </el-main> </el-container> </el-container>package com.wwq.bookproject.controller;
import com.wwq.bookproject.pojo.Borrow; import com.wwq.bookproject.pojo.Result; import com.wwq.bookproject.service.BorrowService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.*;
import java.util.List;
@RestController @RequestMapping("/borrow") public class BorrowController {
@Autowired private BorrowService borrowService; // 借书接口 @PostMapping("/borrow/{bookId}") public Result borrowBook(@RequestParam Long userId, @PathVariable Integer bookId) { borrowService.borrowBook(userId, bookId); return Result.success("借阅成功"); } // 还书接口 @PostMapping("/return/{bookId}") public Result returnBook(@RequestParam Long userId, @PathVariable Integer bookId) { borrowService.returnBook(userId, bookId); return Result.success("归还成功"); } // 查询用户的借阅记录 @GetMapping("/history") public Result getBorrowHistory(@RequestParam Long userId) { List<Borrow> borrowedBooks = borrowService.findBorrowedBooks(userId); return Result.success(borrowedBooks); }} 帮忙修改前端的接口和后端匹配,可以数据互联
- Assistant
为了让前端和后端的接口正确匹配并完成数据交互,我们需要做以下几项工作:
- 前端需要根据后端接口的
URL、请求Method(POST/GET) 和参数格式进行调整。 - 验证
json数据的字段名,以确保与后端反序列化时一致。 - 对分页数据结构的字段做匹配(如
data.rows或data结构)。 - 修改借书和还书的行为,以适配
/borrow/borrow和/borrow/return的接口。
修改前端代码
以下是根据你的后端接口修改后的前端代码,其中涉及借书、归还书籍以及查询借阅数据的功能。
<script> import axios from 'axios'; export default { data() { return { queryForm: { name: '', // 查询字段 }, tableData: [], // 书籍列表 currentPage: 1, // 当前页码 pageSize: 10, // 每页大小 selectedRows: [], // 已选择的书籍 myBorrowedVisible: false, // 我的借阅记录弹窗是否显示 myBorrowedData: [], // 我的借阅记录数据 userId: 1, // 假设登录后获取的用户ID,可通过登录后后端返回设置真正的值 }; }, methods: { // 查询书籍列表 async handleQuery() { try { const response = await axios.get('http://localhost:8080/books', { params: { page: this.currentPage, pageSize: this.pageSize, name: this.queryForm.name, }, }); if (response.data.code === 1) { this.tableData = response.data.data.rows; // 与后端分页结果字段匹配 } else { this.$message.error(response.data.msg || '查询失败!'); } } catch (error) { this.$message.error('查询失败,请稍后重试!'); console.error(error); } }, // 重置查询 resetQuery() { this.queryForm.name = ''; this.handleQuery(); }, // 借书操作 async handleBorrow(row) { if (row.quantity <= 0) { this.$message.error('该书籍库存为0,无法借阅!'); return; } try { const response = await axios.post( `http://localhost:8080/borrow/borrow/${row.id}`, // 根据后端的接口路径 { userId: this.userId } ); if (response.data.code === 1) { this.$message.success('借阅成功!'); this.handleQuery(); // 更新书籍列表 } else { this.$message.error(response.data.msg || '借阅失败!'); } } catch (error) { this.$message.error('借阅失败,请稍后重试!'); console.error(error); } }, // 归还操作 async handleReturn(row) { try { const response = await axios.post( `http://localhost:8080/borrow/return/${row.id}`, // 根据后端的接口路径 { userId: this.userId } ); if (response.data.code === 1) { this.$message.success('归还成功!'); this.handleMyBorrowed(); // 更新我的借阅记录数据 } else { this.$message.error(response.data.msg || '归还失败!'); } } catch (error) { this.$message.error('归还失败,请稍后重试!'); console.error(error); } }, // 获取我的借阅记录 async handleMyBorrowed() { try { const response = await axios.get('http://localhost:8080/borrow/history', { params: { userId: this.userId }, }); if (response.data.code === 1) { this.myBorrowedData = response.data.data; // 设置我的借阅记录数据 this.myBorrowedVisible = true; // 打开弹窗 } else { this.$message.error(response.data.msg || '获取借阅记录失败!'); } } catch (error) { this.$message.error('获取借阅记录失败,请稍后重试!'); console.error(error); } }, // 页大小变化 handleSizeChange(val) { this.pageSize = val; this.handleQuery(); }, // 当前页变化 handlePageChange(val) { this.currentPage = val; this.handleQuery(); }, // 格式化时间 formatDateTime(value) { if (!value) return ''; return new Date(value).toLocaleString(); }, }, mounted() { this.handleQuery(); // 初始化时查询书籍数据 }, }; </script>
修改 UI 中借阅记录的操作列
针对借阅记录的数据,我们添加一个 "归还" 按钮,发起归还逻辑。
<!-- 我的借阅记录对话框 --> <el-dialog title="我的借阅记录" :visible.sync="myBorrowedVisible"> <el-table :data="myBorrowedData" style="width: 100%"> <el-table-column prop="bookId" label="书籍编号" width="100"></el-table-column> <el-table-column prop="borrowTime" label="借阅时间" width="180"> <template #default="{ row }"> {{ formatDateTime(row.borrowTime) }} </template> </el-table-column> <el-table-column prop="returnTime" label="归还时间" width="180"> <template #default="{ row }"> {{ row.returnTime ? formatDateTime(row.returnTime) : "未归还" }} </template> </el-table-column> <el-table-column label="操作" width="120"> <template #default="{ row }"> <el-button size="mini" :disabled="row.returnTime" <!-- 已归还禁用按钮 --> @click="handleReturn(row)" > 归还 </el-button> </template> </el-table-column> </el-table> </el-dialog>
测试说明
通过以下步骤测试接口和前端交互:
- 启动后端服务,确保接口
/books、/borrow/borrow、/borrow/return、/borrow/history可正常访问。 - 启动前端项目,进入页面:
- 查询书籍列表;
- 单击 借阅 按钮,测试借书接口;
- 单击 我的借阅 并在弹窗中单击 归还,测试归还接口以及数据自动刷新。
- 检查数据库中
borrow表,确保借书和归还的记录字段正确更新。
通过以上改动,你的前端与后端可以完成数据互联。如果还有其他需求,请随时告知!
- 前端需要根据后端接口的
- User
给我完整的前端代码
- Assistant
以下是完整的前端代码,基于你的需求进行了改进和完善,包括书籍查询、借阅、归还操作,以及我的借阅记录管理功能。
完整的
App.vue或主组件代码<template> <div> <el-container> <!-- 侧边栏 --> <el-aside style="width: 200px; min-height: 100vh; background-color: rgb(254, 64, 74)"> <div style="height: 60px; display: flex; align-items: center; justify-content: center;"> <img src="./photo/GH.jpg" alt="Logo" style="width: 100%; height: auto;"> </div> <el-menu class="custom-menu" style="width: 200px; background-color: #fe8f8f;" popper-append-to-body> <el-row> <el-col :span="12"> <el-menu class="custom-menu" style="width: 200px; background-color: #fe8f8f;" popper-append-to-body> <el-submenu index="1"> <template slot="title"> <i class="el-icon-location"></i> <span>导航栏</span> </template> <el-menu-item-group> <el-menu-item index="2"> <router-link to="/home#section1">首页</router-link> </el-menu-item> <el-menu-item index="4"> <router-link to="/borrow">借阅系统</router-link> </el-menu-item> </el-menu-item-group> </el-submenu> </el-menu> </el-col> </el-row> </el-menu> </el-aside> <el-container> <!-- 头部 --> <el-header style="font-family: 楷体; text-align: center; font-weight: bold; background-color: rgb(254, 64, 74); color: white; font-size: 50px;"> 红色精神图书管理系统 </el-header> <!-- 主内容 --> <el-main> <!-- 查询表单 --> <el-form :inline="true" :model="queryForm" class="demo-form-inline" style="margin-bottom: 20px;"> <el-form-item label="书名"> <el-input v-model="queryForm.name" placeholder="书名"></el-input> </el-form-item> <el-form-item> <el-button type="primary" @click="handleQuery">查询</el-button> <el-button type="default" @click="resetQuery" style="margin-left: 10px;">复原</el-button> </el-form-item> </el-form> <!-- 我的借阅 --> <el-button type="primary" style="margin-top: 20px;" @click="handleMyBorrowed">我的借阅</el-button> <!-- 书籍列表 --> <el-table :data="tableData" tooltip-effect="dark" style="width: 100%; margin-top: 20px;" @selection-change="handleSelectionChange" > <el-table-column type="selection" width="55"></el-table-column> <el-table-column prop="name" label="书名" width="180"></el-table-column> <el-table-column prop="publisher" label="出版社" width="180"></el-table-column> <el-table-column prop="author" label="作者" width="180"></el-table-column> <el-table-column label="数量" prop="quantity" width="100"></el-table-column> <el-table-column label="存入时间" width="180"> <template #default="{ row }"> {{ formatDateTime(row.storeTime) }} </template> </el-table-column> <el-table-column label="操作" width="120"> <template #default="{ row }"> <el-button size="mini" @click="handleBorrow(row)" :disabled="row.quantity <= 0">借阅</el-button> </template> </el-table-column> </el-table> <!-- 分页 --> <el-pagination @size-change="handleSizeChange" @current-change="handlePageChange" :current-page="currentPage" :page-sizes="[10, 20, 30, 40]" :page-size="pageSize" layout="total, sizes, prev, pager, next, jumper" style="text-align: right; margin-top: 20px;" > </el-pagination> <!-- 我的借阅记录 --> <el-dialog title="我的借阅记录" :visible.sync="myBorrowedVisible"> <el-table :data="myBorrowedData" style="width: 100%"> <el-table-column prop="bookId" label="书籍编号" width="100"></el-table-column> <el-table-column prop="borrowTime" label="借阅时间" width="180"> <template #default="{ row }"> {{ formatDateTime(row.borrowTime) }} </template> </el-table-column> <el-table-column prop="returnTime" label="归还时间" width="180"> <template #default="{ row }"> {{ row.returnTime ? formatDateTime(row.returnTime) : "未归还" }} </template> </el-table-column> <el-table-column label="操作" width="120"> <template #default="{ row }"> <el-button size="mini" :disabled="row.returnTime" <!-- 已归还禁用 --> @click="handleReturn(row)" > 归还 </el-button> </template> </el-table-column> </el-table> </el-dialog> </el-main> </el-container> </el-container> </div> </template> <script> import axios from 'axios'; export default { data() { return { queryForm: { name: '', // 查询条件 }, tableData: [], // 图书表格数据 currentPage: 1, // 当前页码 pageSize: 10, // 每页记录数 selectedRows: [], // 选择的行数据 myBorrowedVisible: false, // 我的借阅记录弹窗开关 myBorrowedData: [], // 我的借阅记录 userId: 1, // 登录用户 ID (通过后端登录返回获得实际 ID) }; }, methods: { // 查询书籍方法 async handleQuery() { try { const response = await axios.get('http://localhost:8080/books', { params: { page: this.currentPage, pageSize: this.pageSize, name: this.queryForm.name, }, }); if (response.data.code === 1) { this.tableData = response.data.data.rows; // 后端返回分页内容 } else { this.$message.error(response.data.msg || '查询失败!'); } } catch (error) { this.$message.error('查询失败,请稍后重试!'); console.error(error); } }, // 重置查询表单 resetQuery() { this.queryForm.name = ''; this.handleQuery(); }, // 借阅操作 async handleBorrow(row) { if (row.quantity <= 0) { this.$message.error('书籍库存不足,无法借阅!'); return; } try { const response = await axios.post(`http://localhost:8080/borrow/borrow/${row.id}`, { userId: this.userId, }); if (response.data.code === 1) { this.$message.success('借阅成功!'); this.handleQuery(); // 刷新书籍列表 } else { this.$message.error(response.data.msg || '借阅失败!'); } } catch (error) { this.$message.error('借阅失败,请稍后重试!'); console.error(error); } }, // 归还操作 async handleReturn(row) { try { const response = await axios.post(`http://localhost:8080/borrow/return/${row.bookId}`, { userId: this.userId, }); if (response.data.code === 1) { this.$message.success('归还成功!'); this.handleMyBorrowed(); // 刷新借阅记录 } else { this.$message.error(response.data.msg || '归还失败!'); } } catch (error) { this.$message.error('归还失败,请稍后重试!'); console.error(error); } }, // 获取我的借阅记录 async handleMyBorrowed() { try { const response = await axios.get('http://localhost:8080/borrow/history', { params: { userId: this.userId }, }); if (response.data.code === 1) { this.myBorrowedData = response.data.data; // 设置数据 this.myBorrowedVisible = true; // 打开弹窗 } else { this.$message.error(response.data.msg || '获取借阅记录失败!'); } } catch (error) { this.$message.error('获取借阅记录失败,请稍后重试!'); console.error(error); } }, // 分页控件 - 页大小变化 handleSizeChange(val) { this.pageSize = val; this.handleQuery(); }, // 分页控件 - 当前页变化 handlePageChange(val) { this.currentPage = val; this.handleQuery(); }, // 时间格式化 formatDateTime(value) { if (!value) return ''; return new Date(value).toLocaleString(); }, }, mounted() { this.handleQuery(); // 页面加载时调用查询 }, }; </script> <style scoped> .custom-menu.el-menu-item span, .custom-menu.el-menu-item { color: white !important; font-weight: bold; } .el-menu-item:hover { background-color: yellow !important; color: red !important; } .el-table .el-table__body-wrapper { margin-top: 10px; } .el-table .el-table__row { margin: 10px 0; } </style>
功能解释
- 查询书籍:通过
/books接口分页获取书籍列表。 - 借阅书籍:点击
借阅按钮调用/borrow/borrow/{bookId}接口。 - 归还书籍:点击
归还按钮时,调用/borrow/return/{bookId}接口。 - 我的借阅记录:弹窗展示
/borrow/history返回的用户借阅记录。
前端集成了
Element UI,实现了表单、表格、分页和弹出框功能。如果配合后端运行,应该可以实现完整的数据交互。如需优化或调整,请告诉我!
- 查询书籍:通过
- User
2024-12-03T14:41:11.180+08:00 WARN 18760 --- [Bookproject] [nio-8080-exec-3] .w.s.m.s.DefaultHandlerExceptionResolver : Resolved [org.springframework.web.bind.MissingServletRequestParameterException: Required request parameter 'userId' for method parameter type Long is not present] 2024-12-03T14:41:34.321+08:00 WARN 18760 --- [Bookproject] [nio-8080-exec-4] .w.s.m.s.DefaultHandlerExceptionResolver : Resolved [org.springframework.web.bind.MissingServletRequestParameterException: Required request parameter 'userId' for method parameter type Long is not present] 2024-12-03T14:41:34.529+08:00 WARN 18760 --- [Bookproject] [nio-8080-exec-5] .w.s.m.s.DefaultHandlerExceptionResolver : Resolved [org.springframework.web.bind.MissingServletRequestParameterException: Required request parameter 'userId' for method parameter type Long is not present]
- Assistant
从日志中的
MissingServletRequestParameterException错误来看,后端接口的参数userId未正确传递给后端方法,这是由于前端对于参数传递的方式未能完全匹配后端接口要求所引发的问题。
问题分析
错误原因
后端接口中有一个
@RequestParam("userId")注解修饰的参数,而前端调用的时候没有传递userId(或者传参方式不符合后端接口要求)。问题可能出在以下几种情况中:- 未正确传递
userId请求参数:@RequestParam是通过 URL 查询字符串传递的,但前端可能未在请求 URL 的query string中带上userId参数。
- POST 请求中未将
userId包装成 JSON 并正确传递。 - 前端和后端对于参数结构的字段名称或者传递方式不一致。
问题复现的场景
举例: 以下后端借书接口要求参数
userId使用@RequestParam接收。@PostMapping("/borrow/{bookId}") public Result borrowBook(@RequestParam Long userId, @PathVariable Integer bookId) { borrowService.borrowBook(userId, bookId); return Result.success("借阅成功"); }如果前端使用
axios.post()时,只传递了请求体(data字段),而没有通过 URL 的query string传递userId,那么后端自然无法接收到该参数。
解决方法
以下是两种解决方式,分别修正前端和后端,确保参数能够正确传递:
方法 1:修改前端,正确传递参数
借书接口前端修改
将借书接口的调用方式从传递
data参数改为通过params参数的方式在 URL 中传递userId。async handleBorrow(row) { if (row.quantity <= 0) { this.$message.error('书籍库存不足,无法借阅!'); return; } try { const response = await axios.post( `http://localhost:8080/borrow/borrow/${row.id}`, null, // POST 请求的 body 可为空 { params: { userId: this.userId }, // 将 userId 作为请求参数传递 } ); if (response.data.code === 1) { this.$message.success('借阅成功!'); this.handleQuery(); // 刷新书籍列表 } else { this.$message.error(response.data.msg || '借阅失败!'); } } catch (error) { this.$message.error('借阅失败,请稍后重试!'); console.error(error); } }归还接口前端修改
同理,修正归还接口调用,
userId通过params或者 URL query string 的方式传递。async handleReturn(row) { try { const response = await axios.post( `http://localhost:8080/borrow/return/${row.bookId}`, null, // POST 请求的 body 可为空 { params: { userId: this.userId }, // 将 userId 作为请求参数传递 } ); if (response.data.code === 1) { this.$message.success('归还成功!'); this.handleMyBorrowed(); // 刷新借阅记录 } else { this.$message.error(response.data.msg || '归还失败!'); } } catch (error) { this.$message.error('归还失败,请稍后重试!'); console.error(error); } }
方法 2:修改后端接口,接受
userId参数来自请求体如果不希望通过查询字符串传递参数,可以将后端接口的
userId修改为从请求体中提取。后端接口修改
将
userId从@RequestParam改为从请求体的 JSON 数据中提取。示例如下:// 数据封装的请求类 public class BorrowRequest { private Long userId; private Integer bookId; // Getters and Setters } // 改为接收请求体中的 JSON 数据 @PostMapping("/borrow/{bookId}") public Result borrowBook(@RequestBody BorrowRequest request, @PathVariable Integer bookId) { borrowService.borrowBook(request.getUserId(), bookId); return Result.success("借阅成功"); }修改归还接口
类似的,归还接口也可以做同样的修改:
@PostMapping("/return/{bookId}") public Result returnBook(@RequestBody BorrowRequest request, @PathVariable Integer bookId) { borrowService.returnBook(request.getUserId(), bookId); return Result.success("归还成功"); }修改前端代码——传递
userId和bookId的 JSON 数据如果后端支持从
@RequestBody接收参数,可以这样调用:async handleBorrow(row) { if (row.quantity <= 0) { this.$message.error('书籍库存不足,无法借阅!'); return; } try { const response = await axios.post( `http://localhost:8080/borrow/borrow/${row.id}`, { userId: this.userId, // 在 body 中传递 userId } ); if (response.data.code === 1) { this.$message.success('借阅成功!'); this.handleQuery(); // 刷新书籍列表 } else { this.$message.error(response.data.msg || '借阅失败!'); } } catch (error) { this.$message.error('借阅失败,请稍后重试!'); console.error(error); } } async handleReturn(row) { try { const response = await axios.post( `http://localhost:8080/borrow/return/${row.bookId}`, { userId: this.userId, // 在 body 中传递 userId } ); if (response.data.code === 1) { this.$message.success('归还成功!'); this.handleMyBorrowed(); // 刷新借阅记录 } else { this.$message.error(response.data.msg || '归还失败!'); } } catch (error) { this.$message.error('归还失败,请稍后重试!'); console.error(error); } }
方法选择
- 如果你希望参数通过 URL 查询字符串传递,可以使用 方法 1。
- 如果你希望参数通过 JSON 格式化传递,并统一放入请求体中,可以使用 方法 2。
补充测试说明
-
如果选择 方法 1,确保前端的
params传递正确。- URL 示例:
http://localhost:8080/borrow/borrow/1?userId=1。 - 通过 Postman 或浏览器工具查看请求 URL。
- URL 示例:
-
如果选择 方法 2:
- 请求示例:
{ "userId": 1 } - 前端需要正确设置请求体内容,确保
Content-Type为application/json。
- 请求示例:
希望这些修改能彻底解决
MissingServletRequestParameterException的问题!如果仍有疑问,请随时联系我! - 未正确传递
- User
方法 1:修改前端,正确传递参数 借书接口前端修改 将借书接口的调用方式从传递 data 参数改为通过 params 参数的方式在 URL 中传递 userId。
async handleBorrow(row) { if (row.quantity <= 0) { this.$message.error('书籍库存不足,无法借阅!'); return; }
try { const response = await axios.post(
http://localhost:8080/borrow/borrow/${row.id}, null, // POST 请求的 body 可为空 { params: { userId: this.userId }, // 将 userId 作为请求参数传递 } ); if (response.data.code === 1) { this.message.success('借阅成功!'); this.handleQuery(); // 刷新书籍列表 } else { this.message.error(response.data.msg || '借阅失败!'); } } catch (error) { this.$message.error('借阅失败,请稍后重试!'); console.error(error); } } 归还接口前端修改 同理,修正归还接口调用,userId 通过 params 或者 URL query string 的方式传递。async handleReturn(row) { try { const response = await axios.post(
http://localhost:8080/borrow/return/${row.bookId}, null, // POST 请求的 body 可为空 { params: { userId: this.userId }, // 将 userId 作为请求参数传递 } ); if (response.data.code === 1) { this.message.success('归还成功!'); this.handleMyBorrowed(); // 刷新借阅记录 } else { this.message.error(response.data.msg || '归还失败!'); } } catch (error) { this.$message.error('归还失败,请稍后重试!'); console.error(error); } }<el-container> <!-- 头部 --> <el-header style="font-family: 楷体; text-align: center; font-weight: bold; background-color: rgb(254, 64, 74); color: white; font-size: 50px;"> 红色精神图书管理系统 </el-header> <!-- 主内容 --> <el-main> <!-- 查询表单 --> <el-form :inline="true" :model="queryForm" class="demo-form-inline" style="margin-bottom: 20px;"> <el-form-item label="书名"> <el-input v-model="queryForm.name" placeholder="书名"></el-input> </el-form-item> <el-form-item> <el-button type="primary" @click="handleQuery">查询</el-button> <el-button type="default" @click="resetQuery" style="margin-left: 10px;">复原</el-button> </el-form-item> </el-form> <!-- 我的借阅 --> <el-button type="primary" style="margin-top: 20px;" @click="handleMyBorrowed">我的借阅</el-button> <!-- 书籍列表 --> <el-table :data="tableData" tooltip-effect="dark" style="width: 100%; margin-top: 20px;" @selection-change="handleSelectionChange" > <el-table-column type="selection" width="55"></el-table-column> <el-table-column prop="name" label="书名" width="180"></el-table-column> <el-table-column prop="publisher" label="出版社" width="180"></el-table-column> <el-table-column prop="author" label="作者" width="180"></el-table-column> <el-table-column label="数量" prop="quantity" width="100"></el-table-column> <el-table-column label="存入时间" width="180"> <template #default="{ row }"> {{ formatDateTime(row.storeTime) }} </template> </el-table-column> <el-table-column label="操作" width="120"> <template #default="{ row }"> <el-button size="mini" @click="handleBorrow(row)" :disabled="row.quantity <= 0">借阅</el-button> </template> </el-table-column> </el-table> <!-- 分页 --> <el-pagination @size-change="handleSizeChange" @current-change="handlePageChange" :current-page="currentPage" :page-sizes="[10, 20, 30, 40]" :page-size="pageSize" layout="total, sizes, prev, pager, next, jumper" style="text-align: right; margin-top: 20px;" > </el-pagination> <!-- 我的借阅记录 --> <el-dialog title="我的借阅记录" :visible.sync="myBorrowedVisible"> <el-table :data="myBorrowedData" style="width: 100%"> <el-table-column prop="bookId" label="书籍编号" width="100"></el-table-column> <el-table-column prop="borrowTime" label="借阅时间" width="180"> <template #default="{ row }"> {{ formatDateTime(row.borrowTime) }} </template> </el-table-column> <el-table-column prop="returnTime" label="归还时间" width="180"> <template #default="{ row }"> {{ row.returnTime ? formatDateTime(row.returnTime) : "未归还" }} </template> </el-table-column> <el-table-column label="操作" width="120"> <template #default="{ row }"> <el-button size="mini" :disabled="row.returnTime" @click="handleReturn(row)"> 归还 </el-button> </template> </el-table-column> </el-table> </el-dialog> </el-main> </el-container> </el-container>帮忙修改
- Assistant
通过阅读你的要求,结合目前的代码,在
借书接口和归还接口的前端实现部分,需要以下改动以确保userId参数正确传递给后端,同时保持其他功能不受影响。
修改点说明
- 确认
借书和归还功能通过 URL 查询字符串(params)方式传递userId参数。 - 保持一致的函数结构,确保代码符合 Vue 和 Element UI 的标准写法。
- 修正一些错误的字段名,如归还接口中的
row.bookId等。
下面是完整的修正代码:
修改后的代码
部分
不需要改动,此部分已健全且完善。
部分
完整的修改后的 JavaScript 部分如下:
<script> import axios from 'axios'; export default { data() { return { queryForm: { name: '', // 查询条件,图书名称 }, tableData: [], // 图书表格数据 currentPage: 1, // 当前页码 pageSize: 10, // 每页记录数 selectedRows: [], // 勾选的表格行(暂未用) myBorrowedVisible: false, // 我的借阅记录弹窗开关 myBorrowedData: [], // 我的借阅记录 userId: 1, // 假设登录用户 ID 为 1,用于测试。实际应该登录后从后端返回。 }; }, methods: { // 查询书籍的方法 async handleQuery() { try { const response = await axios.get('http://localhost:8080/books', { params: { page: this.currentPage, // 当前页码 pageSize: this.pageSize, // 每页记录数 name: this.queryForm.name, // 按名称筛选 }, }); if (response.data.code === 1) { this.tableData = response.data.data.rows; // 填充表格数据 } else { this.$message.error(response.data.msg || '查询失败!'); } } catch (error) { this.$message.error('查询失败,请稍后重试!'); console.error(error); } }, // 重置查询表单 resetQuery() { this.queryForm.name = ''; this.handleQuery(); // 发起新的查询 }, // 借阅书籍 async handleBorrow(row) { if (row.quantity <= 0) { this.$message.error('库存不足,无法借阅!'); return; } try { // 借书接口调用,userId 参数放在 query 参数中 const response = await axios.post( `http://localhost:8080/borrow/borrow/${row.id}`, null, // POST 请求体为空 { params: { userId: this.userId }, // userId 参数通过 query 传递 } ); if (response.data.code === 1) { this.$message.success('借阅成功!'); this.handleQuery(); // 刷新书籍列表 } else { this.$message.error(response.data.msg || '借阅失败!'); } } catch (error) { this.$message.error('借阅失败,请稍后重试!'); console.error(error); } }, // 归还书籍 async handleReturn(row) { if (!row.bookId) { this.$message.error('书籍信息有误,无法归还!'); return; } try { // 归还接口调用 const response = await axios.post( `http://localhost:8080/borrow/return/${row.bookId}`, null, // POST 请求体为空 { params: { userId: this.userId }, // userId 参数通过 query 传递 } ); if (response.data.code === 1) { this.$message.success('归还成功!'); this.handleMyBorrowed(); // 刷新借阅记录 } else { this.$message.error(response.data.msg || '归还失败!'); } } catch (error) { this.$message.error('归还失败,请稍后重试!'); console.error(error); } }, // 打开我的借阅记录 async handleMyBorrowed() { try { const response = await axios.get( 'http://localhost:8080/borrow/history', { params: { userId: this.userId }, // userId 参数通过 query 传递 } ); if (response.data.code === 1) { this.myBorrowedData = response.data.data; // 填充借阅记录表格数据 this.myBorrowedVisible = true; // 打开弹窗 } else { this.$message.error(response.data.msg || '获取借阅记录失败!'); } } catch (error) { this.$message.error('获取借阅记录失败,请稍后重试!'); console.error(error); } }, // 页大小变化 handleSizeChange(val) { this.pageSize = val; this.handleQuery(); }, // 当前页变化 handlePageChange(val) { this.currentPage = val; this.handleQuery(); }, // 格式化时间 formatDateTime(value) { if (!value) return '无数据'; const date = new Date(value); return date.toLocaleString(); // 使用默认区域格式化时间 }, }, mounted() { this.handleQuery(); // 初始化时加载书籍数据 }, }; </script>
部分
样式部分无需更改。完整如下:
<style scoped> .custom-menu.el-menu-item span, .custom-menu.el-menu-item { color: white !important; font-weight: bold; } .el-menu-item:hover { background-color: yellow !important; color: red !important; } .el-table .el-table__body-wrapper { margin-top: 10px; } .el-table .el-table__row { margin: 10px 0; } </style>
详细说明的调整点
-
借书和归还改为 URL 查询字符串传参:
- 借书接口:使用
axios.post(URL, null, { params: { userId } })。 - 归还接口:同上,
URL和params都传递了bookId和userId。
- 借书接口:使用
-
我的借阅记录:
- 获取借阅记录时,
userId通过params的方式传递给后端。
- 获取借阅记录时,
-
错误防护:
handleBorrow(row)检查库存量row.quantity。handleReturn(row)检查是否传递row.bookId,避免无效归还。
-
分页和查询逻辑:
- 根据分页回调参数,调整
currentPage和pageSize,并重新查询数据。
- 根据分页回调参数,调整
验收期望
- 借书功能:点击借书按钮后,后端的
/borrow/borrow/{bookId}可收到正确的userId和图书参数,完成借阅操作。 - 归还功能:点击归还按钮后,后端的
/borrow/return/{bookId}收到正确参数,完成归还操作。 - 我的借阅记录能显示。记录包含每本书的借阅时间和归还时间。
先运行后端,再配合 Vue 项目测试以上功能。如果有问题可以随时联系!
- 确认
- User
方法 1:修改前端,正确传递参数 借书接口前端修改 将借书接口的调用方式从传递 data 参数改为通过 params 参数的方式在 URL 中传递 userId。
async handleBorrow(row) { if (row.quantity <= 0) { this.$message.error('书籍库存不足,无法借阅!'); return; }
try { const response = await axios.post( http://localhost:8080/borrow/borrow/${row.id}, null, // POST 请求的 body 可为空 { params: { userId: this.userId }, // 将 userId 作为请求参数传递 } ); if (response.data.code === 1) { this.message.success('借阅成功!'); this.handleQuery(); // 刷新书籍列表 } else { this.message.error(response.data.msg || '借阅失败!'); } } catch (error) { this.$message.error('借阅失败,请稍后重试!'); console.error(error); } } 归还接口前端修改 同理,修正归还接口调用,userId 通过 params 或者 URL query string 的方式传递。
async handleReturn(row) { try { const response = await axios.post( http://localhost:8080/borrow/return/${row.bookId}, null, // POST 请求的 body 可为空 { params: { userId: this.userId }, // 将 userId 作为请求参数传递 } ); if (response.data.code === 1) { this.message.success('归还成功!'); this.handleMyBorrowed(); // 刷新借阅记录 } else { this.message.error(response.data.msg || '归还失败!'); } } catch (error) { this.$message.error('归还失败,请稍后重试!'); console.error(error); } }
<el-container> <!-- 头部 --> <el-header style="font-family: 楷体; text-align: center; font-weight: bold; background-color: rgb(254, 64, 74); color: white; font-size: 50px;"> 红色精神图书管理系统 </el-header> <!-- 主内容 --> <el-main> <!-- 查询表单 --> <el-form :inline="true" :model="queryForm" class="demo-form-inline" style="margin-bottom: 20px;"> <el-form-item label="书名"> <el-input v-model="queryForm.name" placeholder="书名"></el-input> </el-form-item> <el-form-item> <el-button type="primary" @click="handleQuery">查询</el-button> <el-button type="default" @click="resetQuery" style="margin-left: 10px;">复原</el-button> </el-form-item> </el-form> <!-- 我的借阅 --> <el-button type="primary" style="margin-top: 20px;" @click="handleMyBorrowed">我的借阅</el-button> <!-- 书籍列表 --> <el-table :data="tableData" tooltip-effect="dark" style="width: 100%; margin-top: 20px;" @selection-change="handleSelectionChange" > <el-table-column type="selection" width="55"></el-table-column> <el-table-column prop="name" label="书名" width="180"></el-table-column> <el-table-column prop="publisher" label="出版社" width="180"></el-table-column> <el-table-column prop="author" label="作者" width="180"></el-table-column> <el-table-column label="数量" prop="quantity" width="100"></el-table-column> <el-table-column label="存入时间" width="180"> <template #default="{ row }"> {{ formatDateTime(row.storeTime) }} </template> </el-table-column> <el-table-column label="操作" width="120"> <template #default="{ row }"> <el-button size="mini" @click="handleBorrow(row)" :disabled="row.quantity <= 0">借阅</el-button> </template> </el-table-column> </el-table> <!-- 分页 --> <el-pagination @size-change="handleSizeChange" @current-change="handlePageChange" :current-page="currentPage" :page-sizes="[10, 20, 30, 40]" :page-size="pageSize" layout="total, sizes, prev, pager, next, jumper" style="text-align: right; margin-top: 20px;" > </el-pagination> <!-- 我的借阅记录 --> <el-dialog title="我的借阅记录" :visible.sync="myBorrowedVisible"> <el-table :data="myBorrowedData" style="width: 100%"> <el-table-column prop="bookId" label="书籍编号" width="100"></el-table-column> <el-table-column prop="borrowTime" label="借阅时间" width="180"> <template #default="{ row }"> {{ formatDateTime(row.borrowTime) }} </template> </el-table-column> <el-table-column prop="returnTime" label="归还时间" width="180"> <template #default="{ row }"> {{ row.returnTime ? formatDateTime(row.returnTime) : "未归还" }} </template> </el-table-column> <el-table-column label="操作" width="120"> <template #default="{ row }"> <el-button size="mini" :disabled="row.returnTime" @click="handleReturn(row)"> 归还 </el-button> </template> </el-table-column> </el-table> </el-dialog> </el-main> </el-container> </el-container>帮忙修改
- Assistant
在你的代码基础上,我发现前端代码存在两处问题需要完善,主要集中在
借阅和归还接口的实现。- 在你的代码中,
借书接口和归还接口既涉及POST请求的body传参,又涉及params。实际上方式重复,它只能使用其中之一。- 修正: 我会将请求调整为通过
params(即 URL 的查询参数)传递userId。
- 修正: 我会将请求调整为通过
- 针对按钮触发时,
userId被重复嵌入错误位置。- 修正: 完全切换到通过
params传递,不必在body中传递userId。
- 修正: 完全切换到通过
另外,其他代码逻辑是标准的 Vue 和 Element UI 实现,我只完善了有问题的地方。
完整修正后的代码
<script>部分针对
借阅和归还操作,确保userId是作为 URL 查询参数(params)而非请求体传递。<script> import axios from 'axios'; export default { data() { return { queryForm: { name: '', // 查询条件,对于书名 }, tableData: [], // 图书的表格数据 currentPage: 1, // 当前页码 pageSize: 10, // 每页显示记录数 selectedRows: [], // 勾选的表格行(保留,以防备用) myBorrowedVisible: false, // “我的借阅记录”弹窗状态 myBorrowedData: [], // 我的借阅记录数据 userId: 1, // 假设已登录用户的 ID 为 1,这里你可能需要动态获取 }; }, methods: { // 查询书籍的方法 async handleQuery() { try { const response = await axios.get('http://localhost:8080/books', { params: { page: this.currentPage, // 当前页码 pageSize: this.pageSize, // 每页显示条数 name: this.queryForm.name, // 可以按书名搜索 }, }); if (response.data.code === 1) { this.tableData = response.data.data.rows; // 填充表格数据 } else { this.$message.error(response.data.msg || '查询失败'); } } catch (error) { this.$message.error('查询失败,请稍后重试!'); console.error(error); } }, // 清空搜索条件、刷新表格 resetQuery() { this.queryForm.name = ''; // 重置书名搜索栏 this.handleQuery(); }, // 借阅书籍 async handleBorrow(row) { if (row.quantity <= 0) { this.$message.error('书籍库存不足,无法借阅!'); return; } try { const response = await axios.post( `http://localhost:8080/borrow/borrow/${row.id}`, null, // POST body 为空 { params: { userId: this.userId }, // userId 放在查询参数中 } ); if (response.data.code === 1) { this.$message.success('借阅成功!'); this.handleQuery(); // 借阅成功后刷新书籍列表 } else { this.$message.error(response.data.msg || '借阅失败!'); } } catch (error) { this.$message.error('借阅失败,请稍后重试!'); console.error(error); } }, // 归还书籍 async handleReturn(row) { if (!row.bookId) { this.$message.error('书籍信息有误,无法归还!'); return; } try { const response = await axios.post( `http://localhost:8080/borrow/return/${row.bookId}`, null, // POST body 为空 { params: { userId: this.userId }, // userId 放在查询参数中 } ); if (response.data.code === 1) { this.$message.success('归还成功!'); this.handleMyBorrowed(); // 归还成功后刷新借阅记录 } else { this.$message.error(response.data.msg || '归还失败!'); } } catch (error) { this.$message.error('归还失败,请稍后重试!'); console.error(error); } }, // 查看我的借阅记录 async handleMyBorrowed() { try { const response = await axios.get( 'http://localhost:8080/borrow/history', { params: { userId: this.userId }, // userId 放在查询参数中 } ); if (response.data.code === 1) { this.myBorrowedData = response.data.data; // 更新弹窗表格的数据 this.myBorrowedVisible = true; // 打开“我的借阅”弹窗 } else { this.$message.error(response.data.msg || '获取借阅记录失败!'); } } catch (error) { this.$message.error('获取借阅记录失败,请稍后重试!'); console.error(error); } }, // 切换页大小 handleSizeChange(val) { this.pageSize = val; // 更新每页显示条数 this.handleQuery(); // 刷新查询 }, // 切换当前页 handlePageChange(val) { this.currentPage = val; // 更新当前页码 this.handleQuery(); // 刷新查询 }, // 时间格式化函数 formatDateTime(value) { if (!value) return '无数据'; return new Date(value).toLocaleString('zh-CN', { hour12: false }); // 格式化时间 }, }, mounted() { this.handleQuery(); // 初始化加载书籍数据 }, }; </script>
修改亮点
-
借书和还书:
- 改动逻辑聚焦于参数传递:
userId通过params传递,而不是嵌入请求体中。- URL 符合 RESTful 规范:
http://localhost:8080/borrow/borrow/{bookId}。
- 保证了数据传递的标准性,前后端接口严格匹配。
- 改动逻辑聚焦于参数传递:
-
连续更新:
- 借阅后,刷新书籍库存列表以看到实时数据。
- 归还后,刷新“我的借阅记录”弹窗数据。
-
错误防护:
- 如书籍库存不足或
bookId丢失报错,保证前端的鲁棒性。 - 完整处理后端返回的不同状态码。
- 如书籍库存不足或
部分,无需改动
保持原有样式即可。
测试步骤
- 书籍查询: 启动服务,加载
/books接口的数据,检查是否能够正确显示书籍列表。 - 借书操作:
- 点击
借阅按钮,检查后端/borrow/borrow/{bookId}是否收到userId和bookId。
- 点击
- 归还操作:
- 打开“我的借阅记录”弹窗,点击
归还按钮,检查后端/borrow/return/{bookId}是否收到userId和bookId。
- 打开“我的借阅记录”弹窗,点击
- 分页操作:
- 改变每页显示数量和页码,检查是否能够正常调用后端接口并刷新数据。
如果你还有其他需求,随时告诉我!
- 在你的代码中,
- User
<el-container> <!-- 头部 --> <el-header style="font-family: 楷体; text-align: center; font-weight: bold; background-color: rgb(254, 64, 74); color: white; font-size: 50px;"> 红色精神图书管理系统 </el-header> <!-- 主内容 --> <el-main> <!-- 查询表单 --> <el-form :inline="true" :model="queryForm" class="demo-form-inline" style="margin-bottom: 20px;"> <el-form-item label="书名"> <el-input v-model="queryForm.name" placeholder="书名"></el-input> </el-form-item> <el-form-item> <el-button type="primary" @click="handleQuery">查询</el-button> <el-button type="default" @click="resetQuery" style="margin-left: 10px;">复原</el-button> </el-form-item> </el-form> <!-- 我的借阅 --> <el-button type="primary" style="margin-top: 20px;" @click="handleMyBorrowed">我的借阅</el-button> <!-- 书籍列表 --> <el-table :data="tableData" tooltip-effect="dark" style="width: 100%; margin-top: 20px;" @selection-change="handleSelectionChange" > <el-table-column type="selection" width="55"></el-table-column> <el-table-column prop="name" label="书名" width="180"></el-table-column> <el-table-column prop="publisher" label="出版社" width="180"></el-table-column> <el-table-column prop="author" label="作者" width="180"></el-table-column> <el-table-column label="数量" prop="quantity" width="100"></el-table-column> <el-table-column label="存入时间" width="180"> <template #default="{ row }"> {{ formatDateTime(row.storeTime) }} </template> </el-table-column> <el-table-column label="操作" width="120"> <template #default="{ row }"> <el-button size="mini" @click="handleBorrow(row)" :disabled="row.quantity <= 0">借阅</el-button> </template> </el-table-column> </el-table> <!-- 分页 --> <el-pagination @size-change="handleSizeChange" @current-change="handlePageChange" :current-page="currentPage" :page-sizes="[10, 20, 30, 40]" :page-size="pageSize" layout="total, sizes, prev, pager, next, jumper" style="text-align: right; margin-top: 20px;" > </el-pagination> <!-- 我的借阅记录 --> <el-dialog title="我的借阅记录" :visible.sync="myBorrowedVisible"> <el-table :data="myBorrowedData" style="width: 100%"> <el-table-column prop="bookId" label="书籍编号" width="100"></el-table-column> <el-table-column prop="borrowTime" label="借阅时间" width="180"> <template #default="{ row }"> {{ formatDateTime(row.borrowTime) }} </template> </el-table-column> <el-table-column prop="returnTime" label="归还时间" width="180"> <template #default="{ row }"> {{ row.returnTime ? formatDateTime(row.returnTime) : "未归还" }} </template> </el-table-column> <el-table-column label="操作" width="120"> <template #default="{ row }"> <el-button size="mini" :disabled="row.returnTime" @click="handleReturn(row)"> 归还 </el-button> </template> </el-table-column> </el-table> </el-dialog> </el-main> </el-container> </el-container>为什么借阅过的书还能借阅?而且影响到管理员的图书不能删除了
<el-menu-item index="3"> <router-link to="/books#section2">图书管理</router-link> </el-menu-item> </el-menu-item-group> </el-submenu> </el-menu> </el-col> </el-row> </el-menu><!-- 头部 --><!-- 主要内容区域 --> <el-main> <el-form :inline="true" :model="queryForm" class="demo-form-inline" style="margin-bottom: 20px;"> <el-form-item label="书名"> <el-input v-model="queryForm.name" placeholder="书名"></el-input> </el-form-item> <el-form-item> <el-button type="primary" @click="handleQuery">查询</el-button> <el-button type="default" @click="resetQuery" style="margin-left: 10px;">复原</el-button> </el-form-item> </el-form> <el-button type="primary" style="margin-top: 20px;" @click="addDialogVisible = true">新增图书</el-button> <el-button type="danger" @click="handleBatchDelete" style="margin-top: 20px;" :disabled="selectedRows.length === 0">批量删除</el-button> <el-table :data="tableData" tooltip-effect="dark" style="width: 100%; margin-top: 20px;" @selection-change="handleSelectionChange" > <el-table-column type="selection" width="55"></el-table-column> <el-table-column prop="name" label="书名" width="180"></el-table-column> <el-table-column prop="publisher" label="出版社" width="180"></el-table-column> <el-table-column prop="author" label="作者" width="180"></el-table-column> <el-table-column label="数量" prop="quantity" width="100"></el-table-column> <el-table-column label="存入时间" width="180"> <template #default="{ row }"> {{ formatDateTime(row.storeTime) }} </template> </el-table-column> <el-table-column label="操作" width="120"> <template #default="{ row }"> <el-button size="mini" @click="handleEdit(row)">编辑</el-button> <br> <br> <el-button size="mini" type="danger" @click="handleDelete(row.id)">删除</el-button> </template> </el-table-column> </el-table> <el-pagination @size-change="handleSizeChange" @current-change="handlePageChange" :current-page="currentPage" :page-sizes="[10, 20, 30, 40]" :page-size="pageSize" layout="total, sizes, prev, pager, next, jumper" style="text-align: right; margin-top: 20px;"> </el-pagination> <!-- 编辑对话框 --> <el-dialog title="编辑图书信息" :visible.sync="editDialogVisible"> <el-form :model="editForm"> <el-form-item label="书名"> <el-input v-model="editForm.name"></el-input> </el-form-item> <el-form-item label="出版社"> <el-input v-model="editForm.publisher"></el-input> </el-form-item> <el-form-item label="作者"> <el-input v-model="editForm.author"></el-input> </el-form-item> <el-form-item label="数量"> <el-input v-model.number="editForm.quantity" type="number"></el-input> </el-form-item> </el-form> <div slot="footer" class="dialog-footer"> <el-button @click="editDialogVisible = false">取消</el-button> <el-button type="primary" @click="handleSave">保存</el-button> </div> </el-dialog> <!-- 新增对话框 --> <el-dialog title="新增图书信息" :visible.sync="addDialogVisible"> <el-form :model="addForm"> <el-form-item label="书名"> <el-input v-model="addForm.name"></el-input> </el-form-item> <el-form-item label="出版社"> <el-input v-model="addForm.publisher"></el-input> </el-form-item> <el-form-item label="作者"> <el-input v-model="addForm.author"></el-input> </el-form-item> <el-form-item label="数量"> <el-input v-model.number="addForm.quantity" type="number"></el-input> </el-form-item> </el-form> <div slot="footer" class="dialog-footer"> <el-button @click="addDialogVisible = false">取消</el-button> <el-button type="primary" @click="handleAdd">新增</el-button> </div> </el-dialog> <!-- 新增按钮 --> </el-main> </el-container> </el-container> - Assistant
让用户无法重复借阅已经借过的书,且确保管理员能正常删除图书,需要对前端和后端的逻辑进行一些调整。
划分问题:
-
借过的书无法重复借阅:
- 每个用户应该在借阅未归还的记录中进行检查。
- 确保借阅请求时系统校验是否已经存在一条“未归还”记录。
-
管理员无法删除问题:
- 确定后端删除逻辑中是否附加了约束(如级联限制)。
- 确保后端
DELETE(如/books/{id}或批量删除接口)接口正确返回状态码,并在前端正确处理返回结果。
前端解决方案
1. 修复"借过的书不能重复借阅"逻辑
在借阅按钮中动态禁用那些用户已借阅过且未归还的书籍。
<el-table-column label="操作" width="120"> <template #default="{ row }"> <el-button size="mini" @click="handleBorrow(row)" :disabled="row.quantity <= 0 || isAlreadyBorrowed(row.id)" > 借阅 </el-button> </template> </el-table-column>增加一个帮助函数
isAlreadyBorrowedmethods: { isAlreadyBorrowed(bookId) { // 遍历用户的借阅记录,判断书籍是否已借 return ( this.myBorrowedData && this.myBorrowedData.some((borrowed) => borrowed.bookId === bookId && !borrowed.returnTime) ); }, ... }isAlreadyBorrowed方法判断书籍是否在当前用户的“未归还借阅记录”中。如果已经借阅,按钮就会禁用。
2. 修复管理员无法删除图书
确保管理员可以选中图书然后进行单项删除或批量删除,前端
handleBatchDelete和handleDelete方法不需要调整逻辑,但可以增加一个 check,用于在删除时告知用户书是否被关联其他表(如有未归还记录时的读取提示)。在批量删除逻辑前,读取所有选中图书,点击 "删除" 时检查是否有借阅关联。
async handleBatchDelete() { if (this.selectedRows.length === 0) { this.$message.warning('请选择至少一行数据进行删除'); return; } const hasBorrowed = this.selectedRows.some(row => row.quantity === 0); if (hasBorrowed) { this.$message.error('部分图书仍在被借阅中,无法删除!'); return; } const ids = this.selectedRows.map(row => row.id).join(','); try { const response = await axios.delete(`http://localhost:8080/books/${ids}`); if (response.data.code === 1) { this.$message.success('批量删除成功'); this.handleQuery(); this.selectedRows = []; // 清空选中行 } else { this.$message.error(response.data.msg); } } catch (error) { this.$message.error('批量删除失败,请重试'); console.error(error); } },
后端解决方案
1. 修复"借过的书不能重复借阅"逻辑
在借阅接口
POST /borrow/borrow/{bookId}中,添加检查逻辑,确保所选书籍没有“未归还记录”。如果检查到用户未归还状态,则返回错误提示,当前借阅请求失败。以下是后端代码调整:
@PostMapping("/borrow/{bookId}") public Result borrowBook(@RequestParam Long userId, @PathVariable Integer bookId) { // 检查是否存在未归还的借阅记录 List<Borrow> existingBorrows = borrowService.getUnreturnedBorrowsByUserIdAndBookId(userId, bookId); if (!existingBorrows.isEmpty()) { return Result.error("你已借阅该书籍,无法重复借阅!"); } // 执行借书逻辑 borrowService.borrowBook(userId, bookId); return Result.success("借阅成功"); }新增
BorrowService方法:public List<Borrow> getUnreturnedBorrowsByUserIdAndBookId(Long userId, Integer bookId) { return borrowMapper.findUnreturnedRecord(userId, bookId); }BorrowMapper新增查询:@Select("SELECT * FROM borrow WHERE user_id = #{userId} AND book_id = #{bookId} AND return_time IS NULL") List<Borrow> findUnreturnedRecord(@Param("userId") Long userId, @Param("bookId") Integer bookId);
2. 修复管理员无法删除图书
确保后端删除逻辑对数据的外键约束进行检测或级联删除,避免因关联数据问题导致删除失败。
后台
/books/{ids}删除逻辑:@DeleteMapping("/{ids}") public Result batchDelete(@PathVariable List<Integer> ids) { // 判断是否有未归还的借阅记录 List<Integer> inUse = bookService.findBooksInUse(ids); // 检查未归还记录 if (!inUse.isEmpty()) { return Result.error("部分书籍仍被用户借阅,无法删除"); } // 执行删除逻辑 bookService.delete(ids); return Result.success("删除成功"); }在
BookService中新增findBooksInUse方法:public List<Integer> findBooksInUse(List<Integer> ids) { return borrowMapper.findBooksWithUnreturnedRecords(ids); }BorrowMapper新增检查书籍使用状态的方法:@Select("<script>" + "SELECT DISTINCT book_id " + "FROM borrow " + "WHERE book_id IN " + "<foreach item='id' collection='ids' open='(' separator=',' close=')'>" + "#{id}" + "</foreach> AND return_time IS NULL" + "</script>") List<Integer> findBooksWithUnreturnedRecords(@Param("ids") List<Integer> ids);
测试步骤
前端
-
确保用户 "已借阅未归还的书" 按钮是禁用的:
- 手动打开 “我的借阅记录” 确认哪些书未归还。
- 在主页面中尝试借阅同一本书,按钮应为禁用。
-
确保管理员能正常删除:
- 数据库中存在未归还关联书测试,尝试删除,验证提示信息“部分书籍仍被用户借阅,无法删除”。
- 测试完全未被借用的书,应该被正常删除。
后端
- 调用
/borrow/borrow/{bookId},传递一个用户已经借阅了且未归还的书,接口应返回错误提示。 - 调用
/books/{ids}删除接口,确保未被借用图书可以删除,已被借用图书返回错误信息。
综合改动
通过这些调整,可以解决以下问题:
- 用户无法重复借阅已有借阅记录的书。
- 管理员在删除图书时,能够检测是否存在关联记录,并提示操作限制。
如果还有其他需求需要调整,欢迎继续沟通!
-
- User
后端解决方案
-
修复"借过的书不能重复借阅"逻辑 在借阅接口 POST /borrow/borrow/{bookId} 中,添加检查逻辑,确保所选书籍没有“未归还记录”。如果检查到用户未归还状态,则返回错误提示,当前借阅请求失败。 以下是后端代码调整: @PostMapping("/borrow/{bookId}") public Result borrowBook(@RequestParam Long userId, @PathVariable Integer bookId) { // 检查是否存在未归还的借阅记录 List existingBorrows = borrowService.getUnreturnedBorrowsByUserIdAndBookId(userId, bookId); if (!existingBorrows.isEmpty()) { return Result.error("你已借阅该书籍,无法重复借阅!"); }
// 执行借书逻辑 borrowService.borrowBook(userId, bookId); return Result.success("借阅成功"); } 新增 BorrowService 方法: public List getUnreturnedBorrowsByUserIdAndBookId(Long userId, Integer bookId) { return borrowMapper.findUnreturnedRecord(userId, bookId); } BorrowMapper 新增查询: @Select("SELECT * FROM borrow WHERE user_id = #{userId} AND book_id = #{bookId} AND return_time IS NULL") List findUnreturnedRecord(@Param("userId") Long userId, @Param("bookId") Integer bookId);
- 修复管理员无法删除图书 确保后端删除逻辑对数据的外键约束进行检测或级联删除,避免因关联数据问题导致删除失败。 后台 /books/{ids} 删除逻辑: @DeleteMapping("/{ids}") public Result batchDelete(@PathVariable List ids) { // 判断是否有未归还的借阅记录 List inUse = bookService.findBooksInUse(ids); // 检查未归还记录 if (!inUse.isEmpty()) { return Result.error("部分书籍仍被用户借阅,无法删除"); } // 执行删除逻辑 bookService.delete(ids); return Result.success("删除成功"); } 在 BookService 中新增 findBooksInUse 方法: public List findBooksInUse(List ids) { return borrowMapper.findBooksWithUnreturnedRecords(ids); } BorrowMapper 新增检查书籍使用状态的方法: @Select("" + "SELECT DISTINCT book_id " + "FROM borrow " + "WHERE book_id IN " + "" + "#{id}" + " AND return_time IS NULL" + "") List findBooksWithUnreturnedRecords(@Param("ids") List ids); 根据上面的代码。帮忙修改下面的代码,记得给我完整的代码喔 package com.wwq.bookproject.controller;
import com.wwq.bookproject.pojo.Borrow; import com.wwq.bookproject.pojo.Result; import com.wwq.bookproject.service.BorrowService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.*;
import java.util.List;
@RestController @RequestMapping("/borrow") public class BorrowController {
@Autowired private BorrowService borrowService; // 借书接口 @PostMapping("/borrow/{bookId}") public Result borrowBook(@RequestParam Long userId, @PathVariable Integer bookId) { borrowService.borrowBook(userId, bookId); return Result.success("借阅成功"); } // 还书接口 @PostMapping("/return/{bookId}") public Result returnBook(@RequestParam Long userId, @PathVariable Integer bookId) { borrowService.returnBook(userId, bookId); return Result.success("归还成功"); } // 查询用户的借阅记录 @GetMapping("/history") public Result getBorrowHistory(@RequestParam Long userId) { List<Borrow> borrowedBooks = borrowService.findBorrowedBooks(userId); return Result.success(borrowedBooks); }} package com.wwq.bookproject.mapper;
import com.wwq.bookproject.pojo.Borrow; import org.apache.ibatis.annotations.*;
import java.time.LocalDateTime; import java.util.List;
@Mapper public interface BorrowMapper {
// 新增借阅记录 @Insert("INSERT INTO borrow (user_id, book_id, borrow_time) VALUES (#{userId}, #{bookId}, #{borrowTime})") void addBorrowRecord(Borrow borrow); // 查询用户所有借阅记录 @Select("SELECT * FROM borrow WHERE user_id = #{userId}") List<Borrow> findBorrowedBooksByUserId(Long userId); // 更新归还时间(还书操作) @Update("UPDATE borrow SET return_time = #{returnTime} WHERE id = #{id}") void updateReturnTime(@Param("id") Integer id, @Param("returnTime") LocalDateTime returnTime); // 查找未归还的特定记录 @Select("SELECT * FROM borrow WHERE user_id = #{userId} AND book_id = #{bookId} AND return_time IS NULL") Borrow findUnreturnedRecord(@Param("userId") Long userId, @Param("bookId") Integer bookId);} package com.wwq.bookproject.service.impl;
import com.wwq.bookproject.mapper.BookMapper; import com.wwq.bookproject.mapper.BorrowMapper; import com.wwq.bookproject.pojo.Book; import com.wwq.bookproject.pojo.Borrow; import com.wwq.bookproject.service.BorrowService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional;
import java.time.LocalDateTime; import java.util.List;
@Service public class BorrowServiceImpl implements BorrowService {
@Autowired private BorrowMapper borrowMapper; @Autowired private BookMapper bookMapper; @Transactional @Override public void borrowBook(Long userId, Integer bookId) { // 检查书籍库存 Book book = bookMapper.getById(bookId); if (book == null || book.getQuantity() <= 0) { throw new RuntimeException("书籍库存不足或书籍不存在"); } // 减少书籍库存 bookMapper.update(new Book(bookId, book.getName(), book.getPublisher(), book.getAuthor(), LocalDateTime.now(), book.getQuantity() - 1)); // 新增借阅记录 Borrow borrow = new Borrow(); borrow.setUserId(userId); borrow.setBookId(bookId); borrow.setBorrowTime(LocalDateTime.now()); borrowMapper.addBorrowRecord(borrow); } @Transactional @Override public void returnBook(Long userId, Integer bookId) { // 查找是否有未归还的记录 Borrow borrow = borrowMapper.findUnreturnedRecord(userId, bookId); if (borrow == null) { throw new RuntimeException("没有找到未归还的记录"); } // 更新归还时间 borrowMapper.updateReturnTime(borrow.getId(), LocalDateTime.now()); // 增加书籍库存 Book book = bookMapper.getById(bookId); bookMapper.update(new Book(book.getId(), book.getName(), book.getPublisher(), book.getAuthor(), LocalDateTime.now(), book.getQuantity() + 1)); } @Override public List<Borrow> findBorrowedBooks(Long userId) { return borrowMapper.findBorrowedBooksByUserId(userId); }} package com.wwq.bookproject.service;
import com.wwq.bookproject.pojo.Borrow;
import java.time.LocalDateTime; import java.util.List;
public interface BorrowService { void borrowBook(Long userId, Integer bookId); // 借书操作 void returnBook(Long userId, Integer bookId); // 还书操作 List findBorrowedBooks(Long userId); // 查询用户的借阅记录 } package com.wwq.bookproject.controller;
import com.wwq.bookproject.pojo.Book; import com.wwq.bookproject.pojo.PageBean; import com.wwq.bookproject.pojo.Result; import com.wwq.bookproject.service.BookService; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.format.annotation.DateTimeFormat; import org.springframework.web.bind.annotation.*;
import java.time.LocalDateTime; import java.util.List;
@Slf4j @RestController @RequestMapping("/books") public class BookController {
@Autowired private BookService bookService; @GetMapping public Result page(@RequestParam(defaultValue = "1") Integer page, @RequestParam(defaultValue = "10") Integer pageSize, String name, String publisher, String author, @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss") LocalDateTime begin, @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss") LocalDateTime end) { log.info("分页查询, 参数: {},{},{},{},{},{}", page, pageSize, name, publisher, author, begin, end); PageBean pageBean = bookService.page(page, pageSize, name, publisher, author, begin, end); return Result.success(pageBean); } @DeleteMapping("/{ids}") public Result delete(@PathVariable List<Integer> ids) { log.info("批量删除操作,ids:{}", ids); bookService.delete(ids); return Result.success(); } @PostMapping public Result save(@RequestBody Book book) { bookService.save(book); return Result.success(); } @GetMapping("/{id}") public Result getById(@PathVariable Integer id) { log.info("根据ID查询信息,id:{}", id); Book book = bookService.getById(id); return Result.success(book); } @PutMapping public Result update(@RequestBody Book book) { log.info("更新图书信息:{}", book); bookService.update(book); return Result.success(); }} package com.wwq.bookproject.mapper;
import com.wwq.bookproject.pojo.Book; import org.apache.ibatis.annotations.*; import java.time.LocalDateTime; import java.util.List;
/**
-
书籍Mapper接口 */ @Mapper public interface BookMapper {
/**
- 查询书籍总数
- @return 书籍总数 / @Select("SELECT COUNT() FROM books") Long count();
/**
- 条件查询书籍列表
- @param name 书籍名称
- @param publisher 出版社
- @param author 作者
- @param begin 上架开始时间
- @param end 上架结束时间
- @return 书籍列表 */ @Select("" + "SELECT * FROM books" + "" + "" + "name LIKE CONCAT('%', #{name}, '%')" + "" + "" + "AND publisher = #{publisher}" + "" + "" + "AND author = #{author}" + "" + "" + "AND store_time BETWEEN #{begin} AND #{end}" + "" + "" + "ORDER BY store_time DESC" + "") List list(String name, String publisher, String author, LocalDateTime begin, LocalDateTime end);
/**
- 根据id列表批量删除书籍
- @param ids 书籍id列表 */ @Delete("" + "DELETE FROM books WHERE id IN" + "" + "#{id}" + "" + "") void delete(@Param("ids") List ids);
/**
- 新增书籍
- @param book 书籍对象 */ @Insert("INSERT INTO books(name, publisher, author, store_time, quantity) " + "VALUES(#{name}, #{publisher}, #{author}, #{storeTime}, #{quantity})") void save(Book book);
/**
- 根据id查询书籍
- @param id 书籍id
- @return 书籍对象 */ @Select("SELECT * FROM books WHERE id = #{id}") Book getById(Integer id);
/**
- 更新书籍信息
- @param book 书籍对象 */ @Update("UPDATE books SET name = #{name}, publisher = #{publisher}, author = #{author}, store_time = #{storeTime}, quantity = #{quantity} WHERE id = #{id}") void update(Book book); } package com.wwq.bookproject.service.impl;
import com.github.pagehelper.Page; import com.github.pagehelper.PageHelper; import com.wwq.bookproject.mapper.BookMapper; import com.wwq.bookproject.pojo.Book; import com.wwq.bookproject.pojo.PageBean; import com.wwq.bookproject.service.BookService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service;
import java.time.LocalDateTime; import java.util.List;
@Service public class BookServiceImpl implements BookService {
@Autowired private BookMapper bookMapper; @Override public PageBean page(Integer page, Integer pageSize, String name, String publisher, String author, LocalDateTime begin, LocalDateTime end) { PageHelper.startPage(page, pageSize); List<Book> bookList = bookMapper.list(name, publisher, author, begin, end); Page<Book> pageInfo = (Page<Book>) bookList; PageBean pageBean = new PageBean(pageInfo.getTotal(), pageInfo.getResult()); return pageBean; } @Override public void delete(List<Integer> ids) { bookMapper.delete(ids); } @Override public void save(Book book) { book.setStoreTime(LocalDateTime.now()); bookMapper.save(book); } @Override public Book getById(Integer id) { return bookMapper.getById(id); } @Override public void update(Book book) { book.setStoreTime(LocalDateTime.now()); // 这里可以根据实际情况决定是否更新存入时间 bookMapper.update(book); }} package com.wwq.bookproject.service;
import com.wwq.bookproject.pojo.Book; import com.wwq.bookproject.pojo.PageBean; import java.time.LocalDateTime; import java.util.List;
public interface BookService { PageBean page(Integer page, Integer pageSize, String name, String publisher, String author, LocalDateTime begin, LocalDateTime end); void delete(List ids); void save(Book book); Book getById(Integer id); void update(Book book); }
-
- Assistant
以下是完整修改后的代码,目标是实现以下功能:
- 确保不能借阅未归还的书籍。
- 确保管理员能够删除图书,但不能删除有未归还记录的图书。
修改内容
借阅相关代码
BorrowController.java
修改借阅逻辑,确保书籍未借出时可以借阅:
package com.wwq.bookproject.controller; import com.wwq.bookproject.pojo.Borrow; import com.wwq.bookproject.pojo.Result; import com.wwq.bookproject.service.BorrowService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.*; import java.util.List; @RestController @RequestMapping("/borrow") public class BorrowController { @Autowired private BorrowService borrowService; // 借书接口 @PostMapping("/borrow/{bookId}") public Result borrowBook(@RequestParam Long userId, @PathVariable Integer bookId) { // 检查是否存在未归还的借阅记录 List<Borrow> existingBorrows = borrowService.getUnreturnedBorrowsByUserIdAndBookId(userId, bookId); if (!existingBorrows.isEmpty()) { return Result.error("你已借阅该书籍,无法重复借阅!"); } borrowService.borrowBook(userId, bookId); return Result.success("借阅成功"); } // 还书接口 @PostMapping("/return/{bookId}") public Result returnBook(@RequestParam Long userId, @PathVariable Integer bookId) { borrowService.returnBook(userId, bookId); return Result.success("归还成功"); } // 查询用户的借阅记录 @GetMapping("/history") public Result getBorrowHistory(@RequestParam Long userId) { List<Borrow> borrowedBooks = borrowService.findBorrowedBooks(userId); return Result.success(borrowedBooks); } }
BorrowService.java
新增用于获取未归还记录的方法。
package com.wwq.bookproject.service; import com.wwq.bookproject.pojo.Borrow; import java.util.List; public interface BorrowService { void borrowBook(Long userId, Integer bookId); // 借书操作 void returnBook(Long userId, Integer bookId); // 还书操作 List<Borrow> findBorrowedBooks(Long userId); // 查询用户的借阅记录 // 新增:获取未归还借阅记录的方法 List<Borrow> getUnreturnedBorrowsByUserIdAndBookId(Long userId, Integer bookId); }
BorrowServiceImpl.java
在服务实现中,添加对未归还记录的逻辑验证。
package com.wwq.bookproject.service.impl; import com.wwq.bookproject.mapper.BookMapper; import com.wwq.bookproject.mapper.BorrowMapper; import com.wwq.bookproject.pojo.Book; import com.wwq.bookproject.pojo.Borrow; import com.wwq.bookproject.service.BorrowService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import java.time.LocalDateTime; import java.util.List; @Service public class BorrowServiceImpl implements BorrowService { @Autowired private BorrowMapper borrowMapper; @Autowired private BookMapper bookMapper; @Transactional @Override public void borrowBook(Long userId, Integer bookId) { // 检查书籍库存 Book book = bookMapper.getById(bookId); if (book == null || book.getQuantity() <= 0) { throw new RuntimeException("书籍库存不足或书籍不存在"); } // 减少书籍库存 bookMapper.update(new Book(bookId, book.getName(), book.getPublisher(), book.getAuthor(), LocalDateTime.now(), book.getQuantity() - 1)); // 新增借阅记录 Borrow borrow = new Borrow(); borrow.setUserId(userId); borrow.setBookId(bookId); borrow.setBorrowTime(LocalDateTime.now()); borrowMapper.addBorrowRecord(borrow); } @Transactional @Override public void returnBook(Long userId, Integer bookId) { // 查找是否有未归还的记录 Borrow borrow = borrowMapper.findUnreturnedRecord(userId, bookId); if (borrow == null) { throw new RuntimeException("没有找到未归还的记录"); } // 更新归还时间 borrowMapper.updateReturnTime(borrow.getId(), LocalDateTime.now()); // 增加书籍库存 Book book = bookMapper.getById(bookId); bookMapper.update(new Book(book.getId(), book.getName(), book.getPublisher(), book.getAuthor(), LocalDateTime.now(), book.getQuantity() + 1)); } @Override public List<Borrow> findBorrowedBooks(Long userId) { return borrowMapper.findBorrowedBooksByUserId(userId); } @Override public List<Borrow> getUnreturnedBorrowsByUserIdAndBookId(Long userId, Integer bookId) { return borrowMapper.findUnreturnedRecord(userId, bookId); } }
BorrowMapper.java
新增获取书籍未归还记录的查询。
package com.wwq.bookproject.mapper; import com.wwq.bookproject.pojo.Borrow; import org.apache.ibatis.annotations.*; import java.time.LocalDateTime; import java.util.List; @Mapper public interface BorrowMapper { // 新增借阅记录 @Insert("INSERT INTO borrow (user_id, book_id, borrow_time) VALUES (#{userId}, #{bookId}, #{borrowTime})") void addBorrowRecord(Borrow borrow); // 查询用户所有借阅记录 @Select("SELECT * FROM borrow WHERE user_id = #{userId}") List<Borrow> findBorrowedBooksByUserId(Long userId); // 查找未归还的记录 @Select("SELECT * FROM borrow WHERE user_id = #{userId} AND book_id = #{bookId} AND return_time IS NULL") List<Borrow> findUnreturnedRecord(@Param("userId") Long userId, @Param("bookId") Integer bookId); // 更新归还时间(还书操作) @Update("UPDATE borrow SET return_time = #{returnTime} WHERE id = #{id}") void updateReturnTime(@Param("id") Integer id, @Param("returnTime") LocalDateTime returnTime); }
BookController.java
在删除图书时,确保对书籍是否未归还进行检查。
@DeleteMapping("/{ids}") public Result delete(@PathVariable List<Integer> ids) { log.info("批量删除操作,ids:{}", ids); // 先检查图书是否有未归还记录 List<Integer> inUseBooks = bookService.findBooksInUse(ids); if (!inUseBooks.isEmpty()) { return Result.error("部分书籍仍被用户借阅,无法删除"); } bookService.delete(ids); return Result.success(); }
BookService.java
添加对未归还书籍的检查方法。
public List<Integer> findBooksInUse(List<Integer> ids);
BookServiceImpl.java
在后端服务中,利用
BorrowMapper检查书籍当前是否在使用中。@Override public List<Integer> findBooksInUse(List<Integer> ids) { return borrowMapper.findBooksWithUnreturnedRecords(ids); }
BorrowMapper.java
新增检查书籍是否被借用。
@Select("<script>" + "SELECT DISTINCT book_id " + "FROM borrow " + "WHERE book_id IN " + "<foreach item='id' collection='ids' open='(' separator=',' close=')'>" + "#{id}" + "</foreach> AND return_time IS NULL" + "</script>") List<Integer> findBooksWithUnreturnedRecords(@Param("ids") List<Integer> ids);
通过以上改动,可以完成以下功能:
- 一个用户不能借同一本已经借出的书籍。
- 管理员无法删除有未归还记录的书籍。
- User
后端解决方案
修复"借过的书不能重复借阅"逻辑 在借阅接口 POST /borrow/borrow/{bookId} 中,添加检查逻辑,确保所选书籍没有“未归还记录”。如果检查到用户未归还状态,则返回错误提示,当前借阅请求失败。 以下是后端代码调整: @PostMapping("/borrow/{bookId}") public Result borrowBook(@RequestParam Long userId, @PathVariable Integer bookId) { // 检查是否存在未归还的借阅记录 List existingBorrows = borrowService.getUnreturnedBorrowsByUserIdAndBookId(userId, bookId); if (!existingBorrows.isEmpty()) { return Result.error("你已借阅该书籍,无法重复借阅!"); } // 执行借书逻辑 borrowService.borrowBook(userId, bookId); return Result.success("借阅成功"); } 新增 BorrowService 方法: public List getUnreturnedBorrowsByUserIdAndBookId(Long userId, Integer bookId) { return borrowMapper.findUnreturnedRecord(userId, bookId); } BorrowMapper 新增查询: @Select("SELECT * FROM borrow WHERE user_id = #{userId} AND book_id = #{bookId} AND return_time IS NULL") List findUnreturnedRecord(@Param("userId") Long userId, @Param("bookId") Integer bookId);
修复管理员无法删除图书 确保后端删除逻辑对数据的外键约束进行检测或级联删除,避免因关联数据问题导致删除失败。 后台 /books/{ids} 删除逻辑: @DeleteMapping("/{ids}") public Result batchDelete(@PathVariable List ids) { // 判断是否有未归还的借阅记录 List inUse = bookService.findBooksInUse(ids); // 检查未归还记录 if (!inUse.isEmpty()) { return Result.error("部分书籍仍被用户借阅,无法删除"); } // 执行删除逻辑 bookService.delete(ids); return Result.success("删除成功"); } 在 BookService 中新增 findBooksInUse 方法: public List findBooksInUse(List ids) { return borrowMapper.findBooksWithUnreturnedRecords(ids); } BorrowMapper 新增检查书籍使用状态的方法: @Select("") List findBooksWithUnreturnedRecords(@Param("ids") List ids); 根据上面的代码。帮忙修改下面的代码,记得给我完整的代码喔 package com.wwq.bookproject.controller;
import com.wwq.bookproject.pojo.Borrow; import com.wwq.bookproject.pojo.Result; import com.wwq.bookproject.service.BorrowService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.*;
import java.util.List;
@RestController @RequestMapping("/borrow") public class BorrowController {
@Autowired private BorrowService borrowService;
// 借书接口 @PostMapping("/borrow/{bookId}") public Result borrowBook(@RequestParam Long userId, @PathVariable Integer bookId) { borrowService.borrowBook(userId, bookId); return Result.success("借阅成功"); }
// 还书接口 @PostMapping("/return/{bookId}") public Result returnBook(@RequestParam Long userId, @PathVariable Integer bookId) { borrowService.returnBook(userId, bookId); return Result.success("归还成功"); }
// 查询用户的借阅记录 @GetMapping("/history") public Result getBorrowHistory(@RequestParam Long userId) { List borrowedBooks = borrowService.findBorrowedBooks(userId); return Result.success(borrowedBooks); } } package com.wwq.bookproject.mapper;
import com.wwq.bookproject.pojo.Borrow; import org.apache.ibatis.annotations.*;
import java.time.LocalDateTime; import java.util.List;
@Mapper public interface BorrowMapper {
// 新增借阅记录 @Insert("INSERT INTO borrow (user_id, book_id, borrow_time) VALUES (#{userId}, #{bookId}, #{borrowTime})") void addBorrowRecord(Borrow borrow);
// 查询用户所有借阅记录 @Select("SELECT * FROM borrow WHERE user_id = #{userId}") List findBorrowedBooksByUserId(Long userId);
// 更新归还时间(还书操作) @Update("UPDATE borrow SET return_time = #{returnTime} WHERE id = #{id}") void updateReturnTime(@Param("id") Integer id, @Param("returnTime") LocalDateTime returnTime);
// 查找未归还的特定记录 @Select("SELECT * FROM borrow WHERE user_id = #{userId} AND book_id = #{bookId} AND return_time IS NULL") Borrow findUnreturnedRecord(@Param("userId") Long userId, @Param("bookId") Integer bookId); } package com.wwq.bookproject.service.impl;
import com.wwq.bookproject.mapper.BookMapper; import com.wwq.bookproject.mapper.BorrowMapper; import com.wwq.bookproject.pojo.Book; import com.wwq.bookproject.pojo.Borrow; import com.wwq.bookproject.service.BorrowService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional;
import java.time.LocalDateTime; import java.util.List;
@Service public class BorrowServiceImpl implements BorrowService {
@Autowired private BorrowMapper borrowMapper;
@Autowired private BookMapper bookMapper;
@Transactional @Override public void borrowBook(Long userId, Integer bookId) { // 检查书籍库存 Book book = bookMapper.getById(bookId); if (book == null || book.getQuantity() <= 0) { throw new RuntimeException("书籍库存不足或书籍不存在"); }
// 减少书籍库存 bookMapper.update(new Book(bookId, book.getName(), book.getPublisher(), book.getAuthor(), LocalDateTime.now(), book.getQuantity() - 1)); // 新增借阅记录 Borrow borrow = new Borrow(); borrow.setUserId(userId); borrow.setBookId(bookId); borrow.setBorrowTime(LocalDateTime.now()); borrowMapper.addBorrowRecord(borrow);}
@Transactional @Override public void returnBook(Long userId, Integer bookId) { // 查找是否有未归还的记录 Borrow borrow = borrowMapper.findUnreturnedRecord(userId, bookId); if (borrow == null) { throw new RuntimeException("没有找到未归还的记录"); }
// 更新归还时间 borrowMapper.updateReturnTime(borrow.getId(), LocalDateTime.now()); // 增加书籍库存 Book book = bookMapper.getById(bookId); bookMapper.update(new Book(book.getId(), book.getName(), book.getPublisher(), book.getAuthor(), LocalDateTime.now(), book.getQuantity() + 1));}
@Override public List findBorrowedBooks(Long userId) { return borrowMapper.findBorrowedBooksByUserId(userId); } } package com.wwq.bookproject.service;
import com.wwq.bookproject.pojo.Borrow;
import java.time.LocalDateTime; import java.util.List;
public interface BorrowService { void borrowBook(Long userId, Integer bookId); // 借书操作 void returnBook(Long userId, Integer bookId); // 还书操作 List findBorrowedBooks(Long userId); // 查询用户的借阅记录 } package com.wwq.bookproject.controller;
import com.wwq.bookproject.pojo.Book; import com.wwq.bookproject.pojo.PageBean; import com.wwq.bookproject.pojo.Result; import com.wwq.bookproject.service.BookService; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.format.annotation.DateTimeFormat; import org.springframework.web.bind.annotation.*;
import java.time.LocalDateTime; import java.util.List;
@Slf4j @RestController @RequestMapping("/books") public class BookController {
@Autowired private BookService bookService;
@GetMapping public Result page(@RequestParam(defaultValue = "1") Integer page, @RequestParam(defaultValue = "10") Integer pageSize, String name, String publisher, String author, @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss") LocalDateTime begin, @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss") LocalDateTime end) { log.info("分页查询, 参数: {},{},{},{},{},{}", page, pageSize, name, publisher, author, begin, end); PageBean pageBean = bookService.page(page, pageSize, name, publisher, author, begin, end); return Result.success(pageBean); }
@DeleteMapping("/{ids}") public Result delete(@PathVariable List ids) { log.info("批量删除操作,ids:{}", ids); bookService.delete(ids); return Result.success(); }
@PostMapping public Result save(@RequestBody Book book) { bookService.save(book); return Result.success(); }
@GetMapping("/{id}") public Result getById(@PathVariable Integer id) { log.info("根据ID查询信息,id:{}", id); Book book = bookService.getById(id); return Result.success(book); }
@PutMapping public Result update(@RequestBody Book book) { log.info("更新图书信息:{}", book); bookService.update(book); return Result.success();
} } package com.wwq.bookproject.mapper;
import com.wwq.bookproject.pojo.Book; import org.apache.ibatis.annotations.*; import java.time.LocalDateTime; import java.util.List;
/**
书籍Mapper接口 / @Mapper public interface BookMapper { /* 查询书籍总数 @return 书籍总数 / @Select("SELECT COUNT() FROM books") Long count(); /** 条件查询书籍列表 @param name 书籍名称 @param publisher 出版社 @param author 作者 @param begin 上架开始时间 @param end 上架结束时间 @return 书籍列表 / @Select("") List list(String name, String publisher, String author, LocalDateTime begin, LocalDateTime end); /* 根据id列表批量删除书籍 @param ids 书籍id列表 / @Delete("") void delete(@Param("ids") List ids); /* 新增书籍 @param book 书籍对象 / @Insert("INSERT INTO books(name, publisher, author, store_time, quantity) " + "VALUES(#{name}, #{publisher}, #{author}, #{storeTime}, #{quantity})") void save(Book book); /* 根据id查询书籍 @param id 书籍id @return 书籍对象 / @Select("SELECT * FROM books WHERE id = #{id}") Book getById(Integer id); /* 更新书籍信息 @param book 书籍对象 */ @Update("UPDATE books SET name = #{name}, publisher = #{publisher}, author = #{author}, store_time = #{storeTime}, quantity = #{quantity} WHERE id = #{id}") void update(Book book); } package com.wwq.bookproject.service.impl;
import com.github.pagehelper.Page; import com.github.pagehelper.PageHelper; import com.wwq.bookproject.mapper.BookMapper; import com.wwq.bookproject.pojo.Book; import com.wwq.bookproject.pojo.PageBean; import com.wwq.bookproject.service.BookService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service;
import java.time.LocalDateTime; import java.util.List;
@Service public class BookServiceImpl implements BookService {
@Autowired private BookMapper bookMapper;
@Override public PageBean page(Integer page, Integer pageSize, String name, String publisher, String author, LocalDateTime begin, LocalDateTime end) { PageHelper.startPage(page, pageSize); List bookList = bookMapper.list(name, publisher, author, begin, end); Page pageInfo = (Page) bookList; PageBean pageBean = new PageBean(pageInfo.getTotal(), pageInfo.getResult()); return pageBean; }
@Override public void delete(List ids) { bookMapper.delete(ids); }
@Override public void save(Book book) { book.setStoreTime(LocalDateTime.now()); bookMapper.save(book); }
@Override public Book getById(Integer id) { return bookMapper.getById(id); }
@Override public void update(Book book) { book.setStoreTime(LocalDateTime.now()); // 这里可以根据实际情况决定是否更新存入时间 bookMapper.update(book); } } package com.wwq.bookproject.service;
import com.wwq.bookproject.pojo.Book; import com.wwq.bookproject.pojo.PageBean; import java.time.LocalDateTime; import java.util.List;
public interface BookService { PageBean page(Integer page, Integer pageSize, String name, String publisher, String author, LocalDateTime begin, LocalDateTime end); void delete(List ids); void save(Book book); Book getById(Integer id); void update(Book book); }
- Assistant
以下是完整的代码实现,包含你描述的两大功能修复:
- 不允许借阅已借过未归还的书籍。
- 管理员不能删除存在未归还记录的书籍。
完整的代码实现
BorrowController.java
在
BorrowController中新增对未归还记录的校验逻辑。package com.wwq.bookproject.controller; import com.wwq.bookproject.pojo.Borrow; import com.wwq.bookproject.pojo.Result; import com.wwq.bookproject.service.BorrowService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.*; import java.util.List; @RestController @RequestMapping("/borrow") public class BorrowController { @Autowired private BorrowService borrowService; // 借书接口 @PostMapping("/borrow/{bookId}") public Result borrowBook(@RequestParam Long userId, @PathVariable Integer bookId) { // 检查是否已借阅但未归还 List<Borrow> existingBorrows = borrowService.getUnreturnedBorrowsByUserIdAndBookId(userId, bookId); if (!existingBorrows.isEmpty()) { return Result.error("你已借阅该书籍,无法重复借阅!"); } borrowService.borrowBook(userId, bookId); return Result.success("借阅成功"); } // 还书接口 @PostMapping("/return/{bookId}") public Result returnBook(@RequestParam Long userId, @PathVariable Integer bookId) { borrowService.returnBook(userId, bookId); return Result.success("归还成功"); } // 查询用户的借阅记录 @GetMapping("/history") public Result getBorrowHistory(@RequestParam Long userId) { List<Borrow> borrowedBooks = borrowService.findBorrowedBooks(userId); return Result.success(borrowedBooks); } }
BorrowService.java
新增用于获取未归还记录的接口。
package com.wwq.bookproject.service; import com.wwq.bookproject.pojo.Borrow; import java.util.List; public interface BorrowService { void borrowBook(Long userId, Integer bookId); // 借书操作 void returnBook(Long userId, Integer bookId); // 还书操作 List<Borrow> findBorrowedBooks(Long userId); // 查询用户的借阅记录 // 获取未归还借阅记录的方法 List<Borrow> getUnreturnedBorrowsByUserIdAndBookId(Long userId, Integer bookId); }
BorrowServiceImpl.java
实现借阅服务中检查未归还记录的逻辑。
package com.wwq.bookproject.service.impl; import com.wwq.bookproject.mapper.BookMapper; import com.wwq.bookproject.mapper.BorrowMapper; import com.wwq.bookproject.pojo.Book; import com.wwq.bookproject.pojo.Borrow; import com.wwq.bookproject.service.BorrowService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import java.time.LocalDateTime; import java.util.List; @Service public class BorrowServiceImpl implements BorrowService { @Autowired private BorrowMapper borrowMapper; @Autowired private BookMapper bookMapper; @Transactional @Override public void borrowBook(Long userId, Integer bookId) { // 检查书籍库存 Book book = bookMapper.getById(bookId); if (book == null || book.getQuantity() <= 0) { throw new RuntimeException("书籍库存不足或书籍不存在"); } // 减少书籍库存 bookMapper.update(new Book(bookId, book.getName(), book.getPublisher(), book.getAuthor(), LocalDateTime.now(), book.getQuantity() - 1)); // 新增借阅记录 Borrow borrow = new Borrow(); borrow.setUserId(userId); borrow.setBookId(bookId); borrow.setBorrowTime(LocalDateTime.now()); borrowMapper.addBorrowRecord(borrow); } @Transactional @Override public void returnBook(Long userId, Integer bookId) { // 查找是否有未归还的记录 Borrow borrow = borrowMapper.findUnreturnedRecord(userId, bookId); if (borrow == null) { throw new RuntimeException("没有找到未归还的记录"); } // 更新归还时间 borrowMapper.updateReturnTime(borrow.getId(), LocalDateTime.now()); // 增加书籍库存 Book book = bookMapper.getById(bookId); bookMapper.update(new Book(book.getId(), book.getName(), book.getPublisher(), book.getAuthor(), LocalDateTime.now(), book.getQuantity() + 1)); } @Override public List<Borrow> findBorrowedBooks(Long userId) { return borrowMapper.findBorrowedBooksByUserId(userId); } @Override public List<Borrow> getUnreturnedBorrowsByUserIdAndBookId(Long userId, Integer bookId) { return borrowMapper.findUnreturnedRecord(userId, bookId); } }
BorrowMapper.java
在 MyBatis 中添加 SQL 查询语句来检查书籍是否未归还。
package com.wwq.bookproject.mapper; import com.wwq.bookproject.pojo.Borrow; import org.apache.ibatis.annotations.*; import java.time.LocalDateTime; import java.util.List; @Mapper public interface BorrowMapper { // 新增借阅记录 @Insert("INSERT INTO borrow (user_id, book_id, borrow_time) VALUES (#{userId}, #{bookId}, #{borrowTime})") void addBorrowRecord(Borrow borrow); // 查询用户所有借阅记录 @Select("SELECT * FROM borrow WHERE user_id = #{userId}") List<Borrow> findBorrowedBooksByUserId(Long userId); // 查找未归还的记录 @Select("SELECT * FROM borrow WHERE user_id = #{userId} AND book_id = #{bookId} AND return_time IS NULL") List<Borrow> findUnreturnedRecord(@Param("userId") Long userId, @Param("bookId") Integer bookId); // 更新归还时间(还书操作) @Update("UPDATE borrow SET return_time = #{returnTime} WHERE id = #{id}") void updateReturnTime(@Param("id") Integer id, @Param("returnTime") LocalDateTime returnTime); // 检查是否有未归还记录(用于批量删除) @Select("<script>" + "SELECT DISTINCT book_id " + "FROM borrow " + "WHERE book_id IN " + "<foreach item='id' collection='ids' open='(' separator=',' close=')'>" + "#{id}" + "</foreach> AND return_time IS NULL" + "</script>") List<Integer> findBooksWithUnreturnedRecords(@Param("ids") List<Integer> ids); }
BookController.java
更新删除操作,确保无法删除有未归还记录的书籍。
@DeleteMapping("/{ids}") public Result delete(@PathVariable List<Integer> ids) { log.info("批量删除操作,ids:{}", ids); // 检查是否有未归还的借阅记录 List<Integer> inUseBooks = bookService.findBooksInUse(ids); if (!inUseBooks.isEmpty()) { return Result.error("部分书籍仍被用户借阅,无法删除"); } bookService.delete(ids); return Result.success("删除成功"); }
BookService.java
新增对未归还书籍的检查方法。
public interface BookService { List<Integer> findBooksInUse(List<Integer> ids); }
BookServiceImpl.java
实现对未归还书籍的检查逻辑。
@Override public List<Integer> findBooksInUse(List<Integer> ids) { return borrowMapper.findBooksWithUnreturnedRecords(ids); }
通过以上代码,后端可以实现:
- 确保不能重复借阅未归还的书籍。
- 管理员不能删除存在未归还记录关联的书籍。
- User
<el-menu-item index="3"> <router-link to="/books#section2">图书管理</router-link> </el-menu-item> </el-menu-item-group> </el-submenu> </el-menu> </el-col> </el-row> </el-menu><!-- 头部 --><!-- 主要内容区域 --> <el-main> <el-form :inline="true" :model="queryForm" class="demo-form-inline" style="margin-bottom: 20px;"> <el-form-item label="书名"> <el-input v-model="queryForm.name" placeholder="书名"></el-input> </el-form-item> <el-form-item> <el-button type="primary" @click="handleQuery">查询</el-button> <el-button type="default" @click="resetQuery" style="margin-left: 10px;">复原</el-button> </el-form-item> </el-form> <el-button type="primary" style="margin-top: 20px;" @click="addDialogVisible = true">新增图书</el-button> <el-button type="danger" @click="handleBatchDelete" style="margin-top: 20px;" :disabled="selectedRows.length === 0">批量删除</el-button> <el-table :data="tableData" tooltip-effect="dark" style="width: 100%; margin-top: 20px;" @selection-change="handleSelectionChange" > <el-table-column type="selection" width="55"></el-table-column> <el-table-column prop="name" label="书名" width="180"></el-table-column> <el-table-column prop="publisher" label="出版社" width="180"></el-table-column> <el-table-column prop="author" label="作者" width="180"></el-table-column> <el-table-column label="数量" prop="quantity" width="100"></el-table-column> <el-table-column label="存入时间" width="180"> <template #default="{ row }"> {{ formatDateTime(row.storeTime) }} </template> </el-table-column> <el-table-column label="操作" width="120"> <template #default="{ row }"> <el-button size="mini" @click="handleEdit(row)">编辑</el-button> <br> <br> <el-button size="mini" type="danger" @click="handleDelete(row.id)">删除</el-button> </template> </el-table-column> </el-table> <el-pagination @size-change="handleSizeChange" @current-change="handlePageChange" :current-page="currentPage" :page-sizes="[10, 20, 30, 40]" :page-size="pageSize" layout="total, sizes, prev, pager, next, jumper" style="text-align: right; margin-top: 20px;"> </el-pagination> <!-- 编辑对话框 --> <el-dialog title="编辑图书信息" :visible.sync="editDialogVisible"> <el-form :model="editForm"> <el-form-item label="书名"> <el-input v-model="editForm.name"></el-input> </el-form-item> <el-form-item label="出版社"> <el-input v-model="editForm.publisher"></el-input> </el-form-item> <el-form-item label="作者"> <el-input v-model="editForm.author"></el-input> </el-form-item> <el-form-item label="数量"> <el-input v-model.number="editForm.quantity" type="number"></el-input> </el-form-item> </el-form> <div slot="footer" class="dialog-footer"> <el-button @click="editDialogVisible = false">取消</el-button> <el-button type="primary" @click="handleSave">保存</el-button> </div> </el-dialog> <!-- 新增对话框 --> <el-dialog title="新增图书信息" :visible.sync="addDialogVisible"> <el-form :model="addForm"> <el-form-item label="书名"> <el-input v-model="addForm.name"></el-input> </el-form-item> <el-form-item label="出版社"> <el-input v-model="addForm.publisher"></el-input> </el-form-item> <el-form-item label="作者"> <el-input v-model="addForm.author"></el-input> </el-form-item> <el-form-item label="数量"> <el-input v-model.number="addForm.quantity" type="number"></el-input> </el-form-item> </el-form> <div slot="footer" class="dialog-footer"> <el-button @click="addDialogVisible = false">取消</el-button> <el-button type="primary" @click="handleAdd">新增</el-button> </div> </el-dialog> <!-- 新增按钮 --> </el-main> </el-container> </el-container>新增图书的数量至少为1
- Assistant
为了确保新增图书时 数量必须大于等于 1,可以使用
Element UI的表单验证规则来验证addForm表单。在这个解决方案中,我们将el-form组件的rules属性结合el-form-item的prop属性进行验证。
修改后的前端代码
修改
addForm的新增图书逻辑在新增书籍的弹窗表单中,新增 表单校验规则,确保:
- 数量字段是必填项。
- 数量必须 >= 1。
修改
<template>部分将
el-form中增加rules校验规则,且让数量字段引入校验逻辑:<el-dialog title="新增图书信息" :visible.sync="addDialogVisible"> <el-form :model="addForm" :rules="addRules" ref="addForm"> <el-form-item label="书名" prop="name"> <el-input v-model="addForm.name"></el-input> </el-form-item> <el-form-item label="出版社" prop="publisher"> <el-input v-model="addForm.publisher"></el-input> </el-form-item> <el-form-item label="作者" prop="author"> <el-input v-model="addForm.author"></el-input> </el-form-item> <el-form-item label="数量" prop="quantity"> <el-input v-model.number="addForm.quantity" type="number"></el-input> </el-form-item> </el-form> <div slot="footer" class="dialog-footer"> <el-button @click="addDialogVisible = false">取消</el-button> <el-button type="primary" @click="handleAdd">新增</el-button> </div> </el-dialog>
修改
<script>部分- 增加一个
rules对象,用来定义表单的验证规则。 - 在新增时验证表单,如果验证失败则阻止新增操作。
<script> import axios from 'axios'; export default { data() { return { queryForm: { name: '', }, tableData: [], currentPage: 1, pageSize: 10, editDialogVisible: false, editForm: { id: null, name: '', publisher: '', author: '', quantity: 1, }, addDialogVisible: false, addForm: { name: '', publisher: '', author: '', quantity: 1, }, selectedRows: [], addRules: { // 校验规则:书名非空 name: [ { required: true, message: '请输入书名', trigger: 'blur' }, ], // 校验规则:出版社非空 publisher: [ { required: true, message: '请输入出版社名称', trigger: 'blur' }, ], // 校验规则:作者非空 author: [ { required: true, message: '请输入作者名称', trigger: 'blur' }, ], // 校验规则:数量应大于0 quantity: [ { required: true, message: '请输入数量', trigger: 'blur' }, { type: 'number', min: 1, message: '数量必须大于或等于 1', trigger: 'blur', }, ], }, }; }, methods: { async handleQuery() { try { const response = await axios.get('http://localhost:8080/books', { params: { page: this.currentPage, pageSize: this.pageSize, name: this.queryForm.name, }, }); if (response.data.code === 1) { this.tableData = response.data.data.rows; } else { this.$message.error(response.data.msg); } } catch (error) { this.$message.error('查询失败,请重试'); console.error(error); } }, resetQuery() { // Reset the query form this.queryForm.name = ''; this.handleQuery(); // Reload the data with default values }, async handleEdit(row) { this.editForm = { ...row }; this.editDialogVisible = true; }, async handleSave() { try { const response = await axios.put('http://localhost:8080/books', this.editForm); if (response.data.code === 1) { this.$message.success('保存成功'); this.editDialogVisible = false; this.handleQuery(); } else { this.$message.error(response.data.msg); } } catch (error) { this.$message.error('保存失败,请重试'); console.error(error); } }, async handleDelete(id) { try { const response = await axios.delete(`http://localhost:8080/books/${id}`); if (response.data.code === 1) { this.$message.success('删除成功'); this.handleQuery(); } else { this.$message.error(response.data.msg); } } catch (error) { this.$message.error('删除失败,请重试'); console.error(error); } }, async handleAdd() { // 新增图书时,进行表单验证 this.$refs.addForm.validate(async (valid) => { if (!valid) { this.$message.error('表单校验失败,请检查输入内容'); return; } try { const response = await axios.post( 'http://localhost:8080/books', this.addForm ); if (response.data.code === 1) { this.$message.success('新增成功'); this.addDialogVisible = false; this.handleQuery(); this.resetAddForm(); // 重置新增表单内容 } else { this.$message.error(response.data.msg); } } catch (error) { this.$message.error('新增失败,请重试!'); console.error(error); } }); }, resetAddForm() { this.addForm = { name: '', publisher: '', author: '', quantity: 1, }; }, handleSizeChange(val) { this.pageSize = val; this.handleQuery(); }, handlePageChange(val) { this.currentPage = val; this.handleQuery(); }, handleSelectionChange(val) { this.selectedRows = val; }, formatDateTime(value) { if (!value) return ''; return new Date(value).toLocaleString(); }, }, mounted() { this.handleQuery(); }, }; </script>
修改亮点
-
新增表单的校验规则
- 校验规则中,
quantity的最小值是 1。 el-input[type="number"]的用户输入值会被校验。
- 校验规则中,
-
校验触发时机
trigger: 'blur':用户完成输入并失去焦点时触发校验。
-
表单校验通过即可新增
- 调用
this.$refs.addForm.validate()校验表单成功才能触发新增逻辑。
- 调用
测试步骤
- 打开新增对话框,输入完整的信息:
- 测试书名、作者、出版社是否必填,空输入时应有提示。
- 输入非法
quantity值(如小于 1 或为空):- 提示 "数量必须大于或等于 1"。
- 数据合法时:
- 点击 "新增",触发后端新增接口
/books,并将新增数据刷新到图书列表中。
- 点击 "新增",触发后端新增接口
效果预期
- 数量 < 1 时触发提示,输入无效,无法提交。
- 所有字段均符合规则后,弹窗消失,新增数据刷新到主书籍表格中。
- User
给我完整代码
- Assistant
以下是完整的代码实现,包括展示书籍列表、分页、删除、编辑、新增功能,以及确保在新增图书时数量字段不能小于1的功能实现。我们使用了
Element UI的表单验证规则,新增图书的表单需要通过验证规则后才能提交。
完整前端代码
<template> <div> <el-container> <!-- 侧边栏 --> <el-aside style="width: 200px;min-height: 100vh;background-color:rgb(254, 64, 74)"> <div style="height: 60px; display: flex; align-items: center; justify-content: center;"> <img src="./photo/GH.jpg" alt="Logo" style="width: 100%; height: auto;"> </div> <el-menu class="custom-menu" style="width: 200px; background-color: #fe8f8f;" popper-append-to-body> <el-row> <el-col :span="12"> <el-menu class="custom-menu" style="width: 200px; background-color: #fe8f8f;" popper-append-to-body> <el-submenu index="1"> <template slot="title"> <i class="el-icon-location"></i> <span>导航栏</span> </template> <el-menu-item-group> <el-menu-item index="3"> <router-link to="/books#section2">图书管理</router-link> </el-menu-item> </el-menu-item-group> </el-submenu> </el-menu> </el-col> </el-row> </el-menu> </el-aside> <el-container> <!-- 头部 --> <el-header style="font-family: 楷体;text-align: center;font-weight: bold;background-color:rgb(254, 64, 74);color: white;font-size: 50px;"> 红色精神图书管理系统 </el-header> <!-- 主要内容区域 --> <el-main> <!-- 查询表单 --> <el-form :inline="true" :model="queryForm" class="demo-form-inline" style="margin-bottom: 20px;"> <el-form-item label="书名"> <el-input v-model="queryForm.name" placeholder="书名"></el-input> </el-form-item> <el-form-item> <el-button type="primary" @click="handleQuery">查询</el-button> <el-button type="default" @click="resetQuery" style="margin-left: 10px;">复原</el-button> </el-form-item> </el-form> <!-- 新增和批量删除 --> <el-button type="primary" style="margin-top: 20px;" @click="addDialogVisible = true">新增图书</el-button> <el-button type="danger" @click="handleBatchDelete" style="margin-top: 20px;" :disabled="selectedRows.length === 0">批量删除</el-button> <!-- 图书列表 --> <el-table :data="tableData" tooltip-effect="dark" style="width: 100%; margin-top: 20px;" @selection-change="handleSelectionChange" > <el-table-column type="selection" width="55"></el-table-column> <el-table-column prop="name" label="书名" width="180"></el-table-column> <el-table-column prop="publisher" label="出版社" width="180"></el-table-column> <el-table-column prop="author" label="作者" width="180"></el-table-column> <el-table-column label="数量" prop="quantity" width="100"></el-table-column> <el-table-column label="存入时间" prop="storeTime" width="180"> <template #default="{ row }"> {{ formatDateTime(row.storeTime) }} </template> </el-table-column> <el-table-column label="操作" width="120"> <template #default="{ row }"> <el-button size="mini" @click="handleEdit(row)">编辑</el-button> <el-button size="mini" type="danger" @click="handleDelete(row.id)">删除</el-button> </template> </el-table-column> </el-table> <!-- 分页 --> <el-pagination @size-change="handleSizeChange" @current-change="handlePageChange" :current-page="currentPage" :page-sizes="[10, 20, 30, 40]" :page-size="pageSize" layout="total, sizes, prev, pager, next, jumper" style="text-align: right; margin-top: 20px;"> </el-pagination> <!-- 编辑对话框 --> <el-dialog title="编辑图书信息" :visible.sync="editDialogVisible"> <el-form :model="editForm"> <el-form-item label="书名"> <el-input v-model="editForm.name"></el-input> </el-form-item> <el-form-item label="出版社"> <el-input v-model="editForm.publisher"></el-input> </el-form-item> <el-form-item label="作者"> <el-input v-model="editForm.author"></el-input> </el-form-item> <el-form-item label="数量"> <el-input v-model.number="editForm.quantity" type="number"></el-input> </el-form-item> </el-form> <div slot="footer" class="dialog-footer"> <el-button @click="editDialogVisible = false">取消</el-button> <el-button type="primary" @click="handleSave">保存</el-button> </div> </el-dialog> <!-- 新增对话框 --> <el-dialog title="新增图书信息" :visible.sync="addDialogVisible"> <el-form :model="addForm" :rules="addRules" ref="addForm"> <el-form-item label="书名" prop="name"><el-input v-model="addForm.name" placeholder="书名"></el-input></el-form-item> <el-form-item label="出版社" prop="publisher"><el-input v-model="addForm.publisher" placeholder="出版社"></el-input></el-form-item> <el-form-item label="作者" prop="author"><el-input v-model="addForm.author" placeholder="作者"></el-input></el-form-item> <el-form-item label="数量" prop="quantity"><el-input v-model.number="addForm.quantity" type="number"></el-input></el-form-item> </el-form> <div slot="footer" class="dialog-footer"> <el-button @click="addDialogVisible = false">取消</el-button> <el-button type="primary" @click="handleAdd">新增</el-button> </div> </el-dialog> </el-main> </el-container> </el-container> </div> </template> <script> import axios from "axios"; export default { data() { return { queryForm: { name: "" }, tableData: [], currentPage: 1, pageSize: 10, editDialogVisible: false, editForm: { id: null, name: "", publisher: "", author: "", quantity: 1 }, addDialogVisible: false, addForm: { name: "", publisher: "", author: "", quantity: 1 }, addRules: { name: [{ required: true, message: "请输入书名", trigger: "blur" }], publisher: [{ required: true, message: "请输入出版社名称", trigger: "blur" }], author: [{ required: true, message: "请输入作者名称", trigger: "blur" }], quantity: [ { required: true, message: "请输入数量", trigger: "blur" }, { type: "number", min: 1, message: "数量必须大于等于 1", trigger: "blur" }, ], }, selectedRows: [], }; }, methods: { async handleQuery() { try { const response = await axios.get("http://localhost:8080/books", { params: { page: this.currentPage, pageSize: this.pageSize, name: this.queryForm.name }, }); if (response.data.code === 1) { this.tableData = response.data.data.rows; } else { this.$message.error("查询失败,请重试!"); } } catch (error) { console.error("查询失败", error); } }, async handleAdd() { this.$refs.addForm.validate(async (valid) => { if (valid) { try { const response = await axios.post("http://localhost:8080/books", this.addForm); if (response.data.code === 1) { this.$message.success("新增成功!"); this.addDialogVisible = false; this.handleQuery(); this.addForm = { name: "", publisher: "", author: "", quantity: 1 }; // 重置表单 } else { this.$message.error("新增失败,请重试!"); } } catch (error) { console.error("新增失败", error); } } }); }, resetQuery() { this.queryForm.name = ""; this.handleQuery(); }, async handleEdit(row) { this.editForm = { ...row }; this.editDialogVisible = true; }, async handleSave() { try { const response = await axios.put("http://localhost:8080/books", this.editForm); if (response.data.code === 1) { this.$message.success("保存成功!"); this.editDialogVisible = false; this.handleQuery(); } else { this.$message.error("保存失败,请重试!"); } } catch (error) { console.error("保存失败", error); } }, async handleDelete(id) { try { const response = await axios.delete(`http://localhost:8080/books/${id}`); if (response.data.code === 1) { this.$message.success("删除成功!"); this.handleQuery(); } else { this.$message.error("删除失败,请重试!"); } } catch (error) { console.error("删除失败", error); } }, handleSelectionChange(val) { this.selectedRows = val; }, formatDateTime(value) { if (!value) return ""; return new Date(value).toLocaleString(); }, handleSizeChange(val) { this.pageSize = val; this.handleQuery(); }, handlePageChange(val) { this.currentPage = val; this.handleQuery(); }, }, mounted() { this.handleQuery(); }, }; </script> <style scoped> .custom-menu.el-menu-item span, .custom-menu.el-menu-item { color: white !important; font-weight: bold; } .el-menu-item:hover { background-color: yellow !important; color: red !important; } .el-table .el-table__body-wrapper { margin-top: 10px; } .el-table .el-table__row { margin: 10px 0; } </style>
主要特点
- 展示图书列表:分页和展示字段。
- 新增功能:
- 校验规则确保图书数量不能小于 1。
- 使用
Element UI的rules和校验表单,小于 1 提示错误。
- 编辑功能:直接更新书籍内容。
- 查询功能:输入书名可以模糊搜索。
- 批量删除:选中的书可进行批量删除操作。
以上代码可以直接复制粘贴到项目中。如果有任何不清楚的地方,请随时联系!
- User
<el-container> <!-- 头部 --> <el-header style="font-family: 楷体; text-align: center; font-weight: bold; background-color: rgb(254, 64, 74); color: white; font-size: 50px;"> 红色精神图书管理系统 </el-header> <!-- 主内容 --> <el-main> <!-- 查询表单 --> <el-form :inline="true" :model="queryForm" class="demo-form-inline" style="margin-bottom: 20px;"> <el-form-item label="书名"> <el-input v-model="queryForm.name" placeholder="书名"></el-input> </el-form-item> <el-form-item> <el-button type="primary" @click="handleQuery">查询</el-button> <el-button type="default" @click="resetQuery" style="margin-left: 10px;">复原</el-button> </el-form-item> </el-form> <!-- 我的借阅 --> <el-button type="primary" style="margin-top: 20px;" @click="handleMyBorrowed">我的借阅</el-button> <!-- 书籍列表 --> <el-table :data="tableData" tooltip-effect="dark" style="width: 100%; margin-top: 20px;" @selection-change="handleSelectionChange" > <el-table-column type="selection" width="55"></el-table-column> <el-table-column prop="name" label="书名" width="180"></el-table-column> <el-table-column prop="publisher" label="出版社" width="180"></el-table-column> <el-table-column prop="author" label="作者" width="180"></el-table-column> <el-table-column label="数量" prop="quantity" width="100"></el-table-column> <el-table-column label="存入时间" width="180"> <template #default="{ row }"> {{ formatDateTime(row.storeTime) }} </template> </el-table-column> <el-table-column label="操作" width="120"> <template #default="{ row }"> <el-button size="mini" @click="handleBorrow(row)" :disabled="row.quantity <= 0">借阅</el-button> </template> </el-table-column> </el-table> <!-- 分页 --> <el-pagination @size-change="handleSizeChange" @current-change="handlePageChange" :current-page="currentPage" :page-sizes="[10, 20, 30, 40]" :page-size="pageSize" layout="total, sizes, prev, pager, next, jumper" style="text-align: right; margin-top: 20px;" > </el-pagination> <!-- 我的借阅记录 --> <el-dialog title="我的借阅记录" :visible.sync="myBorrowedVisible"> <el-table :data="myBorrowedData" style="width: 100%"> <el-table-column prop="bookId" label="书籍编号" width="100"></el-table-column> <el-table-column prop="borrowTime" label="借阅时间" width="180"> <template #default="{ row }"> {{ formatDateTime(row.borrowTime) }} </template> </el-table-column> <el-table-column prop="returnTime" label="归还时间" width="180"> <template #default="{ row }"> {{ row.returnTime ? formatDateTime(row.returnTime) : "未归还" }} </template> </el-table-column> <el-table-column label="操作" width="120"> <template #default="{ row }"> <el-button size="mini" @click="handleBorrow(row)" :disabled="row.quantity <= 0 || isAlreadyBorrowed(row.id)" > 借阅 </el-button> </template> </el-table-column> </el-table> </el-dialog> </el-main> </el-container> </el-container>怎么我归还按钮不见了
- Assistant
问题的关键在于现有代码中没有明确实现 “归还” 按钮 的具体逻辑。你的代码中只有借书的按钮
借阅 (handleBorrow),而没有提供归还操作的按钮。下面是详细指导,如何将“归还”功能添加到表格中,让归还按钮出现在用户的借阅记录中。
修改点
- 归还按钮添加
- “我的借阅记录”弹窗中的表格需要展示“归还”按钮,并绑定“归还”功能。
- “未归还的书籍”可以看到按钮,归还后按钮禁用。
- 按钮状态逻辑:
- 归还按钮只有在
returnTime为null时显示,归还后禁用按钮。
修改代码
修改
<el-table>部分在“我的借阅记录”的弹窗表格中,添加「归还」按钮:
修改代码
<el-dialog title="我的借阅记录" :visible.sync="myBorrowedVisible"> <el-table :data="myBorrowedData" style="width: 100%"> <el-table-column prop="bookId" label="书籍编号" width="100"></el-table-column> <el-table-column prop="borrowTime" label="借阅时间" width="180"> <template #default="{ row }"> {{ formatDateTime(row.borrowTime) }} </template> </el-table-column> <el-table-column prop="returnTime" label="归还时间" width="180"> <template #default="{ row }"> {{ row.returnTime ? formatDateTime(row.returnTime) : "未归还" }} </template> </el-table-column> <el-table-column label="操作" width="120"> <template #default="{ row }"> <el-button size="mini" type="primary" :disabled="row.returnTime !== null" <!-- 已归还的记录禁用按钮 --> @click="handleReturn(row)" > 归还 </el-button> </template> </el-table-column> </el-table> </el-dialog>
新增「归还」方法逻辑
实现
handleReturn方法,调用后端的归还 API。修改代码
methods: { // 归还书籍 async handleReturn(row) { if (!row.bookId) { this.$message.error('书籍信息有误,无法归还!'); return; } try { const response = await axios.post( `http://localhost:8080/borrow/return/${row.bookId}`, null, /* POST body 为空 */ { params: { userId: this.userId }, // userId 放在查询参数中 } ); if (response.data.code === 1) { this.$message.success('归还成功!'); this.handleMyBorrowed(); // 刷新借阅记录 } else { this.$message.error(response.data.msg || '归还失败!'); } } catch (error) { this.$message.error('归还失败,请稍后重试!'); console.error(error); } }, ...
综合调整后的完整代码
完整的 “我的借阅记录” 部分
<el-dialog title="我的借阅记录" :visible.sync="myBorrowedVisible"> <el-table :data="myBorrowedData" style="width: 100%"> <el-table-column prop="bookId" label="书籍编号" width="100"></el-table-column> <el-table-column prop="borrowTime" label="借阅时间" width="180"> <template #default="{ row }"> {{ formatDateTime(row.borrowTime) }} </template> </el-table-column> <el-table-column prop="returnTime" label="归还时间" width="180"> <template #default="{ row }"> {{ row.returnTime ? formatDateTime(row.returnTime) : "未归还" }} </template> </el-table-column> <el-table-column label="操作" width="120"> <template #default="{ row }"> <el-button size="mini" type="primary" :disabled="row.returnTime !== null" <!-- 根据归还状态禁用 --> @click="handleReturn(row)" > 归还 </el-button> </template> </el-table-column> </el-table> </el-dialog>
注意点
-
归还逻辑调用接口
- 确保后端实现了
/borrow/return/{bookId}接口。 - 返回数据中包含成功或失败信息。
- 确保后端实现了
-
按钮状态
- 未归还的书籍 (
row.returnTime === null) 显示“归还”按钮并可用。 - 已归还的书籍 (
row.returnTime !== null) 禁用按钮。
- 未归还的书籍 (
-
借阅记录刷新
- 调用
handleMyBorrowed()重新获取借阅记录,确保 UI 是最新状态。
- 调用
后端接口说明
确认后端归还接口
/borrow/return/{bookId}支持以下参数:- URL Path 参数
bookId: 归还书籍的编号。
- Query 参数
userId: 当前归还该书籍的用户 ID。
- 返回 JSON 示例
{ "code": 1, "msg": "归还成功" }
特殊情况调试
-
「我的借阅记录」为空:
- 检查
handleMyBorrowed()请求,确保后端接口/borrow/history返回用户的所有借阅记录。 - 确认用户 ID 正确传递,且数据库中存在用户的借阅信息。
- 检查
-
按钮禁用检测:
- 调试条件
:disabled="row.returnTime !== null"确保正确判断按钮状态。
- 调试条件
-
归还失败:
- 调试日志打印错误信息,检查
/borrow/return/{bookId}回调接口是否响应失败。
- 调试日志打印错误信息,检查
如果仍有问题,欢迎继续交流!
- User
<el-container> <!-- 头部 --> <el-header style="font-family: 楷体; text-align: center; font-weight: bold; background-color: rgb(254, 64, 74); color: white; font-size: 50px;"> 红色精神图书管理系统 </el-header> <!-- 主内容 --> <el-main> <!-- 查询表单 --> <el-form :inline="true" :model="queryForm" class="demo-form-inline" style="margin-bottom: 20px;"> <el-form-item label="书名"> <el-input v-model="queryForm.name" placeholder="书名"></el-input> </el-form-item> <el-form-item> <el-button type="primary" @click="handleQuery">查询</el-button> <el-button type="default" @click="resetQuery" style="margin-left: 10px;">复原</el-button> </el-form-item> </el-form> <!-- 我的借阅 --> <el-button type="primary" style="margin-top: 20px;" @click="handleMyBorrowed">我的借阅</el-button> <!-- 书籍列表 --> <el-table :data="tableData" tooltip-effect="dark" style="width: 100%; margin-top: 20px;" @selection-change="handleSelectionChange" > <el-table-column type="selection" width="55"></el-table-column> <el-table-column prop="name" label="书名" width="180"></el-table-column> <el-table-column prop="publisher" label="出版社" width="180"></el-table-column> <el-table-column prop="author" label="作者" width="180"></el-table-column> <el-table-column label="数量" prop="quantity" width="100"></el-table-column> <el-table-column label="存入时间" width="180"> <template #default="{ row }"> {{ formatDateTime(row.storeTime) }} </template> </el-table-column> <el-table-column label="操作" width="120"> <template #default="{ row }"> <el-button size="mini" @click="handleBorrow(row)" :disabled="row.quantity <= 0">借阅</el-button> </template> </el-table-column> </el-table> <!-- 分页 --> <el-pagination @size-change="handleSizeChange" @current-change="handlePageChange" :current-page="currentPage" :page-sizes="[10, 20, 30, 40]" :page-size="pageSize" layout="total, sizes, prev, pager, next, jumper" style="text-align: right; margin-top: 20px;" > </el-pagination> <!-- 我的借阅记录 --> <el-dialog title="我的借阅记录" :visible.sync="myBorrowedVisible"> <el-table :data="myBorrowedData" style="width: 100%"> <el-table-column prop="bookId" label="书籍编号" width="100"></el-table-column> <el-table-column prop="borrowTime" label="借阅时间" width="180"> <template #default="{ row }"> {{ formatDateTime(row.borrowTime) }} </template> </el-table-column> <el-table-column prop="returnTime" label="归还时间" width="180"> <template #default="{ row }"> {{ row.returnTime ? formatDateTime(row.returnTime) : "未归还" }} </template> </el-table-column> <el-table-column label="操作" width="120"> <template #default="{ row }"> <el-button size="mini" @click="handleBorrow(row)" :disabled="row.quantity <= 0 || isAlreadyBorrowed(row.id)" > 借阅 </el-button> </template> </el-table-column> </el-table> </el-dialog> </el-main> </el-container> </el-container>实现 “归还” 按钮 的具体逻辑,给我完整的代码
- Assistant
以下是添加“归还”按钮功能的完整代码,其中包括“我的借阅记录”表格中为未归还的书籍提供一个“归还”按钮的交互,以及归还逻辑的实现。
完整实现“归还”按钮功能
前端代码
修改
<template>部分在“我的借阅记录”对话框中,为每本书籍记录的最右操作列添加
归还按钮。按钮的状态根据returnTime来动态控制:如果书籍已归还(returnTime不为空),则按钮禁用;否则允许使用按钮归还书籍。<template> <div> <el-container> <!-- 侧边栏 --> <el-aside style="width: 200px;min-height: 100vh;background-color:rgb(254, 64, 74)"> <div style="height: 60px; display: flex; align-items: center; justify-content: center;"> <img src="./photo/GH.jpg" alt="Logo" style="width: 100%; height: auto;"> </div> <el-menu class="custom-menu" style="width: 200px; background-color: #fe8f8f;" popper-append-to-body> <el-row> <el-col :span="12"> <el-menu class="custom-menu" style="width: 200px; background-color: #fe8f8f;" popper-append-to-body> <el-submenu index="1"> <template slot="title"> <i class="el-icon-location"></i> <span>导航栏</span> </template> <el-menu-item-group> <el-menu-item index="2"> <router-link to="/home#section1">首页</router-link> </el-menu-item> <el-menu-item index="4"> <router-link to="/borrow">借阅系统</router-link> </el-menu-item> </el-menu-item-group> </el-submenu> </el-menu> </el-col> </el-row> </el-menu> </el-aside> <el-container> <!-- 头部 --> <el-header style="font-family: 楷体;text-align: center;font-weight: bold;background-color:rgb(254, 64, 74);color: white;font-size: 50px;"> 红色精神图书管理系统 </el-header> <!-- 主内容 --> <el-main> <!-- 查询表单 --> <el-form :inline="true" :model="queryForm" class="demo-form-inline" style="margin-bottom: 20px;"> <el-form-item label="书名"> <el-input v-model="queryForm.name" placeholder="书名"></el-input> </el-form-item> <el-form-item> <el-button type="primary" @click="handleQuery">查询</el-button> <el-button type="default" @click="resetQuery" style="margin-left: 10px;">复原</el-button> </el-form-item> </el-form> <!-- 我的借阅 --> <el-button type="primary" style="margin-top: 20px;" @click="handleMyBorrowed">我的借阅</el-button> <!-- 书籍列表 --> <el-table :data="tableData" tooltip-effect="dark" style="width: 100%; margin-top: 20px;" @selection-change="handleSelectionChange" > <el-table-column type="selection" width="55"></el-table-column> <el-table-column prop="name" label="书名" width="180"></el-table-column> <el-table-column prop="publisher" label="出版社" width="180"></el-table-column> <el-table-column prop="author" label="作者" width="180"></el-table-column> <el-table-column label="数量" prop="quantity" width="100"></el-table-column> <el-table-column label="存入时间" width="180"> <template #default="{ row }"> {{ formatDateTime(row.storeTime) }} </template> </el-table-column> <el-table-column label="操作" width="120"> <template #default="{ row }"> <el-button size="mini" @click="handleBorrow(row)" :disabled="row.quantity <= 0">借阅</el-button> </template> </el-table-column> </el-table> <!-- 分页 --> <el-pagination @size-change="handleSizeChange" @current-change="handlePageChange" :current-page="currentPage" :page-sizes="[10, 20, 30, 40]" :page-size="pageSize" layout="total, sizes, prev, pager, next, jumper" style="text-align: right; margin-top: 20px;" > </el-pagination> <!-- 我的借阅记录 --> <el-dialog title="我的借阅记录" :visible.sync="myBorrowedVisible"> <el-table :data="myBorrowedData" style="width: 100%"> <el-table-column prop="bookId" label="书籍编号" width="100"></el-table-column> <el-table-column prop="borrowTime" label="借阅时间" width="180"> <template #default="{ row }"> {{ formatDateTime(row.borrowTime) }} </template> </el-table-column> <el-table-column prop="returnTime" label="归还时间" width="180"> <template #default="{ row }"> {{ row.returnTime ? formatDateTime(row.returnTime) : "未归还" }} </template> </el-table-column> <el-table-column label="操作" width="120"> <template #default="{ row }"> <!-- 归还按钮 --> <el-button size="mini" type="primary" @click="handleReturn(row)" :disabled="row.returnTime !== null" > 归还 </el-button> </template> </el-table-column> </el-table> </el-dialog> </el-main> </el-container> </el-container> </div> </template>
修改
<script>部分在
methods中添加归还逻辑函数handleReturn。<script> import axios from 'axios'; export default { data() { return { queryForm: { name: '', }, tableData: [], currentPage: 1, pageSize: 10, selectedRows: [], myBorrowedVisible: false, myBorrowedData: [], userId: 1, }; }, methods: { // 查询书籍数据 async handleQuery() { try { const response = await axios.get('http://localhost:8080/books', { params: { page: this.currentPage, pageSize: this.pageSize, name: this.queryForm.name, }, }); if (response.data.code === 1) { this.tableData = response.data.data.rows; } else { this.$message.error('查询失败,请稍后重试!'); } } catch (error) { console.error(error); } }, // 获取我的借阅记录 async handleMyBorrowed() { try { const response = await axios.get('http://localhost:8080/borrow/history', { params: { userId: this.userId }, }); if (response.data.code === 1) { this.myBorrowedData = response.data.data; this.myBorrowedVisible = true; } else { this.$message.error('获取借阅记录失败,请稍后重试!'); } } catch (error) { console.error('获取借阅记录失败', error); } }, // 归还书籍 async handleReturn(row) { try { // 调用后端归还 API const response = await axios.post( `http://localhost:8080/borrow/return/${row.bookId}`, null, { params: { userId: this.userId } } ); if (response.data.code === 1) { this.$message.success('归还成功!'); this.handleMyBorrowed(); // 重新加载借阅记录 } else { this.$message.error('归还失败,请稍后重试!'); } } catch (error) { console.error('归还失败', error); this.$message.error('归还失败,请稍后重试!'); } }, // 格式化时间 formatDateTime(value) { if (!value) return '无数据'; return new Date(value).toLocaleString('zh-CN', { hour12: false }); }, }, mounted() { this.handleQuery(); }, }; </script>
效果演示
1. 未归还时:
- 归还按钮可用。
- 点击按钮调用后端 API 完成归还。
2. 已归还时:
- 归还按钮禁用。
3. 操作后:
- 调用
handleMyBorrowed()刷新列表,实时更新数据库和 UI 的状态。
如果仍有问题,请随时联系我!