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
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
版权归原作者 2401_84094029 所有， 如有侵权，请联系我们删除。