基于springboot 架构图书管理系统毕设附源码+数据库

/* Navicat Premium Data Transfer Source Server : 127.0.0.1 Source Server Type : MySQL Source Server Version : 50717 Source Host : localhost:3306 Source Schema : book Target Server Type : MySQL Target Server Version : 50717 File Encoding : 65001 Date: 25/02/2024 14:56:27 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for book -- ---------------------------- DROP TABLE IF EXISTS `book`; CREATE TABLE `book` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID主键', `author` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图书作者', `isbn` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图书ISBN编码', `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图书名称', `pages` int(11) NULL DEFAULT NULL COMMENT '图书页数', `price` double NULL DEFAULT NULL COMMENT '单价', `publish` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '出版社', `publish_time` datetime(6) NULL DEFAULT NULL COMMENT '出版时间', `size` int(11) NULL DEFAULT NULL COMMENT '库存', `translate` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '翻译', `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '分类', `collect` bigint(20) NULL DEFAULT 0 COMMENT '0，未收藏，1收藏', `book_desc` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '图书简介', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 50 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of book -- ---------------------------- INSERT INTO `book` VALUES (24, '托克维尔(Tocqueville)', 'CYA001', '政治哲学导论', 200, 50, '中国人民大学出版社', '2006-04-08 08:00:00.000000', 100, '无', '4', 1, NULL); INSERT INTO `book` VALUES (25, '安德鲁·海伍德', 'CYA002', '政治学核心概念', 500, 50, '天津人民出版社', '2008-09-05 08:00:00.000000', 200, '无', '4', 1, NULL); INSERT INTO `book` VALUES (26, '郭斌和、张竹明', 'CYA003', '理想国', 500, 30, '商务印书馆', '1986-09-04 09:00:00.000000', 300, '无', '4', 0, NULL); INSERT INTO `book` VALUES (27, '吴 彦', 'CYA004', '政治哲学名著译丛', 500, 60, '光线传媒出版社', '2022-09-26 08:00:00.000000', 200, '', '4', 1, NULL); INSERT INTO `book` VALUES (28, '王泽鉴', 'CYA005', '民法总则', 600, 60, '北京大学出版社', '2019-12-01 08:00:00.000000', 300, '无', '4', 1, NULL); INSERT INTO `book` VALUES (29, '王泽鉴', 'CYA006', '民法思维', 600, 20, '北京大学出版社', '2019-12-06 08:00:00.000000', 600, '', '4', 0, NULL); INSERT INTO `book` VALUES (30, '汉斯·布洛克斯', 'CYA007', '德国民法总论', 8001, 80, '中国人民大学出版社', '2014-09-01 08:00:00.000000', 125, '', '4', 1, NULL); INSERT INTO `book` VALUES (31, '马丁·海德格尔', 'CYA008', '存在与时间', 100, 10, '中国人民大学出版社', '2022-09-26 08:00:00.000000', 600, '无', '2', 0, NULL); INSERT INTO `book` VALUES (32, '伊曼努尔·康德', 'CYA009', '纯粹理性批判', 200, 35, '光线传媒出版社', '2022-09-26 08:00:00.000000', 600, '', '2', 1, NULL); INSERT INTO `book` VALUES (33, '陈明', 'CYA0010', '核心体能训练', 200, 35, '光线传媒出版社', '2022-09-26 08:00:00.000000', 200, '无', '3', 1, NULL); INSERT INTO `book` VALUES (34, '小名', 'CYA0011', '身体功能训练手册', 200, 35, '人民体育出版社', '2022-09-26 08:00:00.000000', 199, '', '3', 0, NULL); INSERT INTO `book` VALUES (35, '马克思、恩格斯', 'CYA0012', '共产党宣言', 8001, 80, '中国人民大学出版社', '2022-09-26 08:00:00.000000', 23, '', '1', 1, NULL); INSERT INTO `book` VALUES (36, '列宁', 'CYA0013', '俄国社会民主党人的任务', 200, 35, '中国人民大学出版社', '2022-09-26 08:00:00.000000', 499, '', '1', 1, NULL); INSERT INTO `book` VALUES (41, 'IM', '1231231', '11111', 1212, NULL, '', '2024-02-08 08:00:00.000000', NULL, '', '1', 1, NULL); INSERT INTO `book` VALUES (42, '322', '323', 'wweey', NULL, NULL, '', '2024-02-18 08:00:00.000000', NULL, '', '1', 0, NULL); INSERT INTO `book` VALUES (43, '322', '999', 'wweey', NULL, NULL, NULL, '2024-02-18 00:00:00.000000', NULL, NULL, '马克思列宁主义、毛泽东思想、邓小平理论', 1, NULL); INSERT INTO `book` VALUES (44, 'IM', '1999', '11111', 1212, NULL, NULL, '2024-02-08 00:00:00.000000', NULL, NULL, '马克思列宁主义、毛泽东思想、邓小平理论', 1, NULL); INSERT INTO `book` VALUES (45, '托克维尔(Tocqueville)', '2999', '政治哲学导论', 200, 50, '中国人民大学出版社', '2006-04-08 00:00:00.000000', 99, '无', '政治、法律', 0, NULL); INSERT INTO `book` VALUES (46, '123123', '978-7-02-013563-9', '奇风岁月', 123123, 12, '12', '2024-02-24 08:00:00.000000', 9, '1212', '4', 0, ''); INSERT INTO `book` VALUES (47, '史铁生', '978-7-02-013563-9', '我与地坛', 11, 35, '人民文学出版社', '2024-02-24 08:00:00.000000', 10, '中文', '3', 0, '本书收录了《我与地坛》《秋天的怀念》《死神的克星》《合欢树》《好运设计》《我二十一岁那年》《故乡的胡同》《墙下短记》等散文作品。'); INSERT INTO `book` VALUES (48, '苏芬', '978-7-02-013563-1112222', '计算机基础', 1, 1, '', '2024-02-24 08:00:00.000000', 1, '', '12222222', 0, ''); -- ---------------------------- -- Table structure for book_collect -- ---------------------------- DROP TABLE IF EXISTS `book_collect`; CREATE TABLE `book_collect` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id', `book_id` bigint(20) NULL DEFAULT NULL COMMENT '书籍id', `user_id` int(11) NULL DEFAULT NULL COMMENT '用户id', `book_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '书名', `collect_date` datetime(0) NULL DEFAULT NULL COMMENT '收藏日期', `collect_status` bigint(20) NULL DEFAULT 1 COMMENT '收藏', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 37 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of book_collect -- ---------------------------- INSERT INTO `book_collect` VALUES (17, 41, 4, '11111', '2024-02-18 11:03:17', 1); INSERT INTO `book_collect` VALUES (18, 41, 4, '11111', '2024-02-21 21:38:43', 1); INSERT INTO `book_collect` VALUES (19, 41, 4, '11111', '2024-02-21 21:38:43', 1); INSERT INTO `book_collect` VALUES (20, 41, 4, '11111', '2024-02-21 21:38:43', 1); INSERT INTO `book_collect` VALUES (21, 41, 4, '11111', '2024-02-21 21:38:43', 1); INSERT INTO `book_collect` VALUES (22, 36, 4, '俄国社会民主党人的任务', '2024-02-21 21:38:47', 1); INSERT INTO `book_collect` VALUES (23, 34, 47, '身体功能训练手册', '2024-02-24 17:18:55', 1); INSERT INTO `book_collect` VALUES (24, 32, 47, '纯粹理性批判', '2024-02-24 17:18:59', 1); INSERT INTO `book_collect` VALUES (25, 33, 47, '核心体能训练', '2024-02-24 17:19:03', 1); INSERT INTO `book_collect` VALUES (26, 35, 47, '共产党宣言', '2024-02-24 17:19:04', 1); INSERT INTO `book_collect` VALUES (27, 27, 47, '政治哲学名著译丛', '2024-02-24 17:19:08', 1); INSERT INTO `book_collect` VALUES (28, 30, 47, '德国民法总论', '2024-02-24 17:19:14', 1); INSERT INTO `book_collect` VALUES (29, 28, 47, '民法总则', '2024-02-24 17:19:18', 1); INSERT INTO `book_collect` VALUES (30, 43, 4, 'wweey', '2024-02-24 22:11:58', 1); INSERT INTO `book_collect` VALUES (32, 41, 40, '11111', '2024-02-24 22:38:31', 1); INSERT INTO `book_collect` VALUES (33, 48, 48, '计算机基础', '2024-02-24 23:43:38', 1); INSERT INTO `book_collect` VALUES (34, 25,