基于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项目:是;
技术栈
- 后端: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/ 登录
@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);
Page<Resource> page = resourceService.findAll(builder.generateSpecification(),getPageRequest());
return page;
@RequestMapping(value = "/add", method = RequestMethod.GET)
public String add(ModelMap map) {
List<Resource> list = resourceService.findAll();
map.put("list", list);
i=0;
return JsonResult.success();
}else
return JsonResult.failure("未选择要借阅的书籍!");
/**
* 还书表
* @parameter 借书用户id
* @return String 借书表信息和书籍信息
*/
@RequestMapping(value = { "/returnBookList/{id}" },method = RequestMethod.POST)
@ResponseBody
public String ReturnBookList(@PathVariable String id,ModelMap map) {
BorrowBook[] borrowBooks=borrowBookService.findByUserId(Integer.parseInt(id));
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);
Page<Resource> page = resourceService.findAll(builder.generateSpecification(),getPageRequest());
return page;
@RequestMapping(value = "/add", method = RequestMethod.GET)
public String add(ModelMap map) {
@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
Book book = bookService.findByBookId(id);
map.put("book", book);
return "admin/books/addform";
/**
* 修改图书
* @parameter 图书实体,数据集
* @return JsonResult 是否修改成功
*/
@RequestMapping(value= {"/edit"} ,method = RequestMethod.POST)
@ResponseBody
public JsonResult edit( Book book,ModelMap map){
try {
return JsonResult.success();
资源管理控制层:
@Controller
@RequestMapping("/admin/resource")
public class ResourceController extends BaseController {
@Autowired
private IResourceService resourceService;
@RequestMapping("/tree/{resourceId}")
@ResponseBody
public List<ZtreeView> tree(@PathVariable Integer resourceId){
List<ZtreeView> list = resourceService.tree(resourceId);
return list;
@RequestMapping("/index")
public String index() {
return "/admin/books/index";
/**
* 添加图书
* @parameter
* @return addform页面
*/
@RequestMapping(value = {"/addBook"}, method = RequestMethod.GET)
public String addBook() {
return "admin/books/addform";
/**
* 删除图书
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());
public String edit(@PathVariable Integer id,ModelMap map) {
Resource resource = resourceService.find(id);
map.put("resource", resource);
List<Resource> 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();
@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)){
return "admin/user/index";
@RequestMapping(value = { "/list" })
@ResponseBody
public Page<User> list() {
SimpleSpecificationBuilder<User> builder = new SimpleSpecificationBuilder<User>();
String searchText = request.getParameter("searchText");
if(StringUtils.isNotBlank(searchText)){
builder.add("nickName", Operator.likeAll.name(), searchText);
Page<User> 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"} ,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();
/**
* index页面中BootStrapTable请求列表响应
* @parameter
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 page;
/**
* 查询图书
* @parameter
* @return Page<Book>
*/
@RequestMapping(value = { "/findlist" })
@ResponseBody
public Page<Book> findList() {
SimpleSpecificationBuilder<Book> builder = new SimpleSpecificationBuilder<Book>();
String bookName = request.getParameter("inputBookName");
String bookAuthor = request.getParameter("inputAuthor");
try {
bookService.delete(id);
} catch (Exception e) {
e.printStackTrace();
return JsonResult.failure(e.getMessage());
return JsonResult.success();
/**
* 借书
* @parameter Json类型的借书表,数据集
* @return JsonResult
*/
@RequestMapping(value = { "/borrowlist/{borrowlist}" },method = RequestMethod.POST)
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);
Page<Resource> page = resourceService.findAll(builder.generateSpecification(),getPageRequest());
return page;
return page;
/**
* 查询图书
* @parameter
* @return Page<Book>
*/
@RequestMapping(value = { "/findlist" })
@ResponseBody
public Page<Book> findList() {
SimpleSpecificationBuilder<Book> builder = new SimpleSpecificationBuilder<Book>();
String bookName = request.getParameter("inputBookName");
String bookAuthor = request.getParameter("inputAuthor");
String bookPress = request.getParameter("inputPublication");