JavaWeb——基于 Spring Boot + Vue 的图书管理系统的设计与实现

package com.liwo.bms.utils;

import java.util.HashMap;

public class MyResult {

    public static HashMap<String, Object> getResultMap(Integer status, String message) {
        return new HashMap<String, Object>() {
            {
                put("status", status);
                put("message", message);
                put("timestamp", System.currentTimeMillis());
            }
        };
    }

    public static HashMap<String, Object> getResultMap(Integer status, String message, Object data) {
        return new HashMap<String, Object>() {
            {
                put("status", status);
                put("message", message);
                put("data", data);
                put("timestamp", System.currentTimeMillis());
            }
        };
    }

    public static HashMap<String, Object> getListResultMap(Integer status, String message, Integer count, Object data) {
        return new HashMap<String, Object>() {
            {
                put("code", status);
                put("message", message);
                put("count", count);
                put("data", data);
            }
        };
    }
}

package com.liwo.bms.web;

import com.liwo.bms.model.BookInfo;
import com.liwo.bms.service.BookInfoService;
import com.liwo.bms.utils.MyResult;
import com.liwo.bms.utils.MyUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import java.util.List;
import java.util.Map;

@RestController
@RequestMapping(value = "/bookInfo")
public class BookInfoController {

    @Autowired
    BookInfoService bookInfoService;

    // 获取图书数量
    @GetMapping(value = "/getCount")
    public Integer getCount(){
        return bookInfoService.getCount();
    }

    // 查询所有图书信息
    @GetMapping(value = "/queryBookInfos")
    public List<BookInfo> queryBookInfos(){
        return bookInfoService.queryBookInfos();
    }

    // 分页搜索查询图书信息 params: {page, limit, bookname, bookauthor, booktypeid}
    @GetMapping(value = "/queryBookInfosByPage")
    public Map<String, Object> queryBookInfosByPage(@RequestParam Map<String, Object> params){
        MyUtils.parsePageParams(params);
        int count = bookInfoService.getSearchCount(params);  // 获得总数
        List<BookInfo> bookInfos = bookInfoService.searchBookInfosByPage(params);  // 分页查询
        return MyResult.getListResultMap(0, "success", count, bookInfos);
    }

    // 添加图书信息
    @PostMapping(value = "/addBookInfo")
    public Integer addBookInfo(@RequestBody BookInfo bookInfo){
        return bookInfoService.addBookInfo(bookInfo);
    }

    // 删除图书信息
    @DeleteMapping(value = "/deleteBookInfo")
    public Integer deleteBookInfo(@RequestBody BookInfo bookInfo){
        return bookInfoService.deleteBookInfo(bookInfo);
    }

    // 删除一些图书信息
    @DeleteMapping(value = "/deleteBookInfos")
    public Integer deleteBookInfos(@RequestBody List<BookInfo> bookInfos){
        return bookInfoService.deleteBookInfos(bookInfos);
    }

    // 更新图书信息
    @PutMapping(value = "/updateBookInfo")
    public Integer updateBookInfo(@RequestBody BookInfo bookInfo){
        return bookInfoService.updateBookInfo(bookInfo);
    }
}

<select id="selectBySearch" resultMap="BaseResultMap">
  select bookId, bookName, bookAuthor, bookPrice, bookTypeId, bookDesc, isBorrowed, bookImg,
         (select bookTypeName from book_type where book_type.bookTypeId = book_info.bookTypeId) as bookTypeName
  from book_info
  <where>
    <if test="bookname != null and bookname != '' ">
      and bookName like concat('%',#{bookname},'%')
    </if>
    <if test="bookauthor != null and bookauthor != '' ">
      and bookAuthor like concat('%',#{bookauthor},'%')
    </if>
    <if test="booktypeid != null and booktypeid != '' ">
      and bookTypeId = #{booktypeid}
    </if>
  </where>
  limit #{begin}, #{size}
</select>

// 借书
@RequestMapping(value = {"/borrowBook", "/reader/borrowBook"})
@Transactional
public Integer borrowBook(Integer userid, Integer bookid){
    try{
        // 查询该书的情况
        BookInfo theBook = bookInfoService.queryBookInfoById(bookid);

        if(theBook == null) {  // 图书不存在
            throw new NullPointerException("图书" + bookid + "不存在");
        } else if(theBook.getIsborrowed() == 1) {  // 已经被借
            throw new NotEnoughException("图书" + bookid + "库存不足（已经被借走）");
        }

        // 更新图书表的isBorrowed
        BookInfo bookInfo = new BookInfo();
        bookInfo.setBookid(bookid);
        bookInfo.setIsborrowed((byte) 1);
        Integer res2 = bookInfoService.updateBookInfo(bookInfo);
        if(res2 == 0) throw new OperationFailureException("图书" + bookid + "更新被借信息失败");

        // 添加一条记录到borrow表
        Borrow borrow = new Borrow();
        borrow.setUserid(userid);
        borrow.setBookid(bookid);
        borrow.setBorrowtime(new Date(System.currentTimeMillis()));
        Integer res1 = borrowService.addBorrow2(borrow);
        if(res1 == 0) throw new OperationFailureException("图书" + bookid + "添加借阅记录失败");

    } catch (Exception e) {
        System.out.println("发生异常，进行手动回滚");
        TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
        e.printStackTrace();
        return 0;
    }
    return 1;
}

// 登录
@RequestMapping(value = "/login")
public Map<String, Object> login(@RequestBody User user) {
    // 登录
    User userObj = userService.login(user);
    if(userObj == null) {   // 账号或密码错误
        // 返回结果对象
        return MyResult.getResultMap(420, "账号或密码错误");
    } else {    // 账号密码正确
        // 创建token
        String token = TokenProcessor.getInstance().makeToken();
        // 保存到Redis
        userService.saveUser(token, userObj);
        // 返回结果对象
        return MyResult.getResultMap(200, "登录成功",
                new HashMap<String, String>(){{ put("token", token); }});
    }
}

public String makeToken() {
    String token = (System.currentTimeMillis() + new Random().nextInt(999999999)) + "";
    try {
        MessageDigest md = MessageDigest.getInstance("md5");
        byte md5[] = md.digest(token.getBytes());
        BASE64Encoder encoder = new BASE64Encoder();
        return encoder.encode(md5);
    } catch (NoSuchAlgorithmException e) {
        e.printStackTrace();
    }
    return null;
}

// 查看用户信息
@RequestMapping(value = "/info")
public Map<String, Object> info(String token) {
    // 从redis中取用户
    User user = userService.getUser(token);
    if(user == null) {  // 获取失败
        return MyResult.getResultMap(420, "获取用户信息失败");
    } else {    // 获取成功
        return MyResult.getResultMap(200, "获取用户信息成功", user);
    }
}

@RequestMapping("/updateImg")
@ResponseBody
public Map<String,Object> updateImg(HttpServletRequest req){
    String resPath = myUpdate(req, "pictures");

    Map<String,Object> res = new HashMap<>();
    res.put("code",0);
    res.put("data", resPath);

    return res;
}

server.port=8092
server.servlet.context-path=/BookManager

spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/book_manager?useAffectedRows=true
spring.datasource.username=你的数据库账号
spring.datasource.password=你的数据库密码

spring.redis.host=你的Redis地址
spring.redis.port=6379
spring.redis.password=你的Redis密码