项目介绍
本项目分为管理员与学生两种角色,
管理员角色包含以下功能:
登录,图书查询,加入购物车,用户管理,添加用户,角色管理,管理权限,图书管理,进行还书等功能。
学生角色包含以下功能:
登录页面,查看图书列表,好看要预定的图书,开始借阅等功能。
环境需要
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/ 登录
运行截图
管理员角色
学生角色
代码相关
图书管理控制器
@Controller
@RequestMapping("/web/books")
public class BookController extends BaseController{
@Autowired
private IBookService bookService;
@Autowired
private IBorrowBookService borrowBookService;
/**
* 默认索引页
* @parameter 参数及其意义
* @return index页面
*/
@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";
}
/**
* 删除图书
* @parameter 图书id,数据集
* @return JsonResult 是否成功
*/
@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();
}
/**
* 借书
* @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];
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("未选择要借阅的书籍!");
}
}
/**
* 还书表
* @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());
}
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;
}
/**
* 归还图书
* @parameter Json类型的借书表
* @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)
{
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();
}
/**
* 修改图书响应请求
* @parameter 修改的图书id,数据集
* @return String addform页面
*/
@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";
}
/**
* 修改图书
* @parameter 图书实体,数据集
* @return JsonResult 是否修改成功
*/
@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
* @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;
}
/**
* 查询图书
* @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");
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;
}
}