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

2022-10-31 21:59 作者:计算机毕业设计大神888 0人读过 | 我要投稿

开发语言：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 '图片',