1.登录系统

2.用户-借阅书籍

3.管理员-图书管理

4.管理员-图书类型管理

5.管理员-读者管理

6.管理员-读者类型管理

7.管理员-借阅记录查看

三、部分代码

BookController

BookTypeController

LoginController

ReaderTypeController

四、其他

1.更多系统

Java+JSP系统系列实现

Java+Servlet系统系列实现

Java+SSM系统系列实现

Java+SSH系统系列实现

Java+Springboot系统系列实现

2.源码下载

3.备注

4.支持博主

一、系统介绍

======

1.开发环境

开发工具：IDEA2018

JDK版本：jdk1.8

Mysql版本：8.0.13

2.技术选型

Java+Spring+SpringMVC+Mybatis+Jsp+Mysql

3.系统功能

1.用户登录退出系统

2.用户借阅查看书籍

3.管理员登录退出系统

4.管理员对书籍的增删改查

5.管理员对书籍类型的增删改查

6.管理员对用户的增删改查

7.管理员对用户类型的增删改查

8.管理员查看借阅记录

4.数据库文件

/*

Navicat Premium Data Transfer

Source Server : MYSQL

Source Server Type : MySQL

Source Server Version : 80013

Source Host : localhost:3306

Source Schema : ssm_library_management

Target Server Type : MySQL

Target Server Version : 80013

File Encoding : 65001

Date: 12/12/2021 16:30:13

*/

SET NAMES utf8mb4;

SET FOREIGN_KEY_CHECKS = 0;

– Table structure for admin

DROP TABLE IF EXISTS <code>admin;

CREATE TABLE admin (

id bigint(4) NOT NULL AUTO_INCREMENT,

username varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

password varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

PRIMARY KEY (id) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

– Records of admin

INSERT INTO admin VALUES (1, ‘admin’, ‘admin’);

– Table structure for book

DROP TABLE IF EXISTS book;

CREATE TABLE book (

id bigint(4) NOT NULL AUTO_INCREMENT,

type varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

name varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

number varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

author varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

press varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

publicationdate date NULL DEFAULT NULL,

price decimal(10, 2) NULL DEFAULT NULL,

pagecount int(4) NULL DEFAULT NULL,

keyword varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

createtime date NULL DEFAULT NULL,

isborrow int(4) NULL DEFAULT NULL,

remark varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

PRIMARY KEY (id) USING BTREE,

INDEX BOOK_PK(type) USING BTREE,

CONSTRAINT BOOK_PK FOREIGN KEY (type) REFERENCES booktype (number) ON DELETE CASCADE ON UPDATE CASCADE

) ENGINE = InnoDB AUTO_INCREMENT = 27 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

– Records of book

INSERT INTO book VALUES (14, ‘bt004’, ‘大雪中的山庄’, ‘b001’, '东野圭吾 ', ‘北京十月文艺出版社’, ‘2018-06-16’, 36.00, 200, NULL, NULL, 0, ‘1’);

INSERT INTO book VALUES (16, ‘bt004’, ‘特工皇妃’, ‘b004’, ‘潇湘冬儿’, ‘江苏文艺出版社’, ‘2011-05-05’, 74.80, 333, NULL, NULL, 0, NULL);

INSERT INTO book VALUES (17, ‘bt006’, ‘人类简史’, ‘b005’, '[以色列] 尤瓦尔·赫拉利 ', ‘中信出版社’, ‘2014-11-01’, 68.00, 100, NULL, NULL, 0, NULL);

INSERT INTO book VALUES (18, ‘bt006’, ‘明朝那些事儿（1-9）’, ‘b006’, '当年明月 ', ‘中国海关出版社’, ‘2009-04-06’, 358.20, 500, NULL, NULL, 0, NULL);

INSERT INTO book VALUES (19, ‘bt002’, ‘经济学原理（上下）’, ‘b007’, '[美] 曼昆 ', ‘机械工业出版社’, ‘2003-08-05’, 88.00, 156, NULL, NULL, 0, NULL);

INSERT INTO book VALUES (20, ‘bt004’, ‘方向’, ‘b008’, '马克-安托万·马修 ', ‘北京联合出版公司’, ‘2017-04-01’, 99.80, 186, NULL, NULL, 0, NULL);

INSERT INTO book VALUES (21, ‘bt004’, ‘画的秘密’, ‘b009’, '马克-安托万·马修 ', ‘北京联合出版公司’, ‘2016-01-01’, 60.00, 556, NULL, NU