一、系统介绍
======
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