基于nodejs的面向图书共享设计与实现-计算机毕业设计源码+LW文档

开发语言：nodejs
框架：Express
数据库：mysql 5.7（一定要5.7版本）
数据库工具：Navicat11
开发软件：VS code/HBuilder X
浏览器：谷歌浏览器

数据库：

DROP TABLE IF EXISTS `config`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `config` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(100) NOT NULL COMMENT '配置参数名称',
  `value` varchar(100) DEFAULT NULL COMMENT '配置参数值',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='配置文件';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `config`
--

LOCK TABLES `config` WRITE;
/*!40000 ALTER TABLE `config` DISABLE KEYS */;
INSERT INTO `config` VALUES (1,'picture1','upload/picture1.jpg'),(2,'picture2','upload/picture2.jpg'),(3,'picture3','upload/picture3.jpg');
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `dianzixinxiziyuan`
--

DROP TABLE IF EXISTS `dianzixinxiziyuan`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dianzixinxiziyuan` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `ziyuanmingcheng` varchar(200) DEFAULT NULL COMMENT '资源名称',
  `ziyuanleixing` varchar(200) DEFAULT NULL COMMENT '资源类型',
  `ziyuantupian` varchar(200) DEFAULT NULL COMMENT '资源图片',
  `ziyuanwenjian` varchar(200) DEFAULT NULL COMMENT '资源文件',
  `ziyuanjieshao` longtext COMMENT '资源介绍',
  `faburiqi` date DEFAULT NULL COMMENT '发布日期',
  `yonghuming` varchar(200) DEFAULT NULL COMMENT '用户名',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8 COMMENT='电子信息资源';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dianzixinxiziyuan`
--

LOCK TABLES `dianzixinxiziyuan` WRITE;
/*!40000 ALTER TABLE `dianzixinxiziyuan` DISABLE KEYS */;
INSERT INTO `dianzixinxiziyuan` VALUES (51,'2022-04-07 13:08:48','资源名称1','资源类型1','upload/dianzixinxiziyuan_ziyuantupian1.jpg','','资源介绍1','2022-04-07','用户名1'),(52,'2022-04-07 13:08:48','资源名称2','资源类型2','upload/dianzixinxiziyuan_ziyuantupian2.jpg','','资源介绍2','2022-04-07','用户名2'),(53,'2022-04-07 13:08:48','资源名称3','资源类型3','upload/dianzixinxiziyuan_ziyuantupian3.jpg','','资源介绍3','2022-04-07','用户名3'),(54,'2022-04-07 13:08:48','资源名称4','资源类型4','upload/dianzixinxiziyuan_ziyuantupian4.jpg','','资源介绍4','2022-04-07','用户名4'),(55,'2022-04-07 13:08:48','资源名称5','资源类型5','upload/dianzixinxiziyuan_ziyuantupian5.jpg','','资源介绍5','2022-04-07','用户名5'),(56,'2022-04-07 13:08:48','资源名称6','资源类型6','upload/dianzixinxiziyuan_ziyuantupian6.jpg','','资源介绍6','2022-04-07','用户名6');
/*!40000 ALTER TABLE `dianzixinxiziyuan` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `discussdianzixinxiziyuan`
--

DROP TABLE IF EXISTS `discussdianzixinxiziyuan`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discussdianzixinxiziyuan` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `refid` bigint(20) NOT NULL COMMENT '关联表id',
  `userid` bigint(20) NOT NULL COMMENT '用户id',
  `nickname` varchar(200) DEFAULT NULL COMMENT '用户名',
  `content` longtext NOT NULL COMMENT '评论内容',
  `reply` longtext COMMENT '回复内容',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=137 DEFAULT CHARSET=utf8 COMMENT='电子信息资源评论表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `discussdianzixinxiziyuan`
--

LOCK TABLES `discussdianzixinxiziyuan` WRITE;
/*!40000 ALTER TABLE `discussdianzixinxiziyuan` DISABLE KEYS */;
INSERT INTO `discussdianzixinxiziyuan` VALUES (131,'2022-04-07 13:08:48',1,1,'用户名1','评论内容1','回复内容1'),(132,'2022-04-07 13:08:48',2,2,'用户名2','评论内容2','回复内容2'),(133,'2022-04-07 13:08:48',3,3,'用户名3','评论内容3','回复内容3'),(134,'2022-04-07 13:08:48',4,4,'用户名4','评论内容4','回复内容4'),(135,'2022-04-07 13:08:48',5,5,'用户名5','评论内容5','回复内容5'),(136,'2022-04-07 13:08:48',6,6,'用户名6','评论内容6','回复内容6');
/*!40000 ALTER TABLE `discussdianzixinxiziyuan` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `discusstushuxinxi`
--

DROP TABLE IF EXISTS `discusstushuxinxi`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discusstushuxinxi` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `refid` bigint(20) NOT NULL COMMENT '关联表id',
  `userid` bigint(20) NOT NULL COMMENT '用户id',
  `nickname` varchar(200) DEFAULT NULL COMMENT '用户名',
  `content` longtext NOT NULL COMMENT '评论内容',
  `reply` longtext COMMENT '回复内容',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=117 DEFAULT CHARSET=utf8 COMMENT='图书信息评论表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `discusstushuxinxi`
--

LOCK TABLES `discusstushuxinxi` WRITE;
/*!40000 ALTER TABLE `discusstushuxinxi` DISABLE KEYS */;
INSERT INTO `discusstushuxinxi` VALUES (111,'2022-04-07 13:08:48',1,1,'用户名1','评论内容1','回复内容1'),(112,'2022-04-07 13:08:48',2,2,'用户名2','评论内容2','回复内容2'),(113,'2022-04-07 13:08:48',3,3,'用户名3','评论内容3','回复内容3'),(114,'2022-04-07 13:08:48',4,4,'用户名4','评论内容4','回复内容4'),(115,'2022-04-07 13:08:48',5,5,'用户名5','评论内容5','回复内容5'),(116,'2022-04-07 13:08:48',6,6,'用户名6','评论内容6','回复内容6');
/*!40000 ALTER TABLE `discusstushuxinxi` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `discussyonghufenxiang`
--

DROP TABLE IF EXISTS `discussyonghufenxiang`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discussyonghufenxiang` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `refid` bigint(20) NOT NULL COMMENT '关联表id',
  `userid` bigint(20) NOT NULL COMMENT '用户id',
  `nickname` varchar(200) DEFAULT NULL COMMENT '用户名',
  `content` longtext NOT NULL COMMENT '评论内容',
  `reply` longtext COMMENT '回复内容',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=127 DEFAULT CHARSET=utf8 COMMENT='用户分享评论表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `discussyonghufenxiang`
--

LOCK TABLES `discussyonghufenxiang` WRITE;
/*!40000 ALTER TABLE `discussyonghufenxiang` DISABLE KEYS */;
INSERT INTO `discussyonghufenxiang` VALUES (121,'2022-04-07 13:08:48',1,1,'用户名1','评论内容1','回复内容1'),(122,'2022-04-07 13:08:48',2,2,'用户名2','评论内容2','回复内容2'),(123,'2022-04-07 13:08:48',3,3,'用户名3','评论内容3','回复内容3'),(124,'2022-04-07 13:08:48',4,4,'用户名4','评论内容4','回复内容4'),(125,'2022-04-07 13:08:48',5,5,'用户名5','评论内容5','回复内容5'),(126,'2022-04-07 13:08:48',6,6,'用户名6','评论内容6','回复内容6');
/*!40000 ALTER TABLE `discussyonghufenxiang` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `forum`
--

DROP TABLE IF EXISTS `forum`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `forum` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `title` varchar(200) DEFAULT NULL COMMENT '帖子标题',
  `content` longtext NOT NULL COMMENT '帖子内容',
  `parentid` bigint(20) DEFAULT NULL COMMENT '父节点id',
  `userid` bigint(20) NOT NULL COMMENT '用户id',
  `username` varchar(200) DEFAULT NULL COMMENT '用户名',
  `isdone` varchar(200) DEFAULT NULL COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHARSET=utf8 COMMENT='社区交流';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `forum`
--

LOCK TABLES `forum` WRITE;
/*!40000 ALTER TABLE `forum` DISABLE KEYS */;
INSERT INTO `forum` VALUES (71,'2022-04-07 13:08:48','帖子标题1','帖子内容1',0,1,'用户名1','开放'),(72,'2022-04-07 13:08:48','帖子标题2','帖子内容2',0,2,'用户名2','开放'),(73,'2022-04-07 13:08:48','帖子标题3','帖子内容3',0,3,'用户名3','开放'),(74,'2022-04-07 13:08:48','帖子标题4','帖子内容4',0,4,'用户名4','开放'),(75,'2022-04-07 13:08:48','帖子标题5','帖子内容5',0,5,'用户名5','开放'),(76,'2022-04-07 13:08:48','帖子标题6','帖子内容6',0,6,'用户名6','开放');
/*!40000 ALTER TABLE `forum` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `messages`
--

DROP TABLE IF EXISTS `messages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `messages` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `userid` bigint(20) NOT NULL COMMENT '留言人id',
  `username` varchar(200) DEFAULT NULL COMMENT '用户名',
  `content` longtext NOT NULL COMMENT '留言内容',
  `cpicture` varchar(200) DEFAULT NULL COMMENT '留言图片',
  `reply` longtext COMMENT '回复内容',
  `rpicture` varchar(200) DEFAULT NULL COMMENT '回复图片',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=utf8 COMMENT='联系我们';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `messages`
--

LOCK TABLES `messages` WRITE;
/*!40000 ALTER TABLE `messages` DISABLE KEYS */;
INSERT INTO `messages` VALUES (101,'2022-04-07 13:08:48',1,'用户名1','留言内容1','upload/messages_cpicture1.jpg','回复内容1','upload/messages_rpicture1.jpg'),(102,'2022-04-07 13:08:48',2,'用户名2','留言内容2','upload/messages_cpicture2.jpg','回复内容2','upload/messages_rpicture2.jpg'),(103,'2022-04-07 13:08:48',3,'用户名3','留言内容3','upload/messages_cpicture3.jpg','回复内容3','upload/messages_rpicture3.jpg'),(104,'2022-04-07 13:08:48',4,'用户名4','留言内容4','upload/messages_cpicture4.jpg','回复内容4','upload/messages_rpicture4.jpg'),(105,'2022-04-07 13:08:48',5,'用户名5','留言内容5','upload/messages_cpicture5.jpg','回复内容5','upload/messages_rpicture5.jpg'),(106,'2022-04-07 13:08:48',6,'用户名6','留言内容6','upload/messages_cpicture6.jpg','回复内容6','upload/messages_rpicture6.jpg');
/*!40000 ALTER TABLE `messages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `news`
--

DROP TABLE IF EXISTS `news`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `news` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `title` varchar(200) NOT NULL COMMENT '标题',
  `introduction` longtext COMMENT '简介',
  `picture` varchar(200) NOT NULL COMMENT '图片',
  `content` longtext NOT NULL COMMENT '内容',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=97 DEFAULT CHARSET=utf8 COMMENT='公告信息';
/*!40101 SET character_set_client = @saved_cs_client */;

如需定做或者获取更多资料，请联系QQ：375279829