Java源码社

基于javaweb的SSM前台+后台精品图书管理系统(java+ssm+jsp+mysql)

更新于

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

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

适用

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

功能说明

430023262402

440023262402

460023262402

470023262402

基于javaweb的SSM前台+后台精品图书管理系统(java+ssm+jsp+mysql)

一、项目简述

功能包括： 登录注册，办理借阅。借阅记录，预约借阅，借出未还, 借阅逾期，学生管理，图书管理，书库分类查询搜索。

二、项目运行

环境配置： Jdk1.8 + Tomcat8.5 + mysql + Eclispe (IntelliJ IDEA,Eclispe,MyEclispe,Sts 都支持)

项目技术： JSP +Spring + SpringMVC + MyBatis + html+ css + JavaScript + JQuery + Ajax +等等。

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
 **/
@Controller
@RequestMapping("/user")
public class user_userSystemController {
    @Autowired
    private user_userSystem user_userSystem;

    //重置用户密码
    @RequestMapping("/resetPwd")
    public String resetPassword(Model model, Integer id, String oldPassword, String newPassword, String newPassword2) throws Exception {
        String msg;
        String url;
        //判断输入的值是否为空
        if ("".equals(oldPassword) || oldPassword == null || "".equals(newPassword) || newPassword == null || "".equals(newPassword2) || newPassword2 == null) {
            msg = "不能有空值";
            url = "/user/user_resetPassword.action";
            model.addAttribute("msg", msg);
            model.addAttribute("url", url);
            return "user/error";
        }
        //判断两次输入的密码是否正确
        if (!newPassword.equals(newPassword2)) {
            msg = "两次新密码不一致";
            url = "/user/user_resetPassword.action";
            model.addAttribute("msg", msg);
            model.addAttribute("url", url);
            return "user/error";
        }
        //如果都正确，传入旧密码和新密码到service层进行校验
        TbUserRestInfoL tbUserRestInfoL = new TbUserRestInfoL();
        tbUserRestInfoL.setPassword(oldPassword);
        tbUserRestInfoL.setNewPassword(newPassword);
        tbUserRestInfoL.setId(id);

        int result = this.user_userSystem.updateUserPassword(tbUserRestInfoL);
        //返回值0 表示通过传入的id为找到用户
        if (0 == result) {
            msg = "未找到该用户！";
            url = "/user/user_resetPassword.action";
            model.addAttribute("msg", msg);
            model.addAttribute("url", url);
            return "user/error";
        }

        //返回值2 用户输入的旧密码和数据库中的密码不匹配
        if (2 == result) {
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
        //进行数据回显
        model.addAttribute("tbUser", tbUser);
        return "admin/loan_editUser";
    }


    //用户删除
    @RequestMapping("/loan_deleteUser")
    public String loan_deleteUser(Integer id) {
        int i = loan_userInfoList.deleteUser(id);
        if (i > 0) {
            return "redirect:loan_userList.action";
        }
        return "redirect:loan_userList.action";
    }

    //用户添加
    @RequestMapping("/loan_addUser")
    public String addUser(TbUser tbUser) {
        //注册时间
        tbUser.setRegisterdate(System.currentTimeMillis());
        //not online
        tbUser.setIsonline(0);
        tbUser.setPassword(tbUser.getUsername());
        int i = loan_userInfoList.addUser(tbUser);
        if (i > 0) {
            System.out.println("添加成功！");
            return "redirect:loan_userList.action";
        }

        return "redirect:loan_userList.action";
    }

    //用户列表模糊查询用户信息(用户名)
    @RequestMapping("/loan_selectLikeName")
    public String Loan_selectLikeName(TbUser tbUser, Model model) {
        Integer online = null;
        TbUserQueryVo tbUserQueryVo = new TbUserQueryVo();
        tbUserQueryVo.setTbUser(tbUser);
        tbUserQueryVo.setOnline(online);
        List<TbUser> userList = loan_userInfoList.selectLikeName(tbUserQueryVo);
        model.addAttribute("userList", userList);
        return "admin/loan_userList";
    }
}
package controller.admin.loanList;

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42

/**
 * @description: 图书服务实现类
 *
 */

@Service
public class LibraryServiceImpl implements LibraryService {
    // 注入
    @Autowired
    private TbLibraryAndManagerMapper libraryAndManagerMapper;
    @Autowired
    private TbLibraryMapper libraryMapper;
    @Autowired
    private TbCommentMapper commentMapper;
    @Autowired
    private TbOrderMapper orderMapper;
    @Autowired
    private TbRecordMapper recordMapper;
    @Autowired
    private TbReplyMapper replyMapper;

    @Value("${CURRENT_PAGE}")
    private String CURRENT_PAGE;    // 默认 当前页数
    @Value("${PAGE_ROWS}")
    private String PAGE_ROWS;       // 默认 每页显示记录数
    @Value("${FILE_SAVE_PATH}")     // 默认 上传文件保存路径
    private String FILE_SAVE_PATH;


    @Override
    public PageCount<TblibraryExt> findLibraryByAll(TbLibraryQuery tbLibraryQuery, PageCount pageCount) {
        // 判断 分页数据的 有效性
        if (tbLibraryQuery == null) {
            tbLibraryQuery = new TbLibraryQuery();
            tbLibraryQuery.setBookname("");
        }

        if (pageCount == null) {
            pageCount = new PageCount();
            pageCount.setCurrentPage(Integer.parseInt(CURRENT_PAGE));
            pageCount.setPageRows(Integer.parseInt(PAGE_ROWS));
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
private Loan_management loan_management;

@RequestMapping("/loan/outTimeList")
public String outTimeList(Model model, Integer currentPage) throws Exception {
    LoanOutTimeL loanOutTimeL = new LoanOutTimeL();
    //如果传入的有页面
    if (currentPage != null) {
        loanOutTimeL.setCurrentPage(currentPage);
    }
    //查询数据和分页，并返回
    pageL pageL = this.loan_management.findOutTimeList(loanOutTimeL);
    List<LoanOutTimeL> outTimeList = (List<LoanOutTimeL>) pageL.getPo();

    model.addAttribute("pageL", pageL);
    model.addAttribute("outTimeList", outTimeList);
    return "admin/loan_outtime";
}

//借阅逾期搜索列表
@RequestMapping("/loan/searchOutTimeList")
public String searchOutTimeList(Model model, String searchSelect, String searchKeyWord, Integer currentPage) throws Exception {
    //实例化包装类（包装类中在原有类的基础上添加的column（列名称）和keyword（搜索关键字）两个字段）
    LoanOutTimeL loanOutTimeL = new LoanOutTimeL();
    loanOutTimeL.setColumn(searchSelect);
    loanOutTimeL.setKeyWord(searchKeyWord);
    //如果传入的有页面
    if (currentPage != null) {
        loanOutTimeL.setCurrentPage(currentPage);
    }
    //查询数据和分页，并返回
    pageL pageL = this.loan_management.findOutTimeList(loanOutTimeL);
    List<LoanOutTimeL> outTimeList = (List<LoanOutTimeL>) pageL.getPo();

    model.addAttribute("pageL", pageL);
    model.addAttribute("outTimeList", outTimeList);
    return "admin/loan_outtime";
}

//    归还图书
@RequestMapping("/loan/outTimeReturnBook")
public String returnBook(Model model, String id) throws Exception {
    //将借阅id和状态码存入 扩展类中
    loanStatusL loanStatusL = new loanStatusL();
    loanStatusL.setId(id);
    loanStatusL.setStatus("1");
    //调用更改借阅状态的service方法
    this.loan_management.changLoanStatus(loanStatusL);

    return "redirect:/admin/loan/outTimeList.action";
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45

@Value("${CURRENT_PAGE}")
private String CURRENT_PAGE;            // 默认当前页

@Value("${PAGE_ROWS}")
private String PAGE_ROWS;               // 默认每页条数


@Override
public List<TbCategory> getCategoryAll() {
    // 设置查询条件
    TbCategoryExample categoryExample = new TbCategoryExample();
    // 执行查询
    return categoryMapper.selectByExample(categoryExample);
}

@Override
public PageCount<TbCategoryExt> getCategoryAllWithParentName(PageCount pageCount) {
    // 设置查询条件
    TbCategoryExample categoryExample = new TbCategoryExample();
    // 判断页面参数 是否有效
    if (pageCount.getCurrentPage() == null) {
        pageCount.setCurrentPage(Integer.parseInt(CURRENT_PAGE));
    }
    if (pageCount.getPageRows() == null) {
        pageCount.setPageRows(Integer.parseInt(PAGE_ROWS));
    }

    // 分页插件
    PageHelper.startPage(pageCount.getCurrentPage(), pageCount.getPageRows());

    // 获取列表集合
    List<TbCategory> categoryList = categoryMapper.selectByExample(categoryExample);

    // 获取 分页详细信息
    PageInfo<TbCategory> pageInfo = new PageInfo<>(categoryList);
    // 数据总数
    pageCount.setTotalRows(pageInfo.getTotal());
    // 总页数
    pageCount.setTotalPages(pageInfo.getPages());


    // 扩展 pojo 封装
    List<TbCategoryExt> categoryExts = new ArrayList<>();

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
        pageCount.setPageRows(Integer.parseInt(PAGE_ROWS));
    }
    if (pageCount.getCurrentPage() == null) {
        pageCount.setCurrentPage(Integer.parseInt(CURRENT_PAGE));
    }
    if (pageCount.getPageRows() == null) {
        pageCount.setPageRows(Integer.parseInt(PAGE_ROWS));
    }

    PageHelper.startPage(pageCount.getCurrentPage(), pageCount.getPageRows());

    List<TblibraryExt> tblibraryExts = new ArrayList<>();
    // 判断是否为 0
    if (tbLibraryQuery.getCateId() == 0) {
        // 获取图书列表
        tblibraryExts = libraryAndManagerMapper.findAll(tbLibraryQuery);
    } else {
        // 获取图书列表
        tblibraryExts = libraryAndManagerMapper.findLibraryByCriteria(tbLibraryQuery);
    }

    // 获取 页数,查询记录数 的详细信息
    PageInfo<TblibraryExt> pageInfo = new PageInfo<>(tblibraryExts);

    pageCount.setTotalPages(pageInfo.getPages());
    pageCount.setTotalRows(pageInfo.getTotal());
    pageCount.setContentList(tblibraryExts);

    return pageCount;
}

@Override
public TbLibrary findLibraryByBid(int id) {
    // 通过 主键id 查询图书信息
    return libraryMapper.selectByPrimaryKey(id);
}

@Override
public String updateOrSaveLibrary(MultipartFile uploadFile, TbLibrary library, HttpServletRequest request) throws IOException {
    // 上传文件保存 路径
    String FILE_SAVE_PATH=request.getSession().getServletContext().getRealPath("/upload/book");;
    String fileSavePath = UploadFileUtilsByBook.updateLibrary(uploadFile, FILE_SAVE_PATH);
    // 修改 图书信息

项目链接：
https://javayms.github.io?id=581422302105200hh
https://javayms.pages.dev?id=581422302105200hh