基于javaweb+mysql的springboot图书馆借阅管理系统(java+springboot+bootstrap+html+maven+mysql)

基于javaweb+mysql的springboot图书馆借阅管理系统(java+springboot+bootstrap+html+maven+mysql)

运行环境

Java≥8、MySQL≥5.7

开发工具

eclipse/idea/myeclipse/sts等均可配置运行

适用

课程设计，大作业，毕业设计，项目练习，学习演示等

功能说明

基于javaweb+mysql的SpringBoot图书馆借阅管理系统(java+springboot+bootstrap+html+maven+mysql)

项目介绍

本项目分为管理员与学生两种角色， 管理员角色包含以下功能： 登录,图书查询,加入购物车,用户管理,添加用户,角色管理,管理权限,图书管理,进行还书等功能。

学生角色包含以下功能： 登录页面,查看图书列表,好看要预定的图书,开始借阅等功能。

环境需要

1.运行环境：最好是java jdk 1.8，我们在这个平台上运行的。其他版本理论上也可以。 2.IDE环境：IDEA，Eclipse,Myeclipse都可以。推荐IDEA; 3.tomcat环境：Tomcat 7.x,8.x,9.x版本均可 4.硬件环境：windows 7/8/10 1G内存以上；或者 Mac OS； 5.数据库：MySql 5.7版本； 6.是否Maven项目：是；

技术栈

1. 后端：SpringBoot 2. 前端：HTML+CSS+JavaScript+jquery+bootstrap

使用说明

1. 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件； 2. 使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyEclipse导入时，若为maven项目请选择maven; 若为maven项目，导入成功后请执行maven clean;maven install命令，然后运行； 3. 将项目中application.properties配置文件中的数据库配置改为自己的配置; 4. 运行项目，输入localhost:8080/ 登录

try {

System.out.println("inputuser:"+user.toString());

userService.saveOrUpdate(user);

} catch (Exception e) {

return JsonResult.failure(e.getMessage());

return JsonResult.success();

@RequestMapping(value = "/delete/{id}", method = RequestMethod.POST)

@ResponseBody

public JsonResult delete(@PathVariable Integer id,ModelMap map) {

try {

userService.delete(id);

User user = userService.find(id);

map.put("user", user);

Set<Role> set = user.getRoles();

List<Integer> roleIds = new ArrayList<Integer>();

for (Role role : set) {

roleIds.add(role.getId());

map.put("roleIds", roleIds);

List<Role> roles = roleService.findAll();

map.put("roles", roles);

return "admin/user/grant";

@ResponseBody

@RequestMapping(value = "/grant/{id}", method = RequestMethod.POST)

if(StringUtils.isNotBlank(bookPress)){

builder.add("bookPress", Operator.likeAll.name(), bookPress);

Page<Book> page = bookService.findAll(builder.generateSpecification(), getPageRequest());

return page;

用户管理控制层：

@Controller

@RequestMapping("/admin/user")

public class UserController extends BaseController {

@Autowired

private IUserService userService;

@Autowired

@ResponseBody

public List<ZtreeView> tree(@PathVariable Integer resourceId){

List<ZtreeView> list = resourceService.tree(resourceId);

return list;

@RequestMapping("/index")

public String index() {

return "admin/resource/index";

@RequestMapping("/list")

@ResponseBody

public Page<Resource> list() {

SimpleSpecificationBuilder<Resource> builder = new SimpleSpecificationBuilder<Resource>();

String searchText = request.getParameter("searchText");

if(StringUtils.isNotBlank(searchText)){

builder.add("name", Operator.likeAll.name(), searchText);

return list;

@RequestMapping("/index")

public String index() {

return "admin/resource/index";

@RequestMapping("/list")

@ResponseBody

public Page<Resource> list() {

SimpleSpecificationBuilder<Resource> builder = new SimpleSpecificationBuilder<Resource>();

String searchText = request.getParameter("searchText");

if(StringUtils.isNotBlank(searchText)){

builder.add("name", Operator.likeAll.name(), searchText);

@ResponseBody

public JsonResult edit( Book book,ModelMap map){

try {

bookService.saveOrUpdate(book);

} catch (Exception e) {

return JsonResult.failure(e.getMessage());

return JsonResult.success();

/**

* index页面中BootStrapTable请求列表响应

* @parameter

* @return Page<Book>

/**

* 借书

* @parameter Json类型的借书表，数据集

* @return JsonResult

*/

@RequestMapping(value = { "/borrowlist/{borrowlist}" },method = RequestMethod.POST)

@ResponseBody

public JsonResult borrowList(@PathVariable String borrowlist,ModelMap map) {

if(!borrowlist.equals("undefine"))

Gson gson=new Gson();

BorrowList mBorrowList=gson.fromJson(borrowlist,BorrowList.class);

BorrowBook[] borrowBook=new BorrowBook[mBorrowList.getBooklist().length];

BorrowBook[] borrowBooks=borrowBookService.findByUserId(Integer.parseInt(id));

Book[] books=new Book[borrowBooks.length];

Date date=null;

for(int i=0;i<books.length;i++)

books[i]=bookService.findByBookId(borrowBooks[i].getBookId());

Map<String,Object> resultMap=new HashMap();

resultMap.put("borrowBooks", borrowBooks);

resultMap.put("books", books);

Gson gson=new Gson();

String jsonStr = gson.toJson(resultMap);

return jsonStr;

/**

//一本书只能借一次，因此需要判断一下该用户是否已经借过该书

BorrowBook isBorrowBook=borrowBookService.findByUserIdAndBookId(mBorrowList.getId(), mBorrowList.getBooklist()[i]);

if(book[i].getCurrentInventory()>0)

if(isBorrowBook==null)

book[i].setCurrentInventory(book[i].getCurrentInventory()-1);

bookService.saveOrUpdate(book[i]);

borrowBookService.save(borrowBook[i]);

}else

return JsonResult.failure("您已经借阅该书！");

}else

return JsonResult.failure("库存不足请重新选择图书！");

i++;

i=0;

@RequestMapping(value= {"/edit"}, method = RequestMethod.POST)

@ResponseBody

public JsonResult edit(Resource resource,ModelMap map){

try {

resourceService.saveOrUpdate(resource);

} catch (Exception e) {

return JsonResult.failure(e.getMessage());

return JsonResult.success();

@RequestMapping(value = "/delete/{id}", method = RequestMethod.POST)

@ResponseBody

public JsonResult delete(@PathVariable Integer id,ModelMap map) {

try {

@Autowired

private IBorrowBookService borrowBookService;

/**

* 默认索引页

* @parameter 参数及其意义

* @return index页面

*/

@RequestMapping("/index")

public String index() {

return "/admin/books/index";

/**

* 添加图书

* @parameter

borrowBook[i].setBookId(mBorrowList.getBooklist()[i]);

book[i]=bookService.findByBookId(mBorrowList.getBooklist()[i]);

//一本书只能借一次，因此需要判断一下该用户是否已经借过该书

BorrowBook isBorrowBook=borrowBookService.findByUserIdAndBookId(mBorrowList.getId(), mBorrowList.getBooklist()[i]);

if(book[i].getCurrentInventory()>0)

if(isBorrowBook==null)

book[i].setCurrentInventory(book[i].getCurrentInventory()-1);

bookService.saveOrUpdate(book[i]);

borrowBookService.save(borrowBook[i]);

}else

return JsonResult.failure("您已经借阅该书！");

}else

return JsonResult.failure("库存不足请重新选择图书！");

* @return JsonResult

*/

@RequestMapping(value = {"/returnBook/{borrowlist}"}, method = RequestMethod.POST)

@ResponseBody

public JsonResult returnBook(@PathVariable String borrowlist) {

Gson gson=new Gson();

BorrowList mBorrowList=gson.fromJson(borrowlist,BorrowList.class);

BorrowBook[] borrowBook=new BorrowBook[mBorrowList.getBooklist().length];

Book[] book=new Book[mBorrowList.getBooklist().length];

int i=0;

while(i<mBorrowList.getBooklist().length)

public String edit(@PathVariable Integer id,ModelMap map) {

User user = userService.find(id);

map.put("user", user);

return "admin/user/form";

@RequestMapping(value= {"/edit"} ,method = RequestMethod.POST)

@ResponseBody

public JsonResult edit(User user,ModelMap map){

try {

System.out.println("inputuser:"+user.toString());

userService.saveOrUpdate(user);

} catch (Exception e) {

return JsonResult.failure(e.getMessage());

return JsonResult.success();

图书管理类控制层：

/**

* 图书管理类

*/

@Controller

@RequestMapping("/web/books")

public class BookController extends BaseController{

@Autowired

private IBookService bookService;

@Autowired

private IBorrowBookService borrowBookService;

/**

if(StringUtils.isNotBlank(bookName)){

builder.add("bookName", Operator.likeAll.name(), bookName);

if(StringUtils.isNotBlank(bookAuthor)){

builder.add("bookAuthor", Operator.likeAll.name(), bookAuthor);

if(StringUtils.isNotBlank(bookPress)){

builder.add("bookPress", Operator.likeAll.name(), bookPress);

Page<Book> page = bookService.findAll(builder.generateSpecification(), getPageRequest());

return page;

用户管理控制层：

@Controller

@RequestMapping("/admin/user")

}else

return JsonResult.failure("库存不足请重新选择图书！");

i++;

i=0;

return JsonResult.success();

}else

return JsonResult.failure("未选择要借阅的书籍！");

/**

* 还书表

* @parameter 借书用户id