基于javaweb的图书馆图书管理系统(java+ssm+jsp+js+html+mysql)

基于javaweb的图书馆图书管理系统(java+ssm+jsp+js+html+mysql)

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

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

适用

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

功能说明

基于javaweb+mysql的图书馆图书管理系统(java+SSM+JSP+JS+HTML+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版本；

技术栈

1. 后端：Spring+SpringMVC+Mybatis 2. 前端：HTML+CSS+JavaScript+jsp

使用说明

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

读者管理控制层：

@Controller

public class ReaderController {

@Autowired

private ReaderInfoService readerInfoService;

@Autowired

private LoginService loginService;

@Autowired

private ReaderCardService readerCardService;

private ReaderInfo getReaderInfo(long readerId, String name, String sex, String birth, String address, String phone) {

ReaderInfo readerInfo = new ReaderInfo();

Date date = new Date();

try {

SimpleDateFormat df = new SimpleDateFormat(“yyyy-MM-dd”);

date = df.parse(birth);

} catch (ParseException e) {

e.printStackTrace();

readerInfo.setAddress(address);

readerInfo.setName(name);

readerInfo.setReaderId(readerId);

readerInfo.setPhone(phone);

readerInfo.setSex(sex);

readerInfo.setBirth(date);

return readerInfo;

@RequestMapping(“allreaders.html”)

public ModelAndView allBooks() {

ArrayList readers = readerInfoService.readerInfos();

ModelAndView modelAndView = new ModelAndView(“admin_readers”);

modelAndView.addObject(“readers”, readers);

return modelAndView;

@RequestMapping(“reader_delete.html”)

public String readerDelete(HttpServletRequest request, RedirectAttributes redirectAttributes) {

long readerId = Long.parseLong(request.getParameter(“readerId”));

if (readerInfoService.deleteReaderInfo(readerId) && readerCardService.deleteReaderCard(readerId)) {

redirectAttributes.addFlashAttribute(“succ”, “删除成功！”);

} else {

redirectAttributes.addFlashAttribute(“error”, “删除失败！”);

return “redirect:/allreaders.html”;

@RequestMapping(“/reader_info.html”)

public ModelAndView toReaderInfo(HttpServletRequest request) {

ReaderCard readerCard = (ReaderCard) request.getSession().getAttribute(“readercard”);

ReaderInfo readerInfo = readerInfoService.getReaderInfo(readerCard.getReaderId());

ModelAndView modelAndView = new ModelAndView(“reader_info”);

modelAndView.addObject(“readerinfo”, readerInfo);

return modelAndView;

@RequestMapping(“reader_edit.html”)

public ModelAndView readerInfoEdit(HttpServletRequest request) {

long readerId = Long.parseLong(request.getParameter(“readerId”));

ReaderInfo readerInfo = readerInfoService.getReaderInfo(readerId);

ModelAndView modelAndView = new ModelAndView(“admin_reader_edit”);

modelAndView.addObject(“readerInfo”, readerInfo);

return modelAndView;

@RequestMapping(“reader_edit_do.html”)

public String readerInfoEditDo(HttpServletRequest request, String name, String sex, String birth, String address, String phone, RedirectAttributes redirectAttributes) {

long readerId = Long.parseLong(request.getParameter(“readerId”));

ReaderInfo readerInfo = getReaderInfo(readerId, name, sex, birth, address, phone);

if (readerInfoService.editReaderInfo(readerInfo) && readerInfoService.editReaderCard(readerInfo)) {

redirectAttributes.addFlashAttribute(“succ”, “读者信息修改成功！”);

} else {

redirectAttributes.addFlashAttribute(“error”, “读者信息修改失败！”);

return “redirect:/allreaders.html”;

@RequestMapping(“reader_add.html”)

public ModelAndView readerInfoAdd() {

return new ModelAndView(“admin_reader_add”);

@RequestMapping(“reader_add_do.html”)

public String readerInfoAddDo(String name, String sex, String birth, String address, String phone, String password, RedirectAttributes redirectAttributes) {

ReaderInfo readerInfo = getReaderInfo(0, name, sex, birth, address, phone);

long readerId = readerInfoService.addReaderInfo(readerInfo);

readerInfo.setReaderId(readerId);

if (readerId > 0 && readerCardService.addReaderCard(readerInfo, password)) {

redirectAttributes.addFlashAttribute(“succ”, “添加读者信息成功！”);

} else {

redirectAttributes.addFlashAttribute(“succ”, “添加读者信息失败！”);

return “redirect:/allreaders.html”;

@RequestMapping(“reader_info_edit.html”)

public ModelAndView readerInfoEditReader(HttpServletRequest request) {

ReaderCard readerCard = (ReaderCard) request.getSession().getAttribute(“readercard”);

ReaderInfo readerInfo = readerInfoService.getReaderInfo(readerCard.getReaderId());

ModelAndView modelAndView = new ModelAndView(“reader_info_edit”);

modelAndView.addObject(“readerinfo”, readerInfo);

return modelAndView;

@RequestMapping(“reader_edit_do_r.html”)

public String readerInfoEditDoReader(HttpServletRequest request, String name, String sex, String birth, String address, String phone, RedirectAttributes redirectAttributes) {

ReaderCard readerCard = (ReaderCard) request.getSession().getAttribute(“readercard”);

ReaderInfo readerInfo = getReaderInfo(readerCard.getReaderId(), name, sex, birth, address, phone);

if (readerInfoService.editReaderInfo(readerInfo) && readerInfoService.editReaderCard(readerInfo)) {

ReaderCard readerCardNew = loginService.findReaderCardByReaderId(readerCard.getReaderId());

request.getSession().setAttribute(“readercard”, readerCardNew);

redirectAttributes.addFlashAttribute(“succ”, “信息修改成功！”);

} else {

redirectAttributes.addFlashAttribute(“error”, “信息修改失败！”);

return “redirect:/reader_info.html”;

图书管理控制层：

@Controller

public class BookController {

@Autowired

private BookService bookService;

@Autowired

private LendService lendService;

private Date getDate(String pubstr) {

try {

SimpleDateFormat df = new SimpleDateFormat(“yyyy-MM-dd”);

return df.parse(pubstr);

} catch (ParseException e) {

e.printStackTrace();

return new Date();

@RequestMapping(“/queryBook.html”)

public ModelAndView queryBookDo(String searchWord) {

if (bookService.matchBook(searchWord)) {

ArrayList books = bookService.queryBook(searchWord);

ModelAndView modelAndView = new ModelAndView(“admin_books”);

modelAndView.addObject(“books”, books);

return modelAndView;

} else {

return new ModelAndView(“admin_books”, “error”, “没有匹配的图书”);

@RequestMapping(“/reader_querybook_do.html”)

public ModelAndView readerQueryBookDo(String searchWord) {

if (bookService.matchBook(searchWord)) {

ArrayList books = bookService.queryBook(searchWord);

ModelAndView modelAndView = new ModelAndView(“reader_books”);

modelAndView.addObject(“books”, books);

return modelAndView;

} else {

return new ModelAndView(“reader_books”, “error”, “没有匹配的图书”);

@RequestMapping(“/admin_books.html”)

public ModelAndView adminBooks() {

ArrayList books = bookService.getAllBooks();

ModelAndView modelAndView = new ModelAndView(“admin_books”);

modelAndView.addObject(“books”, books);

return modelAndView;

@RequestMapping(“/book_add.html”)

public ModelAndView addBook() {

return new ModelAndView(“admin_book_add”);

@RequestMapping(“/book_add_do.html”)

public String addBookDo(@RequestParam(value = “pubstr”) String pubstr, Book book, RedirectAttributes redirectAttributes) {

book.setPubdate(getDate(pubstr));

if (bookService.addBook(book)) {

redirectAttributes.addFlashAttribute(“succ”, “图书添加成功！”);

} else {

redirectAttributes.addFlashAttribute(“succ”, “图书添加失败！”);

return “redirect:/admin_books.html”;

@RequestMapping(“/updatebook.html”)

public ModelAndView bookEdit(HttpServletRequest request) {

long bookId = Long.parseLong(request.getParameter(“bookId”));

Book book = bookService.getBook(bookId);

ModelAndView modelAndView = new ModelAndView(“admin_book_edit”);

modelAndView.addObject(“detail”, book);

return modelAndView;

@RequestMapping(“/book_edit_do.html”)

public String bookEditDo(@RequestParam(value = “pubstr”) String pubstr, Book book, RedirectAttributes redirectAttributes) {

book.setPubdate(getDate(pubstr));

if (bookService.editBook(book)) {

redirectAttributes.addFlashAttribute(“succ”, “图书修改成功！”);

} else {

redirectAttributes.addFlashAttribute(“error”, “图书修改失败！”);

return “redirect:/admin_books.html”;

@RequestMapping(“/admin_book_detail.html”)

public ModelAndView adminBookDetail(HttpServletRequest request) {

long bookId = Long.parseLong(request.getParameter(“bookId”));

Book book = bookService.getBook(bookId);

ModelAndView modelAndView = new ModelAndView(“admin_book_detail”);

modelAndView.addObject(“detail”, book);

return modelAndView;

@RequestMapping(“/reader_book_detail.html”)

public ModelAndView readerBookDetail(HttpServletRequest request) {

long bookId = Long.parseLong(request.getParameter(“bookId”));

Book book = bookService.getBook(bookId);

ModelAndView modelAndView = new ModelAndView(“reader_book_detail”);

modelAndView.addObject(“detail”, book);

return modelAndView;

@RequestMapping(“/admin_header.html”)

public ModelAndView admin_header() {

return new ModelAndView(“admin_header”);

@RequestMapping(“/reader_header.html”)

public ModelAndView reader_header() {

return new ModelAndView(“reader_header”);

@RequestMapping(“/reader_books.html”)

public ModelAndView readerBooks(HttpServletRequest request) {

ArrayList books = bookService.getAllBooks();

ReaderCard readerCard = (ReaderCard) request.getSession().getAttribute(“readercard”);

ArrayList myAllLendList = lendService.myLendList(readerCard.getReaderId());

ArrayList myLendList = new ArrayList<>();

for (Lend lend : myAllLendList) {

// 是否已归还

if (lend.getBackDate() == null) {

myLendList.add(lend.getBookId());

ModelAndView modelAndView = new ModelAndView(“reader_books”);

modelAndView.addObject(“books”, books);

modelAndView.addObject(“myLendList”, myLendList);

return modelAndView;

借阅管理控制层：

@Controller

public class LendController {

@Autowired

private LendService lendService;

@Autowired

private BookService bookService;

@RequestMapping(“/deletebook.html”)

public String deleteBook(HttpServletRequest request, RedirectAttributes redirectAttributes) {

long bookId = Long.parseLong(request.getParameter(“bookId”));

if (bookService.deleteBook(bookId)) {

redirectAttributes.addFlashAttribute(“succ”, “图书删除成功！”);

} else {

redirectAttributes.addFlashAttribute(“error”, “图书删除失败！”);

return “redirect:/admin_books.html”;

@RequestMapping(“/lendlist.html”)

public ModelAndView lendList(HttpServletRequest request) {

ModelAndView modelAndView = new ModelAndView(“admin_lend_list”);

modelAndView.addObject(“list”, lendService.lendList());

return modelAndView;

@RequestMapping(“/mylend.html”)

public ModelAndView myLend(HttpServletRequest request) {

ReaderCard readerCard = (ReaderCard) request.getSession().getAttribute(“readercard”);

ModelAndView modelAndView = new ModelAndView(“reader_lend_list”);

modelAndView.addObject(“list”, lendService.myLendList(readerCard.getReaderId()));

return modelAndView;

@RequestMapping(“/deletelend.html”)

public String deleteLend(HttpServletRequest request, RedirectAttributes redirectAttributes) {

long serNum = Long.parseLong(request.getParameter(“serNum”));

if (lendService.deleteLend(serNum) > 0) {

redirectAttributes.addFlashAttribute(“succ”, “记录删除成功！”);

} else {

redirectAttributes.addFlashAttribute(“error”, “记录删除失败！”);

return “redirect:/lendlist.html”;

@RequestMapping(“/lendbook.html”)

public String bookLend(HttpServletRequest request, RedirectAttributes redirectAttributes) {

long bookId = Long.parseLong(request.getParameter(“bookId”));

long readerId = ((ReaderCard) request.getSession().getAttribute(“readercard”)).getReaderId();

if (lendService.lendBook(bookId, readerId)) {

redirectAttributes.addFlashAttribute(“succ”, “图书借阅成功！”);

} else {

redirectAttributes.addFlashAttribute(“succ”, “图书借阅成功！”);

return “redirect:/reader_books.html”;

@RequestMapping(“/returnbook.html”)

public String bookReturn(HttpServletRequest request, RedirectAttributes redirectAttributes) {

long bookId = Long.parseLong(request.getParameter(“bookId”));

long readerId = ((ReaderCard) request.getSession().getAttribute(“readercard”)).getReaderId();

if (lendService.returnBook(bookId, readerId)) {

redirectAttributes.addFlashAttribute(“succ”, “图书归还成功！”);

} else {

redirectAttributes.addFlashAttribute(“error”, “图书归还失败！”);

return “redirect:/reader_books.html”;

---