基于Springboot+mybatis+mysql+html图书管理系统

一、系统介绍

该系统实现了
普通用户：
图书查询、借书，还书、个人信息修改、个人信息查看
管理员：
图书管理、用户管理、废除记录

二、功能展示

1.用户登陆

在这里插入图片描述

2.用户主页

在这里插入图片描述

3.图书查询

在这里插入图片描述

4.还书

在这里插入图片描述

5.个人信息修改

在这里插入图片描述

6.图书管理（管理员）

在这里插入图片描述

7.学生管理（管理员）

在这里插入图片描述

8.废除记录（管理员）

在这里插入图片描述

三、数据库

/*
 Navicat Premium Data Transfer

 Source Server         : test
 Source Server Type    : MySQL
 Source Server Version : 80021
 Source Host           : localhost:3306
 Source Schema         : books_master

 Target Server Type    : MySQL
 Target Server Version : 80021
 File Encoding         : 65001

 Date: 16/06/2022 12:42:07
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for abolish_records
-- ----------------------------
DROP TABLE IF EXISTS `abolish_records`;
CREATE TABLE `abolish_records`  (
  `re_Abolish_id` int(0) NOT NULL AUTO_INCREMENT,
  `re_book_id` int(0) NULL DEFAULT NULL,
  `re_book_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `re_book_press` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `re_book_author` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`re_Abolish_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of abolish_records
-- ----------------------------
INSERT INTO `abolish_records` VALUES (1, 5, '物联网', '科学出版社', '刘云浩');
INSERT INTO `abolish_records` VALUES (2, 6, 'java初级编程', '人民教育出版社', '李四');

-- ----------------------------
-- Table structure for admin_info
-- ----------------------------
DROP TABLE IF EXISTS `admin_info`;
CREATE TABLE `admin_info`  (
  `admin_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `admin_passwo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`admin_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of admin_info
-- ----------------------------
INSERT INTO `admin_info` VALUES ('123@qq.com', '123');
INSERT INTO `admin_info` VALUES ('admin', '123');

-- ----------------------------
-- Table structure for book_info
-- ----------------------------
DROP TABLE IF EXISTS `book_info`;
CREATE TABLE `book_info`  (
  `book_id` int(0) NOT NULL AUTO_INCREMENT,
  `book_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `book_press` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `book_author` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `book_number` int(0) NULL DEFAULT NULL,
  `book_type_id` int(0) NULL DEFAULT NULL,
  PRIMARY KEY (`book_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of book_info
-- ----------------------------
INSERT INTO `book_info` VALUES (1, '嫌疑人X的献身', 'sss出版社', '东野圭吾', 136, 2);
INSERT INTO `book_info` VALUES (2, '香水', '上海译文出版社', '帕·聚斯金德', 84, 2);
INSERT INTO `book_info` VALUES (3, 'javaEE', '人民邮电出版社', '黑马程序员', 49, 3);
INSERT INTO `book_info` VALUES (4, '数据结构', '电子工业出版社', '叶和亚', 53, 3);

-- ----------------------------
-- Table structure for book_type_info
-- ----------------------------
DROP TABLE IF EXISTS `book_type_info`;
CREATE TABLE `book_type_info`  (
  `book_type_id` int(0) NOT NULL AUTO_INCREMENT,
  `book_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`book_type_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of book_type_info
-- ----------------------------
INSERT INTO `book_type_info` VALUES (1, '恐怖');
INSERT INTO `book_type_info` VALUES (2, '悬疑');
INSERT INTO `book_type_info` VALUES (3, '教学');

-- ----------------------------
-- Table structure for borrow_info
-- ----------------------------
DROP TABLE IF EXISTS `borrow_info`;
CREATE TABLE `borrow_info`  (
  `borrow_id` int(0) NOT NULL AUTO_INCREMENT,
  `borrow_time` datetime(0) NULL DEFAULT NULL,
  `borrow_estimate` datetime(0) NULL DEFAULT NULL,
  `borrow_return_time` datetime(0) NULL DEFAULT NULL,
  `book_id` int(0) NULL DEFAULT NULL,
  `stu_number` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`borrow_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of borrow_info
-- ----------------------------
INSERT INTO `borrow_info` VALUES (1, '2021-12-21 21:12:44', '2021-12-31 21:12:44', '2021-12-22 10:48:32', 2, '209050133');
INSERT INTO `borrow_info` VALUES (2, '2021-12-21 21:12:45', '2021-12-31 21:12:45', NULL, 3, '209050133');
INSERT INTO `borrow_info` VALUES (3, '2021-12-22 10:48:06', '2022-01-01 10:48:06', NULL, 1, '209050133');
INSERT INTO `borrow_info` VALUES (4, '2022-01-05 12:32:13', '2022-01-15 12:32:13', '2022-01-05 12:32:32', 1, '209050133');
INSERT INTO `borrow_info` VALUES (5, '2022-01-05 12:32:14', '2022-01-15 12:32:14', NULL, 1, '209050133');
INSERT INTO `borrow_info` VALUES (6, '2022-01-05 12:32:14', '2022-01-15 12:32:14', NULL, 1, '209050133');
INSERT INTO `borrow_info` VALUES (7, '2022-01-05 12:32:15', '2022-01-15 12:32:15', NULL, 1, '209050133');
INSERT INTO `borrow_info` VALUES (8, '2022-01-05 12:32:15', '2022-01-15 12:32:15', NULL, 1, '209050133');
INSERT INTO `borrow_info` VALUES (9, '2022-01-05 12:32:15', '2022-01-15 12:32:15', NULL, 1, '209050133');
INSERT INTO `borrow_info` VALUES (10, '2022-06-11 22:41:31', '2022-06-21 22:41:31', NULL, 1, '123456');
INSERT INTO `borrow_info` VALUES (11, '2022-06-16 07:31:16', '2022-06-26 07:31:16', NULL, 2, '20210820001');

-- ----------------------------
-- Table structure for stu_info_book
-- ----------------------------
DROP TABLE IF EXISTS `stu_info_book`;
CREATE TABLE `stu_info_book`  (
  `stu_id` int(0) NOT NULL AUTO_INCREMENT,
  `stu_number` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `stu_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `stu_sex` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `stu_nation` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `stu_birth` date NULL DEFAULT NULL,
  `stu_hometown` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `stu_admission_time` date NULL DEFAULT NULL,
  `stu_faculty` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `stu_post` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`stu_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of stu_info_book
-- ----------------------------
INSERT INTO `stu_info_book` VALUES (1, '20210802000', '沈骅', '女', '苗族', '2021-12-21', '湖州', '2020-09-23', '信息工程学院', '学生');
INSERT INTO `stu_info_book` VALUES (2, '20210802002', '郏会', '男', '汉族', '2001-11-30', '浙江台州', '2020-09-23', '信息工程学院学院', '学生');
INSERT INTO `stu_info_book` VALUES (3, '20210820001', '1', '1', '1', '2020-01-01', '1', '2020-01-01', '1', '1');
INSERT INTO `stu_info_book` VALUES (4, '20210080003', '张三', '男', '汉', '2003-09-01', '广东', '2019-09-01', '计算机系', '');

-- ----------------------------
-- Table structure for user_info
-- ----------------------------
DROP TABLE IF EXISTS `user_info`;
CREATE TABLE `user_info`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `stu_number` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `user_password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user_info
-- ----------------------------
INSERT INTO `user_info` VALUES (1, '20210802134', '123');
INSERT INTO `user_info` VALUES (2, '20210802000', '123');
INSERT INTO `user_info` VALUES (3, '20210802002', '123');
INSERT INTO `user_info` VALUES (4, '20210820001', '123');
INSERT INTO `user_info` VALUES (5, '20210080003', '123');

SET FOREIGN_KEY_CHECKS = 1;

四、获取源码

点击下载
基于Springboot+mybatis+mysql+html图书管理系统

# mysql # spring boot # java
Logo
魔乐社区

魔乐社区（Modelers.cn) 是一个中立、公益的人工智能社区，提供人工智能工具、模型、数据的托管、展示与应用协同服务，为人工智能开发及爱好者搭建开放的学习交流平台。社区通过理事会方式运作，由全产业链共同建设、共同运营、共同享有，推动国产AI生态繁荣发展。

更多推荐

cover

【计算机视觉】Pixel逐像素分类&Mask掩码分类理解摘要

avatar 魔乐社区

计算机视觉（opencv）实战三十二——CascadeClassifier 人脸微笑检测（摄像头）

本文从原理到实现，详细介绍了基于 OpenCV Haar 分类器的人脸与微笑检测：讲解了 Haar 特征和级联检测原理。对代码逐行拆解并解释参数含义。画出完整流程图，帮助理解执行过程。给出了常见问题和优化建议，甚至扩展到深度学习方法。这种方法简单、轻量、实时性好，非常适合入门和小型应用项目。但如果需要更高准确率和更强鲁棒性，建议使用深度学习检测器替代 Haar 分类器。

avatar 魔乐社区
cover

小杰机器学习（seven）——贝叶斯分类

avatar 魔乐社区