基于SSM图书馆管理系统

淩亂°似流年 2023-10-07 12:13 66阅读 0赞

![format_png][]

愚昧者怨天尤人，无能者长吁短叹，儒弱者颓然放弃。

## 基于SSM图书馆管理系统 ##

welcome rodert

需要项目请直接到文章末尾获取

简介

project introduction

**springboot**、mybatis、bootstrap、mysql 开发的图书馆管理系统（适合新手）

学习springboot时写的这个系统，技术比较简单，注释简洁清楚，适合新手学习理解。整个项目采用的是 springboot、mybatis、jsp，另外手写了登录过滤器。

技术 - 环境

*build*

技术：

使用常用技术springboot+mybatis+jsp。

开发环境：

jdk8+tomcat8+mysql+IntelliJ IDEA+maven。

## 功能模块 ##

*function*

写功能

图书馆管理系统包含管理员和学生俩种用户角色

## 项目 ##

*project*

项目截图

![image.png][]

## 图示展示 ##

*show*

管理员模块

module

*welcome*

管理员可对 图书信息、用户信息、借阅信息 进行 增删改查 操作，管理员账户，可以重置非管理员账户的密码

\* 图书管理：当有新上架的图书时，在系统添加图书信息，供学生借阅  
\* 用户管理：添加用户时，其信息也会添加到登录表中  
\* 管理员管理：同上  
\* 账户密码重置：  
\* 修改密码：

![image.png][image.png 1]

![image.png][image.png 2]

![image.png][image.png 3]

用户模块

module

*welcome*

用户登录后，根据用户信息，获取其已经选择的图书，和已经借阅的图书

\* 首页: 在这里借阅图书，选好后，将会自动跳转到已选图书选项

\* 图书借阅: 这里显示的是所有图书，用户可以选择没有被借阅的书籍进行借阅

\* 我的借阅: 显示用户已经借阅的书籍，解决时间等图书详细信息

\* 修改密码:

![image.png][image.png 4]

![image.png][image.png 5]

##  ##

SQL:\{\}

/*
     Navicat Premium Data Transfer
     
     Source Server         : localhost
     Source Server Type    : MySQL
     Source Server Version : 50560
     Source Host           : localhost:3306
     Source Schema         : library
     
     Target Server Type    : MySQL
     Target Server Version : 50560
     File Encoding         : 65001
     
     Date: 21/09/2019 21:26:46
    */
     
    SET NAMES utf8mb4;
    SET FOREIGN_KEY_CHECKS = 0;
     
    -- ----------------------------
    -- Table structure for admins
    -- ----------------------------
    DROP TABLE IF EXISTS `admins`;
    CREATE TABLE `admins`  (
      `aid` int(11) NOT NULL AUTO_INCREMENT,
      `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
      `stuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
      `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
      PRIMARY KEY (`aid`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;
     
    -- ----------------------------
    -- Records of admins
    -- ----------------------------
    INSERT INTO `admins` VALUES (2, '最代码', 'zuidaima', '96e79218965eb72c92a549dd5a330112');
    INSERT INTO `admins` VALUES (3, '王五', 'wangwu', '96e79218965eb72c92a549dd5a330112');
    
     
    -- ----------------------------
    -- Table structure for book
    -- ----------------------------
    DROP TABLE IF EXISTS `book`;
    CREATE TABLE `book`  (
      `bid` int(11) NOT NULL AUTO_INCREMENT,
      `bookname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
      `author` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
      `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
      `publisher` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
      `publicationdate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
      `price` int(11) DEFAULT NULL,
      `state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
      `comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
      PRIMARY KEY (`bid`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;
     
    -- ----------------------------
    -- Records of book
    -- ----------------------------
    INSERT INTO `book` VALUES (1, '斗破苍穹', '脑残土豆', '玄幻', '起点', '2012-04-06', 20, '2', '无');
    INSERT INTO `book` VALUES (2, '武动乾坤', '脑残土豆', '玄幻', '起点', '2012-04-06', 20, '2', '无');
    INSERT INTO `book` VALUES (3, '元尊', '脑残土豆', '玄幻', '起点', '2012-04-06', 20, '2', '无');
    INSERT INTO `book` VALUES (4, '斗罗大陆', '唐三', '玄幻', '起点', '2012-04-06', 20, '2', '无');
    INSERT INTO `book` VALUES (6, '绝世唐门', '唐三', '玄幻', '起点', '2012-04-06', 20, '2', '无');
    INSERT INTO `book` VALUES (7, '龙王传说', '唐三', '玄幻', '起点', '2012-04-06', 20, '1', '无');
    INSERT INTO `book` VALUES (9, '神墓', '辰东', '玄幻', '起点', '2019-08-14', 23, '1', '无');
    INSERT INTO `book` VALUES (10, '盗墓笔记', '南派三叔', '悬疑', '起点', '2019-08-07', 45, '1', '无');
    INSERT INTO `book` VALUES (11, '鬼吹灯', '霸唱天下', '悬疑', '起点', '2019-08-07', 45, '1', '无');
    
     
    -- ----------------------------
    -- Table structure for borrow
    -- ----------------------------
    DROP TABLE IF EXISTS `borrow`;
    CREATE TABLE `borrow`  (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `borrower` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
      `borrowtime` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
      `bookname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
      `bid` int(11) DEFAULT NULL,
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 27 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;
     
    -- ----------------------------
    -- Records of borrow
    -- ----------------------------
    INSERT INTO `borrow` VALUES (21, 'jack', '2019-08-19', '斗破苍穹', 1);
    INSERT INTO `borrow` VALUES (22, 'jack', '2019-08-19', '武动乾坤', 2);
    INSERT INTO `borrow` VALUES (23, 'rose', '2019-08-19', '元尊', 3);
    INSERT INTO `borrow` VALUES (24, 'rose', '2019-08-19', '斗罗大陆', 4);
    INSERT INTO `borrow` VALUES (25, 'javaniu', '2019-09-21', '绝世唐门', 6);
     
    -- ----------------------------
    -- Table structure for user
    -- ----------------------------
    DROP TABLE IF EXISTS `user`;
    CREATE TABLE `user`  (
      `uid` int(11) NOT NULL AUTO_INCREMENT,
      `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
      `sex` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
      `tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
      `institute` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
      `profession` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
      `classname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
      `stuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
      `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
      PRIMARY KEY (`uid`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;
     
    -- ----------------------------
    -- Records of user
    -- ----------------------------
    INSERT INTO `user` VALUES (3, 'rick', '男', '18090093154', '能源学院', '石油工程', '3班', '1198495155', '96e79218965eb72c92a549dd5a330112');
    INSERT INTO `user` VALUES (4, 'jack', '男', '18090093154', '能源学院', '石油工程', '3班', '123', '96e79218965eb72c92a549dd5a330112');
    INSERT INTO `user` VALUES (5, 'javaniu', '女', '18090093154', '能源学院', '石油工程', '3班', 'javaniu', '96e79218965eb72c92a549dd5a330112');
     
    SET FOREIGN_KEY_CHECKS = 1;

jar：\{\}

链接：https://pan.baidu.com/s/1JLi3kJk3zIr0NIXMt3bwpg  
提取码：qchn

公众号自取

![20190619113941644.jpg][]![20200405145016559.png][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzc0NjA0_size_16_color_FFFFFF_t_70][]

[format_png]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWFnZTIuMTM1ZWRpdG9yLmNvbS9jYWNoZS9yZW1vdGUvYUhSMGNITTZMeTl0YldKcGVpNXhiRzluYnk1amJpOXRiV0pwZWw5d2JtY3ZXVlY1V2pkQlQwd3piMnd5VUdKSE5VOW1WRGxyV0dOMVNrSnhaVE5NVUVsV2JXNU5Tak5sTVdKclRuTlpObmxaVURSbE5tSkRhV0pXUkdGeGVteDJhV014WWtSMVZVRkdia0ZqV1cxUVFVVlNiRWR3WW5JeWR5OHc?x-oss-process=image/format,png
[image.png]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9iZG4uMTM1ZWRpdG9yLmNvbS9maWxlcy91c2Vycy8zNjUvMzY1MjM4Mi8yMDIwMDQvTmF5d1NlSGJfcUY2Ni5wbmc?x-oss-process=image/format,png
[image.png 1]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9iZG4uMTM1ZWRpdG9yLmNvbS9maWxlcy91c2Vycy8zNjUvMzY1MjM4Mi8yMDIwMDQvWkFGcDQ2T0tfTGpBSC5wbmc?x-oss-process=image/format,png
[image.png 2]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9iZG4uMTM1ZWRpdG9yLmNvbS9maWxlcy91c2Vycy8zNjUvMzY1MjM4Mi8yMDIwMDQvNTlTcW04c2pfN0RiVC5wbmc?x-oss-process=image/format,png
[image.png 3]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9iZG4uMTM1ZWRpdG9yLmNvbS9maWxlcy91c2Vycy8zNjUvMzY1MjM4Mi8yMDIwMDQvTEdRWkRuMnNfSlZFVy5wbmc?x-oss-process=image/format,png
[image.png 4]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9iZG4uMTM1ZWRpdG9yLmNvbS9maWxlcy91c2Vycy8zNjUvMzY1MjM4Mi8yMDIwMDQvSjIzNHdFcWNfOEdLZy5wbmc?x-oss-process=image/format,png
[image.png 5]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9iZG4uMTM1ZWRpdG9yLmNvbS9maWxlcy91c2Vycy8zNjUvMzY1MjM4Mi8yMDIwMDQvejJ4ZFE1ODlfeng0Ui5wbmc?x-oss-process=image/format,png
[20190619113941644.jpg]: https://img-blog.csdnimg.cn/20190619113941644.jpg
[20200405145016559.png]: https://img-blog.csdnimg.cn/20200405145016559.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzc0NjA0_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20210126142038867.jpg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzc0NjA0,size_16,color_FFFFFF,t_70