基于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(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) {
@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);
Page<Resource> page = resourceService.findAll(builder.generateSpecification(),getPageRequest());
@ResponseBody
public Page<Book> list() {
SimpleSpecificationBuilder<Book> builder = new SimpleSpecificationBuilder<Book>();
String searchText = request.getParameter("searchText");
if(StringUtils.isNotBlank(searchText)){
builder.add("bookName", Operator.likeAll.name(), searchText);
Page<Book> page = bookService.findAll(builder.generateSpecification(), getPageRequest());
return page;
/**
* 查询图书
* @parameter
* @return Page<Book>
*/
* 图书管理类
*/
@Controller
@RequestMapping("/web/books")
public class BookController extends BaseController{
@Autowired
private IBookService bookService;
@Autowired
private IBorrowBookService borrowBookService;
/**
* 默认索引页
* @parameter 参数及其意义
* 还书表
* @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));
Book[] books=new Book[borrowBooks.length];
Date date=null;
for(int i=0;i<books.length;i++)
books[i]=bookService.findByBookId(borrowBooks[i].getBookId());
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");
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;
return JsonResult.success();
/**
* index页面中BootStrapTable请求列表响应
* @parameter
* @return Page<Book>
*/
@RequestMapping(value = { "/list" })
@ResponseBody
public Page<Book> list() {
SimpleSpecificationBuilder<Book> builder = new SimpleSpecificationBuilder<Book>();
String searchText = request.getParameter("searchText");
if(StringUtils.isNotBlank(searchText)){
builder.add("bookName", Operator.likeAll.name(), searchText);
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("未选择要借阅的书籍!");
/**
* 还书表
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<User> list() {
SimpleSpecificationBuilder<User> builder = new SimpleSpecificationBuilder<User>();
* index页面中BootStrapTable请求列表响应
* @parameter
* @return Page<Book>
*/
@RequestMapping(value = { "/list" })
@ResponseBody
public Page<Book> list() {
SimpleSpecificationBuilder<Book> builder = new SimpleSpecificationBuilder<Book>();
String searchText = request.getParameter("searchText");
if(StringUtils.isNotBlank(searchText)){
builder.add("bookName", Operator.likeAll.name(), searchText);
Page<Book> page = bookService.findAll(builder.generateSpecification(), getPageRequest());
return page;
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();
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++;
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)
@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/{id}", method = RequestMethod.GET)
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/{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 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());
* @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];