基于javaweb的图书馆借阅管理系统(java+springboot+bootstrap+html+mysql)
运行环境
Java≥8、MySQL≥5.7
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计，大作业，毕业设计，项目练习，学习演示等
功能说明
基于javaweb+mysql的图书馆借阅管理系统(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项目：是；
技术栈
- 后端：SpringBoot 2. 前端：HTML+CSS+JavaScript+jquery+bootstrap
使用说明
- 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件； 2. 使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyEclipse导入时，若为maven项目请选择maven; 若为maven项目，导入成功后请执行maven clean;maven install命令，然后运行； 3. 将项目中application.properties配置文件中的数据库配置改为自己的配置; 4. 运行项目，输入localhost:8080/ 登录
图书管理类控制层：
@Controller
@RequestMapping(“/web/books”)
public class BookController extends BaseController{
@Autowired
private IBookService bookService;
@Autowired
private IBorrowBookService borrowBookService;
@RequestMapping(“/index”)
public String index() {
return “/admin/books/index”;
@RequestMapping(value = {“/addBook”}, method = RequestMethod.GET)
public String addBook() {
return “admin/books/addform”;
@RequestMapping(value = “/delete/{id}”, method = RequestMethod.POST)
@ResponseBody
public JsonResult delete(@PathVariable String id,ModelMap map) {
try {
bookService.delete(id);
} catch (Exception e) {
e.printStackTrace();
return JsonResult.failure(e.getMessage());
return JsonResult.success();
@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];
Book[] book=new Book[mBorrowList.getBooklist().length];
int i=0;
while(i<mBorrowList.getBooklist().length)
borrowBook[i]=new BorrowBook();
book[i]=new Book();
borrowBook[i].setUserId(mBorrowList.getId());
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(“库存不足请重新选择图书！”);
i++;
i=0;
return JsonResult.success();
}else
return JsonResult.failure(“未选择要借阅的书籍！”);
@RequestMapping(value = { “/returnBookList/{id}” },method = RequestMethod.POST)
@ResponseBody
public String ReturnBookList(@PathVariable String id,ModelMap map) {
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;
@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)
borrowBook[i]=new BorrowBook();
book[i]=new Book();
borrowBook[i].setUserId(mBorrowList.getId());
borrowBook[i].setBookId(mBorrowList.getBooklist()[i]);
book[i]=bookService.findByBookId(mBorrowList.getBooklist()[i]);
book[i].setCurrentInventory(book[i].getCurrentInventory()+1);
bookService.saveOrUpdate(book[i]);
borrowBookService.deletByUserIdAndBookId(borrowBook[i].getUserId(), borrowBook[i].getBookId());;
i++;
i=0;
return JsonResult.success();
@RequestMapping(value = “/edit/{id}”, method = RequestMethod.GET)
public String edit(@PathVariable String id,ModelMap map) {
Book book = bookService.findByBookId(id);
map.put(“book”, book);
return “admin/books/addform”;
@RequestMapping(value= {“/edit”} ,method = RequestMethod.POST)
@ResponseBody
public JsonResult edit( Book book,ModelMap map){
try {
bookService.saveOrUpdate(book);
} catch (Exception e) {
return JsonResult.failure(e.getMessage());
return JsonResult.success();
@RequestMapping(value = { “/list” })
@ResponseBody
public Page list() {
SimpleSpecificationBuilder builder = new SimpleSpecificationBuilder();
String searchText = request.getParameter(“searchText”);
if(StringUtils.isNotBlank(searchText)){
builder.add(“bookName”, Operator.likeAll.name(), searchText);
Page page = bookService.findAll(builder.generateSpecification(), getPageRequest());
return page;
@RequestMapping(value = { “/findlist” })
@ResponseBody
public Page findList() {
SimpleSpecificationBuilder builder = new SimpleSpecificationBuilder();
String bookName = request.getParameter(“inputBookName”);
String bookAuthor = request.getParameter(“inputAuthor”);
String bookPress = request.getParameter(“inputPublication”);
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 page = bookService.findAll(builder.generateSpecification(), getPageRequest());
return page;
用户管理控制层：
@Controller
@RequestMapping(“/admin/user”)
public class UserController extends BaseController {
@Autowired
private IUserService userService;
@Autowired
private IRoleService roleService;
@RequestMapping(value = { “/”, “/index” })
public String index() {
return “admin/user/index”;
@RequestMapping(value = { “/list” })
@ResponseBody
public Page list() {
SimpleSpecificationBuilder builder = new SimpleSpecificationBuilder();
String searchText = request.getParameter(“searchText”);
if(StringUtils.isNotBlank(searchText)){
builder.add(“nickName”, Operator.likeAll.name(), searchText);
Page page = userService.findAll(builder.generateSpecification(), getPageRequest());
return page;
@RequestMapping(value = “/add”, method = RequestMethod.GET)
public String add(ModelMap map) {
return “admin/user/form”;
@RequestMapping(value = “/edit/{id}”, method = RequestMethod.GET)
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();
@RequestMapping(value = “/delete/{id}”, method = RequestMethod.POST)
@ResponseBody
public JsonResult delete(@PathVariable Integer id,ModelMap map) {
try {
userService.delete(id);
} catch (Exception e) {
e.printStackTrace();
return JsonResult.failure(e.getMessage());
return JsonResult.success();
@RequestMapping(value = “/grant/{id}”, method = RequestMethod.GET)
public String grant(@PathVariable Integer id, ModelMap map) {
User user = userService.find(id);
map.put(“user”, user);
Set set = user.getRoles();
List roleIds = new ArrayList();
for (Role role : set) {
roleIds.add(role.getId());
map.put(“roleIds”, roleIds);
List roles = roleService.findAll();
map.put(“roles”, roles);
return “admin/user/grant”;
@ResponseBody
@RequestMapping(value = “/grant/{id}”, method = RequestMethod.POST)
public JsonResult grant(@PathVariable Integer id,String[] roleIds, ModelMap map) {
try {
userService.grant(id,roleIds);
} catch (Exception e) {
e.printStackTrace();
return JsonResult.failure(e.getMessage());
return JsonResult.success();
资源管理控制层：
@Controller
@RequestMapping(“/admin/resource”)
public class ResourceController extends BaseController {
@Autowired
private IResourceService resourceService;
@RequestMapping(“/tree/{resourceId}”)
@ResponseBody
public List tree(@PathVariable Integer resourceId){
List list = resourceService.tree(resourceId);
return list;
@RequestMapping(“/index”)
public String index() {
return “admin/resource/index”;
@RequestMapping(“/list”)
@ResponseBody
public Page list() {
SimpleSpecificationBuilder builder = new SimpleSpecificationBuilder();
String searchText = request.getParameter(“searchText”);
if(StringUtils.isNotBlank(searchText)){
builder.add(“name”, Operator.likeAll.name(), searchText);
Page page = resourceService.findAll(builder.generateSpecification(),getPageRequest());
return page;
@RequestMapping(value = “/add”, method = RequestMethod.GET)
public String add(ModelMap map) {
List list = resourceService.findAll();
map.put(“list”, list);
return “admin/resource/form”;
@RequestMapping(value = “/edit/{id}”, method = RequestMethod.GET)
public String edit(@PathVariable Integer id,ModelMap map) {
Resource resource = resourceService.find(id);
map.put(“resource”, resource);
List list = resourceService.findAll();
map.put(“list”, list);
return “admin/resource/form”;
@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 {
resourceService.delete(id);
} catch (Exception e) {
e.printStackTrace();
return JsonResult.failure(e.getMessage());
return JsonResult.success();