0、效果展示

1、协同过滤算法的图书借阅管理系统概述

个性化推荐：依据借阅用户的借阅记录，分析用户的喜好，主动向用户推荐可能喜欢的图书

协同过滤是根据用户借阅书籍编号以及对书籍的评分去计算的

很多用户(M)借阅同几本书(N),并且评分比较相近, 如果其他的某个用户借阅了(N)中的某几本书,
那么M用户借阅的其他书籍就可以推荐给这个用户

本系统实现的功能包含:图书分类管理，图书管理查询，图书收藏，借阅管理，续借管理，逾期管理，预约管理，协同过滤推荐图书查询，还书提醒，借阅统计，预约统计，推荐统计

2、协同过滤算法的图书借阅管理系统搭建环境

本文以实现一个线上协同过滤算法的图书借阅管理系统为目标，从环境搭建到编码实现全过程讲述

我们使用javaweb、J2EE来构建协同过滤算法的图书借阅管理系统，环境使用最新版jdk和tomcat，配合mysql数据库

开发工具使用idea（也可以使用eclipse），数据库管理工具使用Navicat Premium

开发框架使用SSH（Struts+Spring+Hibernate）；

没有使用JavaBean Servlet MVC结构或SSM（Spring+SpringMVC+MyBatis），这两个框架我们在别的项目中再介绍开发过程

3、协同过滤算法的图书借阅管理系统数据表结构

表英文名称	表中文名称	字段名称	数据类型	字段说明
t_book		id	int(11)
t_book		author	varchar(255)
t_book		filePath	varchar(255)
t_book		name	varchar(255)
t_book		note	varchar(255)
t_book		price	double
t_book		publishDate	varchar(255)
t_book		publisher	varchar(255)
t_book		sid	varchar(255)
t_book		tags	varchar(255)
t_book		status	varchar(255)
t_book		book_type_id	int(11)
t_book_borrow		id	int(11)
t_book_borrow		days	int(11)
t_book_borrow		endDate	varchar(255)
t_book_borrow		outDeal	varchar(255)
t_book_borrow		realDate	varchar(255)
t_book_borrow		startDate	varchar(255)
t_book_borrow		book_id	int(11)
t_book_borrow		user_id	int(11)
t_book_borrow		score	int(11)
t_book_type		id	int(11)
t_book_type		name	varchar(255)
t_book_user		id	int(11)
t_book_user		book_id	int(11)
t_book_user		user_id	int(11)
t_sysuser		id	int(11)
t_sysuser		userID	int(11)
t_user		id	int(11)
t_user		userID	int(11)
t_user_filter_result		id	int(11)
t_user_filter_result		memberid	int(11)
t_user_filter_result		productids	varchar(255)
t_user_order		id	int(11)
t_user_order		days	int(11)
t_user_order		startDate	varchar(255)
t_user_order		status	varchar(255)
t_user_order		book_id	int(11)
t_user_order		user_id	int(11)
t_userinfo		userID	int(11)
t_userinfo		uname	varchar(20)
t_userinfo		userAddress	varchar(100)
t_userinfo		userBirth	varchar(10)
t_userinfo		userEmail	varchar(50)
t_userinfo		userGender	int(11)
t_userinfo		userName	varchar(20)
t_userinfo		userPassword	varchar(150)
t_userinfo		userPhone	varchar(255)
t_userinfo		checkcode	varchar(255)

?4、后端代码示例

package biz.web.action;import biz.entity.UserOrder;
import biz.entity.main.Book;
import biz.entity.main.BookBorrow;
import biz.entity.main.SimpleUser;
import biz.web.service.impl.BizService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import util.*;import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.LinkedList;
import java.util.List;
import java.util.Map.Entry;
import java.util.Set;@Controller
@RequestMapping("/sys")
public class ABookBorrow extends BaseAction {@Autowiredprivate BizService service;@RequestMapping(value = "/add2BookBorrow.do", method = RequestMethod.GET)public String add2() {return "sys/addBookBorrow";}@RequestMapping(value = "/borrowWarn.do", method = RequestMethod.GET)public String borrowWarn() {String lastdate = DateUtil.addDays(DateUtil.getCurrentTime(), 1);List<BookBorrow> list = service.queryByHQL("from BookBorrow where realDate is null and endDate<=? and user.id=?", lastdate,getSimpleUser().getId());putRequestValue("list", list);return "sys/borrowWarn";}@RequestMapping(value = "/queryBookBorrowMonth.do")public String queryBookBorrowMonth() {String lastdate = DateUtil.addDays(DateUtil.getCurrentTime(), -60);List<BookBorrow> list = service.queryByHQL("from BookBorrow where realDate is null and endDate<=?", lastdate);putRequestValue("list", list);return "sys/queryBookBorrowMonth";}@RequestMapping(value = "/add2BookBack.do", method = RequestMethod.GET)public String add2BookBack() {return "sys/addBookBorrowBack";}@RequestMapping(value = "/add2BookBorrowRE.do", method = RequestMethod.GET)public String add2BookBorrowRE() {return "sys/addBookBorrowRE";}@RequestMapping(value = "/getBookBorrow.do", method = RequestMethod.GET)public String get(int uid) {try {BookBorrow bean = (BookBorrow) service.get(BookBorrow.class, uid);request.setAttribute("modifybean", bean);return "sys/modifyBookBorrow";} catch (Exception e) {e.printStackTrace();MessageUtil.addMessage(request, "获取信息失败.");return ERROR;}}@RequestMapping(value = "/deleteBookBorrow.do")public String delete(String ids) {try {service.delete(BookBorrow.class, ids);MessageUtil.addRelMessage(request, "删除信息成功.", "mainquery");return SUCCESS;} catch (Exception e) {e.printStackTrace();MessageUtil.addMessage(request, "删除信息失败.");return ERROR;}}@RequestMapping(value = "/addBookBorrow.do")public String add(BookBorrow bean) {try {SimpleUser user = service.getSimpleUserById(bean.getUser().getUser().getUname());if (user == null) {MessageUtil.addMessage(request, "用户编号错误.");return ERROR;}Book book = (Book) service.get(Book.class, bean.getBook().getId());if (!book.getStatus().equals("在架")) {MessageUtil.addMessage(request, "图书已借外借了.");return ERROR;}bean.setBook(book);bean.setUser(user);SimpleDateFormat sf = new SimpleDateFormat("yyyy-MM-dd");Date s = sf.parse(bean.getStartDate());String endDate = sf.format(DateUtil.addDays(s, bean.getDays()));bean.setEndDate(endDate);service.addBookBorrow(bean);MessageUtil.addMessage(request, "添加成功.");return SUCCESS;} catch (Exception e) {e.printStackTrace();MessageUtil.addMessage(request, "添加失败.");return ERROR;}}@RequestMapping(value = "/addBookBorrowByUser.do")public String addBookBorrowByUser(UserOrder bean) {try {SimpleUser user = getSimpleUser();List<?> list = service.queryByHQL("from UserOrder where user.id=? and status='失约'", user.getId());if (list.size() >= 3) {MessageUtil.addMessage(request, "你失约已达3次,不能预约");return ERROR;}Book book = (Book) service.get(Book.class, bean.getBook().getId());if (!book.getStatus().equals("在架")) {MessageUtil.addMessage(request, "图书已借外借了.");return ERROR;}UserOrder order = new UserOrder();order.setBook(book);order.setUser(user);order.setDays(30);order.setStartDate(DateUtil.addDays(DateUtil.getCurrentTime(), 3));//			SimpleDateFormat sf = new SimpleDateFormat("yyyy-MM-dd");//			Date s = sf.parse(bean.getStartDate());//			String endDate = sf.format(DateUtil.addDays(s, bean.getDays()));//			bean.setEndDate(endDate);service.addUserOrder(order);MessageUtil.addRelMessage(request, "预约成功.请在3天内到馆取书", "mainquery");return SUCCESS;} catch (Exception e) {e.printStackTrace();MessageUtil.addMessage(request, "预约失败.");return ERROR;}}@RequestMapping(value = "/addBookBorrowBack.do")public String addBookBorrowBack(BookBorrow bean) {try {Book book = service.getBookBySid(bean.getBook().getSid());if (book == null) {MessageUtil.addMessage(request, "图书编号不存在.");return ERROR;}if (book.getStatus().equals("在架")) {MessageUtil.addMessage(request, "图书已在架.");return ERROR;}bean.setBook(book);service.updateBookBorrowBack(bean);MessageUtil.addMessage(request, "还书成功.");return SUCCESS;} catch (Exception e) {e.printStackTrace();MessageUtil.addMessage(request, "还书失败.");return ERROR;}}@RequestMapping(value = "/addBookBorrowBackByUser.do")public String addBookBorrowBackByUser(BookBorrow bean) {try {Book book = (Book) service.get(Book.class, bean.getBook().getId());if (book == null) {MessageUtil.addMessage(request, "图书不存在.");return ERROR;}if (book.getStatus().equals("在架")) {MessageUtil.addMessage(request, "图书已在架.");return ERROR;}bean.setBook(book);service.updateBookBorrowBackUser(bean);MessageUtil.addRelMessage(request, "还书成功.", "mainquery");return SUCCESS;} catch (Exception e) {e.printStackTrace();MessageUtil.addMessage(request, "还书失败.");return ERROR;}}@RequestMapping(value = "/addBookBorrowRE.do")public String addBookBorrowRE(BookBorrow bean) {try {Book book = service.getBookBySid(bean.getBook().getSid());if (book == null) {MessageUtil.addMessage(request, "图书编号不存在.");return ERROR;}if (book.getStatus().equals("在架")) {MessageUtil.addMessage(request, "图书未外借.");return ERROR;}bean.setBook(book);service.updateBookBorrowRE(bean);MessageUtil.addMessage(request, "续借成功.");return SUCCESS;} catch (Exception e) {e.printStackTrace();MessageUtil.addMessage(request, "续借失败.");return ERROR;}}@RequestMapping(value = "/updateBookBorrow.do")public String update(BookBorrow bean) {try {service.update(bean);MessageUtil.addMessage(request, "更新成功.");return SUCCESS;} catch (Exception e) {e.printStackTrace();MessageUtil.addMessage(request, "更新失败.");return ERROR;}}@RequestMapping(value = "/updateBookBorrowScore.do")public String updateBookBorrowScore(BookBorrow bean) {try {BookBorrow temp = (BookBorrow) service.get(BookBorrow.class, bean.getId());temp.setScore(bean.getScore());service.update(temp);MessageUtil.addRelMessage(request, "更新成功.", "baseAdd");return SUCCESS;} catch (Exception e) {e.printStackTrace();MessageUtil.addMessage(request, "更新失败.");return ERROR;}}@RequestMapping(value = "/queryBookBorrow.do")public String query() {try {int pageNum = 0;String t = request.getParameter("pageNum");if (StringUtil.notEmpty(t)) {pageNum = Integer.valueOf(t);}Page p = (Page) session.getAttribute(Constant.SESSION_PAGE);if (pageNum == 0 || p == null) {p = new Page();p.setCurrentPageNumber(1);p.setTotalNumber(0l);p.setItemsPerPage(Constant.SESSION_PAGE_NUMBER);// 字段名称集合LinkedList<String> parmnames = new LinkedList<String>();// 字段值集合LinkedList<Object> parmvalues = new LinkedList<Object>();// 页面参数集合Set parm = request.getParameterMap().entrySet();for (Object o : parm) {Entry<String, Object> e = (Entry<String, Object>) o;String name = e.getKey();// 页面字段名称if (name.startsWith("s_")) {String fieldValue = request.getParameter(name);// 页面字段值if (StringUtil.notEmpty(fieldValue)) {name = name.substring(2, name.length());// 实体字段名称if ("user.user.uname".equals(name)) {parmnames.add(name);parmvalues.add(fieldValue);} else {parmnames.add(name);parmvalues.add(FieldUtil.format(BookBorrow.class, name, fieldValue));}}}}Object user = getSessionUser();if (user instanceof SimpleUser) {parmnames.add("user.id");SimpleUser su = (SimpleUser) user;parmvalues.add(su.getId());}SearchParamBean sbean = new SearchParamBean();sbean.setParmnames(parmnames);sbean.setParmvalues(parmvalues);p.setConditonObject(sbean);} else {p.setCurrentPageNumber(pageNum);}Page page = null;page = service.find(p, BookBorrow.class);session.setAttribute(Constant.SESSION_PAGE, page);return "sys/listBookBorrow";} catch (Exception e) {e.printStackTrace();return ERROR;}}}

5、前端代码示例