基于SpringBoot+Vue的图书管理系统.zip

package com.wangpeng.bms.web; import com.wangpeng.bms.exception.NotEnoughException; import com.wangpeng.bms.exception.OperationFailureException; import com.wangpeng.bms.model.BookInfo; import com.wangpeng.bms.model.Borrow; import com.wangpeng.bms.service.BookInfoService; import com.wangpeng.bms.service.BorrowService; import com.wangpeng.bms.utils.MyResult; import com.wangpeng.bms.utils.MyUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.transaction.annotation.Transactional; import org.springframework.transaction.interceptor.TransactionAspectSupport; import org.springframework.web.bind.annotation.RequestBody; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestParam; import org.springframework.web.bind.annotation.RestController; import java.util.Date; import java.util.List; import java.util.Map; @RestController @RequestMapping(value = "/borrow") public class BorrowController { @Autowired BorrowService borrowService; @Autowired BookInfoService bookInfoService; // 分页查询借阅 params: {page, limit, userid, bookid} @RequestMapping(value = "/queryBorrowsByPage") public Map<String, Object> queryBorrowsByPage(@RequestParam Map<String, Object> params){ MyUtils.parsePageParams(params); int count = borrowService.getSearchCount(params); List<Borrow> borrows = borrowService.searchBorrowsByPage(params); return MyResult.getListResultMap(0, "success", count, borrows); } // 添加借阅 @RequestMapping(value = "/addBorrow") public Integer addBorrow(@RequestBody Borrow borrow){ return borrowService.addBorrow(borrow); } // 获得数量 @RequestMapping(value = "/getCount") public Integer getCount(){ return borrowService.getCount(); } // 删除借阅 @RequestMapping(value = "/deleteBorrow") public Integer deleteBorrow(@RequestBody Borrow borrow){ return borrowService.deleteBorrow(borrow); } // 删除一些借阅 @RequestMapping(value = "/deleteBorrows") public Integer deleteBorrows(@RequestBody List<Borrow> borrows){ return borrowService.deleteBorrows(borrows); } // 更新借阅 @RequestMapping(value = "/updateBorrow") public Integer updateBorrow(@RequestBody Borrow borrow){ return borrowService.updateBorrow(borrow); } // 借书 @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 = {"/returnBook", "/reader/returnBook"}) @Transactional public Integer returnBook(Integer borrowid, Integer bookid){ try { // 查询该书的情况 BookInfo theBook = bookInfoService.queryBookInfoById(bookid); // 查询借书的情况 Borrow theBorrow = borrowService.queryBorrowsById(borrowid); if(theBook == null) { // 图书不存在 throw new NullPointerException("图书" + bookid + "不存在"); } else if(theBorrow == null) { //结束记录不存在 throw new NullPointerException("借书记录" + bookid + "不存在"); } else if(theBorrow.getReturntime() != null) { // 已经还过书 throw new NotEnoughException("图书" + bookid + "已经还过了"); } // 更新图书表的isBorrowed BookInfo bookInfo = new BookInfo(); bookInfo.setBookid(bookid); bookInfo.setIsborrowed((byte) 0); Integer res2 = bookInfoService.updateBookInfo(bookInfo); if(res2 == 0) throw new OperationFailureException("图书" + bookid + "更新被借信息失败"); // 更新Borrow表，更新结束时间 Borrow borrow = new Borrow(); borrow.setBorrowid(borrowid); borrow.setReturntime(new Date(System.currentTimeMillis())); Integer res1 = borrowService.updateBorrow2(borrow); if(res1 == 0) throw new OperationFailureException("图书" + bookid + "更新借阅记录失败"); } catch (Exception e) { System.out.println("发生异常，进行手动回滚"); TransactionAspectSupport.currentTransactionStatus().setRollbackOnly(); e.printStackTrace(); return 0; } return 1; } }