13图书归还-云图书管理系统（Vue3+Spring Boot+element plus）

1 接口地址
2 后台代码
- - RecordController
  - BookController
3 view/books/BookRecordsVue中前端框架搭建
4 api/record.js文件写查询用户借阅记录的接口代码
5 api/book.js中写归还图书、查询当前借阅图书接口代码
6 BookRecordsVue中导入接口函数，并调用
7 运行效果

1 接口地址

### 用户借阅历史
GET http://localhost:8082/record/pastBorrowedRecords

### 用户当前所借图书
GET http://localhost:8082/book/currentBorrowedBooks

### 图书归还
GET http://localhost:8082/book/returnBook

2 后台代码

RecordController

    //历史借阅记录
    @GetMapping("/pastBorrowedRecords")
    public Result pastBorrowedRecords(){
        User user = ThreadLocalUtil.get();
        LambdaQueryWrapper<Record> recordWrapper = new LambdaQueryWrapper<>();
        recordWrapper.eq(Record::getRecordBorrower,user.getUserName());
        List<Record> recordList = iRecordService.list(recordWrapper);
        System.out.println("曾经的借阅记录");
        return Result.success(recordList);
    }

BookController

    //用户归还图书功能
    @GetMapping("/returnBook")
    public Result returnBook(@RequestParam("bookId") Integer bookId){
//        获取用户信息
        User loginUser = ThreadLocalUtil.get();

        //通过book_id查找需要归还的图书
        Book bookMsg = iBookService.getById(bookId);
        String TheBorrowtime = bookMsg.getBookBorrowtime();

//      获取当前时间
        DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd");
        String TheRemandtime = LocalDate.now().format(formatter);
        UpdateWrapper<Book> updateWrapper = new UpdateWrapper<>();
        updateWrapper.eq("book_borrower",loginUser.getUserName())
                .eq("book_status","1")
                .eq("book_id",bookId)
                .set("book_status","0")
                .set("book_borrower",null)
                .set("book_borrowtime",null)
                .set("book_returntime",null);
        boolean result = iBookService.update(updateWrapper); // 调用 update 方法

//      图书状态修改之后 还需要新增一条借阅记录
        Record record = new Record();
        record.setRecordBookname(bookMsg.getBookName());
        record.setRecordBorrower(loginUser.getUserName());
        record.setRecordBookisbn(bookMsg.getBookIsbn());
        record.setRecordBorrowtime(TheBorrowtime);
        record.setRecordRemandtime(TheRemandtime);
        boolean result1 = iRecordService.save(record); // 调用 save 方法
        if (result1) {
            System.out.println("Record updated successfully.");
            return Result.success("归还图书成功");
        } else {
            return Result.error("归还失败，可能没有借阅信息或者是其他问题!");
        }
    }

 //用户借阅图书功能
    @GetMapping("/borrowBook")
    public Result userBorrowBook(String bookId){
       User user = ThreadLocalUtil.get();
//      查询用户当前借了是否达到三本书，如果达到，禁止借阅
        QueryWrapper<Book> queryWrapper = new QueryWrapper<>();
        queryWrapper.eq("book_borrower",user.getUserName());
        List<Book> books = iBookService.list(queryWrapper);
        if(books.size()>=3){
            return Result.error("借阅图书失败，借阅图书数量已达上限!");
        }
        //定义时间格式
        DateTimeFormatter dateFormatter = DateTimeFormatter.ofPattern("yyyy-MM-dd");
        //获取当前时间 格式为 yyyy-MM-dd
        String borrowTime = LocalDate.now().format(dateFormatter);
        //设置还书时间为当前时间的30天之后
        String returnTime =  LocalDate.now().plusDays(30).format(dateFormatter);
        //通过book_id查找需要借阅的图书
        UpdateWrapper<Book> updateWrapper = new UpdateWrapper<>();
        updateWrapper.eq("book_id",bookId)
                .set("book_borrower",user.getUserName())
                .set("book_status","1")
                .set("book_borrowtime",borrowTime)
                .set("book_returntime",returnTime);

        boolean result = iBookService.update(updateWrapper); // 调用 update 方法
        if (result) {
            return Result.success("借阅图书成功");
        } else {
            return Result.error("借阅失败，可能图书已被其他人借阅或者是其他问题!");
        }
    }

3 view/books/BookRecordsVue中前端框架搭建

<script setup>
import { ref, computed } from 'vue'
import { ElMessage, ElMessageBox } from 'element-plus'

// 默认显示第一个tab
const activeTab = ref('current')
// 图书表单数据模型
const bookModel = ref({
    bookId: 0,
    bookName: '',
    bookIsbn: '',
    bookPress: '',
    bookAuthor: '',
    bookPagination: '',
    bookPrice: '',
    bookUploadtime: '',
    bookStatus: '',
    bookBorrower: '',
    bookBorrowtime: '',
    bookReturntime: ''
})

// 借阅记录的数据模型
const recordModel = ref({
    recordId: 0,
    recordBookname: '',
    recordBookisbn: '',
    recordBorrower: '',
    recordBorrowtime: '',
    recordRemandtime: ''
})

// 当前借阅的图书列表
const currentBorrowedBooks = ref([

    // 其他当前借阅的图书项...
])

// 曾经的借阅记录列表
const pastBorrowedRecords = ref([

    // 其他借阅记录项...
])



// 获取用户当前借阅的图书
const getUsersCurrentBorrowedBooks = async () => {

}

// 获取用户曾经的借阅记录
const getUsersPastBorrowedRecords = async () => {

}

// 初始化时获取用户当前借阅的图书和曾经的借阅记录
getUsersCurrentBorrowedBooks()
getUsersPastBorrowedRecords()

// 归还图书
const returnBookToBackend = (book) => {

}
</script>

<template>
    <el-card class="page-container">
        <el-tabs v-model="activeTab" @tab-click="handleTabClick">
            <el-tab-pane label="当前借阅" name="current">
                <el-table :data="currentBorrowedBooks" style="width: 100%">
                    <el-table-column prop="bookName" label="书名"></el-table-column>
                    <el-table-column prop="bookAuthor" label="作者"></el-table-column>
                    <el-table-column prop="bookPress" label="出版社"></el-table-column>
                    <el-table-column prop="bookBorrowtime" label="借阅时间"></el-table-column>
                    <el-table-column label="操作" width="180">
                        <template #default="{ row }">
                            <el-button type="danger" @click="returnBook(row)">归还</el-button>
                        </template>
                    </el-table-column>
                </el-table>
            </el-tab-pane>
            <el-tab-pane label="借阅记录" name="past">
                <el-table :data="pastBorrowedRecords" style="width: 100%"
                    :default-sort="{ prop: 'recordRemandtime', order: 'ascending' }">
                    <el-table-column prop="recordBookname" label="书名"></el-table-column>
                    <el-table-column prop="recordBookisbn" label="ISBN"></el-table-column>
                    <el-table-column prop="recordBorrower" label="借阅人"></el-table-column>
                    <el-table-column prop="recordBorrowtime" label="借阅时间" sortable></el-table-column>
                    <el-table-column prop="recordRemandtime" label="归还时间" sortable></el-table-column>
                </el-table>
            </el-tab-pane>
        </el-tabs>
    </el-card>
</template>

<style scoped>
.page-container {
    padding: 20px;
}
</style>

效果如下
在这里插入图片描述

4 api/record.js文件写查询用户借阅记录的接口代码

// 导入request
import request from '@/utils/request'

// 查询用户借阅记录
export const pastBorrowedRecordsService = () => {
    return request.get('/record/pastBorrowedRecords')
}

5 api/book.js中写归还图书、查询当前借阅图书接口代码

// 用户当前借阅的图书
export const userBorrowListService = () => {
    return request.get('/book/currentBorrowedBooks')
}

// 归还图书 发送get请求
export const bookReturnService = (bookId) => {
    return request.get('/book/returnBook', { params: { bookId: bookId } })
}

6 BookRecordsVue中导入接口函数，并调用

//导入用户当前借阅 userBorrowListService
import { userBorrowListService } from '@/api/book'
// 获取用户当前借阅的图书
const getUsersCurrentBorrowedBooks = async () => {
    // 这里可以调用后端API获取用户当前借阅的图书
    // 假设这里有一个返回当前借阅图书的模拟函数
    const result = await userBorrowListService()
    currentBorrowedBooks.value = result.data
}

//导入用户借阅历史接口 pastBorrowedRecordsService
import { pastBorrowedRecordsService } from '@/api/record'
// 获取用户曾经的借阅记录
const getUsersPastBorrowedRecords = async () => {
    // 这里可以调用后端API获取用户曾经的借阅记录
    // 假设这里有一个返回借阅记录的模拟函数
    const result = await pastBorrowedRecordsService()
    pastBorrowedRecords.value = result.data
}

// 初始化时获取用户当前借阅的图书和曾经的借阅记录
getUsersCurrentBorrowedBooks()
getUsersPastBorrowedRecords()

// 导入 bookReturnService
import { bookReturnService } from '@/api/book'
// 归还图书
const returnBook = (book) => {
    // 提醒是否要归还这本书
    return ElMessageBox.confirm('确定要归还《' + book.bookName + '》吗？', '提示', {
        confirmButtonText: '确定',
        cancelButtonText: '取消',
        type: 'warning'
    }).then(() => {
        // 用户点击了确定
        // 这里可以调用后端API归还图书
        return bookReturnService(book.bookId).then(result => {
            ElMessage.success(result.data ? result.data : '图书已归还')
            getUsersCurrentBorrowedBooks();
            getUsersPastBorrowedRecords();

        })
    })
}