基于ssm(springmvc+spring+mybatis)框架开发的图书馆借阅系统,后台采用ssm框架,数据库采用mysql数据库。
其功能详情如下:图书借阅管理、办理借阅、借阅记录、预约借阅、借出未还、借阅逾期、学生管理、图书管理。
详情查看扣:2835777178
DROP TABLE IF EXISTS `tb_category`;
CREATE TABLE `tb_category` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`manager_id` int(10) NOT NULL,
`catName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '分类名称',
`parent_id` int(10) NULL DEFAULT NULL COMMENT '父目录id',
`is_parent` int(1) UNSIGNED ZEROFILL NOT NULL COMMENT '子目录',
`createDate` bigint(30) NOT NULL COMMENT '创建时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `mid`(`manager_id`) USING BTREE,
INDEX `parent_id`(`parent_id`) USING BTREE,
CONSTRAINT `mid` FOREIGN KEY (`manager_id`) REFERENCES `tb_manager` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of tb_category
-- ----------------------------
INSERT INTO `tb_category` VALUES (1, 1, '文艺', 0, 1, 1522910247);
INSERT INTO `tb_category` VALUES (8, 1, '文学', 0, 1, 1523877843);
INSERT INTO `tb_category` VALUES (9, 1, '教育', 0, 0, 1523877874);
INSERT INTO `tb_category` VALUES (10, 1, '生活', 0, 0, 1523877885);
INSERT INTO `tb_category` VALUES (11, 1, '成功/励志', 0, 0, 1523877896);
INSERT INTO `tb_category` VALUES (14, 1, '艺术', 8, 0, 1523878304);
-- ----------------------------
-- Table structure for tb_comment
-- ----------------------------
DROP TABLE IF EXISTS `tb_comment`;
CREATE TABLE `tb_comment` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NULL DEFAULT NULL,
`book_id` int(11) NOT NULL COMMENT '目标图书id',
`content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '内容',
INDEX `book_id`(`book_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of tb_comment
-- ----------------------------
INSERT INTO `tb_comment` VALUES (2, 1, 1, '孤独并不可怕,你害怕的是寂寞,所有让人快速成长的事,都是孤独的,孤独是我们跟世界相处的方式之一。学会跟孤独坦然相对。喜欢看踢踢的书,有一种恬静的生活态度,静静地品味人生品味自己。推荐踢踢的这本书哦《越孤独越自由》', 1522910247, 00000000000);
INSERT INTO `tb_comment` VALUES (6, 5, 23, '从你的全世界路过', 152